14 Nov
2008
14 Nov
'08
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/