I am on a CentOS Linux 5.2 box (P4 3.4ghz, 3 gigs of RAM) that is running vbulletin 3.7.2. I can provide more details but I am looking for someone that is an experienced server admin. I need help because we experience high mysql utilization at times (mysql will grab 90% of the cpu and I am not sure why). Will pay for help -- please let me know your rate information and if you have a site detaling your experience. Thanks!
You might want to first try and post at the vbulletin forum for server optimization, they can give you parameters which would help.
I suggest go full server optimization by a qualified server admin. We have help another client who run a very big vbulletin and his site load up much much faster than before.
I can take a look if you'd like, but as yogesh said, I would post at vb.com for several optimziation, that way you don't have to spend any $ After that, feel free to give me a pm, here are some of our past clients.
You need to optimize your server, especially mysql. If it doesn't help, you need to upgrade to a faster server.
Thanks everyone. I already did the server optimization from vb.org. As far as a faster server goes, I have time that server load is very low and mysql is at 90%. I don't think it is as simple as just processing power.
I have a suspicion that these spikes in CPU usage by MySQL are being caused by spikes in traffic to your forum. Sudden spikes like this are usually either caused by being linked from a big site like Digg or by a bot. If it's a bot, you might want to evaluate whether you want to ban it entirely or just throttle it. Have a look in your Apache logs at the same time that these spikes are occurring to see if there's a corresponding spike in we traffic and where it's coming from. It can also be very handy to install mytop on your database server. Mytop is a perl script written by JWZ which acts just like top does for processes but it works for MySQL queries. You may find that the spikes are just caused by a single user doing searches.
Buddy ill give u 1 tip ... Disable your plugins and than see how your cpu usage goes... Even i used to face similar problems but when i disabled one of my plugins things became better
Well the best way to diagnose is by running the following command to see what is going on with mysql # mysqladmin processlist Also what about /etc/my.cnf , is it optimized ?