2011/11/5 Yang Li <[email protected]>
于 2011/11/5 13:56, Ludovic Dubost 写道:
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<rmuntyan@**softserveinc.com<[email protected]>
That is another guy's :)
I am Yang Li, I tried ?xpage=contentview in the URL, no more queries! So the store.cache works properly! So, there must be some other reasons for the profile page to be slow to load (still 6-10 seconds) for those users with more activities.
I tried to post all my configuration files (xwiki.cfg, xwiki.properties, hibernate.xml), but the mail size gets to large.
According to http://platform.xwiki.org/**xwiki/bin/view/AdminGuide/** Performances<http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Performances>, I am currently trying to set up a apache server for the gzip compression and cache for static htmls. Hope there would be some performance improvement.
This won't do much. How fast is the activity page with ?xpage=contentview in the URL. This is the core activity stream time
Thanks. Example here
http://www.ow2.org/view/Admin/**CheckIndexes?viewer=code<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:users-bounces@xwiki.**org<[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<rmuntyan@**softserveinc.com<[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<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<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<http://lists.xwiki.org/mailman/listinfo/users>
______________________________**_________________ users mailing list [email protected] http://lists.xwiki.org/**mailman/listinfo/users<http://lists.xwiki.org/mailman/listinfo/users> ______________________________**_________________ users mailing list [email protected] http://lists.xwiki.org/**mailman/listinfo/users<http://lists.xwiki.org/mailman/listinfo/users>
______________________________**_________________ users mailing list [email protected] http://lists.xwiki.org/**mailman/listinfo/users<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