Hi,
Also, keep in mind that, with the code you`re using, you`re creating empty
wikis. In practice, when using (copying) a template or a flavour/extension
(future feature done with the Extension Manager), your wiki creation times
will grow considerably. Basically all you are testing now is the creation
of databases and a document (the wiki descriptor). Each empty wiki
practically consists of these 2 elements: 1) the database 2) the
descriptor. Of course, when creating the database, some basic wiki classes
are also created automatically, so you can add them to the count :)
Anyway, nice experiment! Thanks for sharing!
Would be nice to see more of these on XWiki's features.
Cheers,
Eduard
On Fri, Dec 13, 2013 at 4:19 PM, Jean SIMARD <jean.simard(a)xwiki.com> wrote:
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 <jean.simard(a)xwiki.com>
> 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 <jean.simard(a)xwiki.com>
> >
> > > 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
> devs(a)xwiki.org
>
http://lists.xwiki.org/mailman/listinfo/devs
>
_______________________________________________
devs mailing list
devs(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/devs
_______________________________________________
devs mailing list
devs(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/devs
_______________________________________________
devs mailing list
devs(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/devs