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 > -- S pozdravem Lukáš Raška _______________________________________________ devs mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/devs
