Re: [xwiki-users] [xwiki 3.2] virtual user big performance issues

On Wed, May 16, 2012 at 9:03 AM, Merlin Olivier <Olivier.MERLIN(a)gemalto.com> wrote: > Ok - please follow this link: > http://dl.dropbox.com/u/19876503/exception_list.xlsx > I suspect we have something wrong in the installation. Would be better to have the log. Exception out of context is not always helpful.

> > Best regards, > Olivier > > -----Original Message----- > From: users-bounces(a)xwiki.org [mailto:users-bounces@xwiki.org] On > Behalf Of Thomas Mortagne > Sent: Wednesday, May 16, 2012 8:52 AM > To: XWiki Users > Subject: Re: [xwiki-users] [xwiki 3.2] virtual user big > performance issues > > On Tue, May 15, 2012 at 6:55 PM, Merlin Olivier <Olivier.MERLIN(a)gemalto.com> wrote: >> Hello Vincent, >> >> I have recreated the indexes on one multiwiki ... and I get the >> same performance results Each page are loaded in 4-5 seconds. >> In fact there was an improvement in the DB usage but it was not a lot before. >> The API breakdown shows me: >> - 1200 ms in the classloading >> - 930 ms in the XML processing >> - 580 ms for the xwiki API >> - 420 ms for JDBC >> - 350 ms for wiki model >> (...) >> >> The problem of performance is really on the application server code response time - not in the database. >> - the problem could be in the big amount of exception raised (is >> it normal ?) > > No it's not normal and yes it's probably related. > >> - Glassfish 3.1 issues ? We use a 64bits deployment with a sun >> jdk1.6.0_26 Xms = Xmx = 2Gb >> - 3.2 version >> - the HW not sufficient ? We use a VMware with a Redhat Linux 5.7 >>        - 2 core CPU ( X5650  @ 2.67GHz ) >>        - 4Go RAM >> >> Any ideas ? Good config to test ? >> My next ideas would be : >> - migrate to Weblogic >> - migrate to xwiki 4.x >> >> I can send you all the list of exception - it consumes a lot of CPU for me ... > > Yes please or put them somewhere and send the link. > >> >> >> Thanks for your help >> Olivier >> >> >> >> >> -----Original Message----- >> From: users-bounces(a)xwiki.org [mailto:users-bounces@xwiki.org] On >> Behalf Of Vincent Massol >> Sent: Tuesday, May 15, 2012 5:56 PM >> To: XWiki Users >> Subject: Re: [xwiki-users] [xwiki 3.2] virtual user big >> performance issues >> >> Hi Merlin, >> >> On May 15, 2012, at 5:41 PM, Merlin Olivier wrote: >> >>> Hello, >>> >>> On the xwiki  3.2, we have decided to use the virtual xwiki >>> (multi-tenant) feature as it should be better for scalability >>> and performance >>> http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Virtualizati >>> on >>> >>> >>> "Each wiki has its own database schema, thus allowing for a complete data separation between the different wikis in the same instance. >>> >>> The main advantage of multi-tenancy is performance optimization." >>> Problem: >>> The main wiki has a relative good level of performance - with a >>> response time around 2.5 second to browse a page So we are in >>> the xwiki database But when we are in a virtual wiki (another schema ) - the performance are very poor. >>> The average response time is around 5 seconds  per page !!! So at list 2 times slower. >>> >>> We are using MySQL and glassfish 3.1 - and we have done tuning on the MySQL database and glassfish. >>> >>> We have used a profiling tool and see that the request send to the virtual environment are raising a big amount of exception ... >>> The problem is not on the database part (even if they are many >>> SQL calls to visualize only one page) The problem seems really to be on the virtual environment configuration OR in a file corruption ... >>> >>> I have attached the exception list . (exception_list.xls) From >>> this is it possible to know if we have an installation issue ?? >>> >>> Does someone have experience of very good performance with xwiki >>> ? ( response time #1second per page) In that case >> >> I can tell you fore sure that there's no performance issue with multiwikis. Each wiki has its own DBs so it's really fast. >> >> Maybe you don't have indexes set on the subwikis? I think we started setting them automatically in XE 3.2 but it's worth checking, see: >> http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Database+Admi >> ni >> str >> ation >> >> Thanks >> -Vincent >> >> _______________________________________________ >> users mailing list >> users(a)xwiki.org >> http://lists.xwiki.org/mailman/listinfo/users >> _______________________________________________ >> users mailing list >> users(a)xwiki.org >> http://lists.xwiki.org/mailman/listinfo/users > > > > -- > Thomas Mortagne > _______________________________________________ > users mailing list > users(a)xwiki.org > http://lists.xwiki.org/mailman/listinfo/users > _______________________________________________ > users mailing list > users(a)xwiki.org > http://lists.xwiki.org/mailman/listinfo/users -- Thomas Mortagne