5 Nov
2011
5 Nov
'11
8:07 a.m.
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 <yang.lee.cool(a)gmail.com>
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 写道:
--
Ludovic Dubost
Founder and CEO
Blog: http://blog.ludovic.org/
XWiki: http://www.xwiki.com
Skype: ldubost GTalk: ldubost
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<rmuntyan@softserveinc.com>
Thanks. Example here
______________________________**_________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/**mailman/listinfo/users<http://lists.xwiki.org/m…
http://www.ow2.org/view/Admin/**CheckIndexes?viewer=code<http://www.ow2.…
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-bounces(a)xwiki.org
[mailto:users-bounces@xwiki.**org<users-bounces@xwiki.org>]
On Behalf
Of Ludovic Dubost
Sent: Friday, November 04, 2011 23:14 PM
To: XWiki Users
Cc: users(a)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<rmuntyan@**softserveinc.com<rmuntyan@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<http://xwiki.475771.n2.nabble.com/Upgrade-to-3-2-minor-i…
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-s…
05p6964056.html Sent from the XWiki- Users mailing list archive at
Nabble.com.
______________________________**_________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/**mailman/listinfo/users<http://lists.xwiki.org/m…
______________________________**_________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/**mailman/listinfo/users<http://lists.xwiki.org/m…
______________________________**_________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/**mailman/listinfo/users<http://lists.xwiki.org/m…