On Wed, May 16, 2012 at 9:40 AM, Thomas Mortagne <thomas.morta...@xwiki.com> wrote: > On Wed, May 16, 2012 at 9:37 AM, Thomas Mortagne > <thomas.morta...@xwiki.com> wrote: >> On Wed, May 16, 2012 at 9:03 AM, Merlin Olivier >> <olivier.mer...@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. > > Most of the "Can't find descriptor for the component" are perfectly > normal and have nothing to do with multiwiki you should have exactly > the same in single wiki. > > I tough you got lots of exceptions in the log but those are normal > exceptions which are never logged. If you don't get anything in the > log then all that is probably normal. >
The "No row with the given identifier exists" are probably not expected but hard to tell out of context. >> >>> >>> Best regards, >>> Olivier >>> >>> -----Original Message----- >>> From: users-boun...@xwiki.org [mailto:users-boun...@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.mer...@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-boun...@xwiki.org [mailto:users-boun...@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/Virtualization >>>>> >>>>> >>>>> "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+Administr >>>> ation >>>> >>>> Thanks >>>> -Vincent >>>> >>>> _______________________________________________ >>>> users mailing list >>>> users@xwiki.org >>>> http://lists.xwiki.org/mailman/listinfo/users >>>> _______________________________________________ >>>> users mailing list >>>> users@xwiki.org >>>> http://lists.xwiki.org/mailman/listinfo/users >>> >>> >>> >>> -- >>> Thomas Mortagne >>> _______________________________________________ >>> users mailing list >>> users@xwiki.org >>> http://lists.xwiki.org/mailman/listinfo/users >>> _______________________________________________ >>> users mailing list >>> users@xwiki.org >>> http://lists.xwiki.org/mailman/listinfo/users >> >> >> >> -- >> Thomas Mortagne > > > > -- > Thomas Mortagne -- Thomas Mortagne _______________________________________________ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users