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 <[email protected]>
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: [email protected] [mailto:[email protected]] On Behalf Of Ludovic Dubost Sent: Friday, November 04, 2011 23:14 PM To: XWiki Users Cc: [email protected] 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 <[email protected]> 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 [email protected] http://lists.xwiki.org/mailman/listinfo/users
users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users _______________________________________________ users mailing list [email protected] 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