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