I'm a bit confused. Is it the same install as Yang Li or a different one ? Are you seeing the queries in the mysql log when you reload a simple page or a page with ?xpage=contentview in the URL ?
Ludovic 2011/11/4 Roman Muntyanu <rmunt...@softserveinc.com> > Thanks. Example here > http://www.ow2.org/view/Admin/CheckIndexes?viewer=code shows places > requiring change (for those who might need it someday) > > After updating the check index page it now says > * Indexes created for wiki xwiki_utf8_innodb > > Request to Main.WebHome still takes 24 seconds for admin account. > > -----Original Message----- > From: users-boun...@xwiki.org [mailto:users-boun...@xwiki.org] On Behalf > Of Ludovic Dubost > Sent: Friday, November 04, 2011 23:14 PM > To: XWiki Users > Cc: users@xwiki.org > Subject: Re: [xwiki-users] Activity performance is slow > > Cache is enabled by default. It's not ehcache but JBoss cache > > This is probably because you don't have indexes. The Script has 3 > occurrences ok 'xwiki' which you should change to your db name > > Envoyé de mon iPhone > > Le 4 nov. 2011 à 21:18, coldserenity <rmunt...@softserveinc.com> a écrit : > > > Ludovic, thanks for the handy tips, but ... I need some more :) > > > > I have installed the Admin Tool and it mentioned that indexes were not > > created. > > So before creating indexes I have decided to upgrade table engine from > > MyIsam to InnoDB as Sergiu has suggested in this post > > http://xwiki.475771.n2.nabble.com/Upgrade-to-3-2-minor-issues-td688396 > > 5.html After the change the overall time to load main XWiki page as > > administrator has gone from 5 to 25 seconds. My wiki currently is 1100 > > documents in count and 400M in size. > > > > Quick questions: > > * is caching enabled by default? > > * is caching limiting done simply by document count or by allocated > > memory (as most recent EHCache allows)? > > > > After the upgrade, I receive following error on "XWiki Database > > Indexes Check" page > > * Failed to check indexes for wiki xwiki: Table > > 'xwiki.xwikiattrecyclebin' doesn't exist I think this is related to > > fact that my database name is "xwiki_utf8_innodb" > > and not "xwiki", because I receive similar results on "MySQL Encoding > Check" > > page > > * Failed to check xwikidoc encoding for wiki xwiki: Unknown database > > 'xwiki' > > * Failed to check xwikidoc encoding or collation for wiki xwiki: > > Table 'xwiki.xwikidoc' doesn't exist but I don't know where to change > > that parameter to proper value - velocity scripts are overcrowded with > > 'xwiki' strings. > > > > > > > > -- > > View this message in context: > > http://xwiki.475771.n2.nabble.com/Activity-performance-is-slow-tp69618 > > 05p6964056.html Sent from the XWiki- Users mailing list archive at > > Nabble.com. > > _______________________________________________ > > 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 > _______________________________________________ > users mailing list > users@xwiki.org > http://lists.xwiki.org/mailman/listinfo/users > -- Ludovic Dubost Founder and CEO Blog: http://blog.ludovic.org/ XWiki: http://www.xwiki.com Skype: ldubost GTalk: ldubost _______________________________________________ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users