Hi, I'll probably need to make it work on a MySQL for the final project but I keep MariaDB and Percona (I didn't know this one) in mind for other projects, thanks :-)
-- Jean On ven., 2013-12-13 at 12:50 +0100, Lukáš Raška wrote: > If you wanna test only XWiki, you should consider using MariaDB or even > Percona instead of MySQL (so you can lower your chance being limited by > database). > > MariaDB and Percona both uses XtraDB (improved InnoDB by Percona), but > Percona should be more "stable" in such stress tests. > > > 2013/12/13 Jean SIMARD <[email protected]> > > > Hi, > > > > I didn't look well but I can say one thing. In the first method, when > > the around-250 subwikis are reached, the log is displaying errors for > > the next few minutes without stopping. As discussed with Thomas, we may > > think this is OutOfMemory error due to HSQLDB but it's probably not > > because of the second method that show that I can create more than 600 > > subwikis (the second method is more likely to be an OutOfMemory error > > looking the time evolution, I really should have look more carefully the > > logs!). > > I may try later on a MySQL server. > > > > Thanks, > > -- > > Jean > > > > > > On ven., 2013-12-13 at 10:54 +0100, Guillaume Fenollar wrote: > > > Hi, > > > > > > Good initiative. Have you checked the logs? Are you sure the database > > > (HSQLDB here) is not the problem? > > > Perhaps you'll want to run the same tests with a more robust database, > > like > > > postgreSQL or even MySQL ? > > > > > > Have fun! > > > > > > Guillaume Fenollar > > > > > > > > > 2013/12/12 Jean SIMARD <[email protected]> > > > > > > > Hi, > > > > > > > > I need to create a lot of subwikis in a XWiki instance > > (5.3-milestone-2) > > > > for a project and was interested in the possibilities and limits of > > > > XWiki. I tried to make a basic stress test to evaluate a maximum > > number > > > > of subwikis that XWiki can handle. > > > > I wrote a small report and provide files used on this link: > > > > http://hole.tuziwo.info/stress-test-xwiki-for-subwikis-creation.html > > > > > > > > I'll be happy to have feedback on that. For example, I would like to > > > > know if my first method do something bad or if this is a possible bug > > in > > > > XWiki. If this is a bug, I hope this can be improved since I think that > > > > I will need more than 1000 subwikis in my project. > > > > > > > > Hope this helps. > > > > Sincerely, > > > > -- > > > > Jean > > > > > > > > _______________________________________________ > > > > devs mailing list > > > > [email protected] > > > > http://lists.xwiki.org/mailman/listinfo/devs > > > > > > > _______________________________________________ > > > devs mailing list > > > [email protected] > > > http://lists.xwiki.org/mailman/listinfo/devs > > > > _______________________________________________ > > devs mailing list > > [email protected] > > http://lists.xwiki.org/mailman/listinfo/devs > > > > > _______________________________________________ devs mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/devs
