UBB.threads PHP Forum Software Community Forums Resources and Customizing Admin Zone Forum Slow

I'm currently hosting a forum (http://forum.canadianparents.com/ubbthreads/) which runs UBBThreads Version: 7.2 and the site is extremely slow. The server has 4GB ram and 2 dual core Xeon 5120 @ 1.86GHz. The server load is quit high

top - 11:25:05 up 14:17, 1 user, load average: 27.50, 26.13, 26.55
Tasks: 150 total, 30 running, 120 sleeping, 0 stopped, 0 zombie
Cpu(s): 40.1%us, 55.1%sy, 0.0%ni, 0.0%id, 0.0%wa, 0.2%hi, 4.6%si, 0.0%st
Mem: 4142000k total, 2296872k used, 1845128k free, 100324k buffers
Swap: 738948k total, 4356k used, 734592k free, 1333804k cached


Below is the relevent section of my apache.conf:
Timeout 300
KeepAlive On
MaxKeepAliveRequests 10000
KeepAliveTimeout 3

<IfModule mpm_prefork_module>
StartServers 5
MinSpareServers 5
MaxSpareServers 10
ServerLimit 350
MaxClients 256
MaxRequestsPerChild 1000
</IfModule>

netstat -anp | grep -i :80 | wc -l
~500

I'm running Ubuntu 8.10, PHP 5.2.6-2ubuntu4.2 with Suhosin-Patch 0.9.6.2 and Apache/2.2.9, mysql 5.0.67-0ubuntu6-log

Any feedback would be greatly appreciated

Michael Barlow

When looking at your 'top' info, what processes seem to be taking up the majority of the processor time?

Also, what does your mysql.cnf file look like? That's probably the first thing to look at since if it's a stock config or poorly configured on a larger forum that's probably the culprit.

I'd have a look at mysqltuner. It's a very handy tool that you can download, install and run to help see what configuration variables you should look at.