It is normal that there should be some queries for the activity macro. The results are real time. The caching is for reading detailed document information. It's surprising that you are getting queries for a normal view of a page particularly with all panels removed. What queries do you get in the mysql log on the activity stream with ?xpage=contentview Ludovic 2011/11/5 Yang Li <[email protected]>
Wait! I tried a simple page with ?xpage=contentview in the URL just now with no more queries. However, when I tried my profile page with ?xpage=contentview in the URL, there are still many mysql queries and took a long time! It seems that the store.cache works for other pages without activity macro but not pages with activity macro...
于 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]>
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