5 Nov
2011
5 Nov
'11
7:07 a.m.
于 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(a)softserveinc.com>
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, 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.
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-bounces(a)xwiki.org [mailto: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(a)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(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users