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

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:

...

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.

-- Ludovic Dubost Blog: http://blog.ludovic.org/ XWiki: http://www.xwiki.com Skype: ldubost GTalk: ldubost