14 Nov
2008
14 Nov
'08
6:02 p.m.
Hello,
I'm running an xwiki farm with 3 xwikis. Even when loading a simple
text page, the request is very slow.
I'm running on a CentOS box, using java in Tomcat and a mysql
database. Mysql usually hits 99.9% CPU and hangs there for a while.
Tomcat goes to about 50%.
We have it authenticating against an LDAP server, but the slowness
occurs even when loading the login screen.
I've turned off global statistics.
Any ideas as to what might be going on?
Sam
14 Nov
14 Nov
6:09 p.m.
Hi Samuel,
This is really strange since the DB is almost not doing anything on
our typical installs.
Here are some tips:
http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Performances
I'd suggest checking:
* That you have indexes set correctly
* That you have stats turned off (they are quite DB-hungry)
Thanks
-Vincent
On Nov 14, 2008, at 6:02 PM, Samuel Lee wrote:
Hello,
I'm running an xwiki farm with 3 xwikis. Even when loading a simple
text page, the request is very slow.
I'm running on a CentOS box, using java in Tomcat and a mysql
database. Mysql usually hits 99.9% CPU and hangs there for a while.
Tomcat goes to about 50%.
We have it authenticating against an LDAP server, but the slowness
occurs even when loading the login screen.
I've turned off global statistics.
Any ideas as to what might be going on?
Sam
6:22 p.m.
Samuel Lee wrote:
Hello,
I'm running an xwiki farm with 3 xwikis. Even when loading a simple
text page, the request is very slow.
I'm running on a CentOS box, using java in Tomcat and a mysql
database. Mysql usually hits 99.9% CPU and hangs there for a while.
Tomcat goes to about 50%.
We have it authenticating against an LDAP server, but the slowness
occurs even when loading the login screen.
I've turned off global statistics.
Any ideas as to what might be going on?
You should see what queries are running on the database, and how much
time they take.
As Vincent said, indexes are very important when the number of documents
increases.
--
Sergiu Dumitriu
http://purl.org/net/sergiu/
17 Nov
17 Nov
12:03 a.m.
Also make sure you give sufficient memory to java if you did not change
the default memory settings..
250Mb to 500Mb
Ludovic
Sergiu Dumitriu wrote:
Samuel Lee wrote:
--
Ludovic Dubost
Blog: http://blog.ludovic.org/
XWiki: http://www.xwiki.com
Skype: ldubost GTalk: ldubost
Hello,
I'm running an xwiki farm with 3 xwikis. Even when loading a simple
text page, the request is very slow.
I'm running on a CentOS box, using java in Tomcat and a mysql
database. Mysql usually hits 99.9% CPU and hangs there for a while.
Tomcat goes to about 50%.
We have it authenticating against an LDAP server, but the slowness
occurs even when loading the login screen.
I've turned off global statistics.
Any ideas as to what might be going on?
You should see what queries are running on the database, and how much
time they take.
As Vincent said, indexes are very important when the number of documents
increases.
5836
days inactive
5838
days old
3 comments
4 participants
participants (4)
-
Ludovic Dubost -
Samuel Lee -
Sergiu Dumitriu -
Vincent Massol