Why is your max connections only 75? Are you running out of connections? Do your logs indicate this?
How about httpd connections/children? What is this set to? Are you running out? Getting MaxConnections errors in httpd error logs?
Who is mysql running as? user "mysql" or? what is this user's ulimit? Running out of file descriptors? Need to change the ulimit?
What does the error log say?
Next time it's loaded log into mysql and run this: SHOW PROCESSLIST
What does that say? Run it from command line, not phpmyadmin. You'll want to see if you have a large number of tables locked and waiting.
I assume that 18g drive is SCSI and is keeping up? when you run top do you see a few processes in D wait state? Is it mysqld or httpd that's running the load up?
On the board itself, is it set to show all days by default or just the last two weeks? The lower it's set by default the less there is to sort.
How many posts do you have stored?
Can you update apache and/or mysql?
On it's face that would
seem to be enough machine there, but there is a whole lot of information missing, a lot of blanks that need to be filled in before we can give you more advice.
Honor The Victims
