mysql usage 99.8%|Site Not Loading|Please help to optimize

[raj1126]

thanks for the help DXS
well, after editing the congig.php, the site is loading now but mem% of mysql is still more than 3......

raj1126 Reviewed by raj1126 on 10th Nov 2010. mysql usage 99.8%|Site Not Loading|Please help to optimize hello guys, mysql usage is more than 99%, and site is not loading due to it. I have tried rebooting the VPS, but it soon start using 99% and site again goes down. http://lulzimg.com/i9/1d3cc486.png Please help me guys... or please link to some tutorial on web, becoz i tried and didn't find anything. thanks in advance Rating: 5

[Jack-T]

thanks for the help DXS
well, after editing the congig.php, the site is loading now but mem% of mysql is still more than 3......

Then values are incorrect. your cpu might be high due to it being a VPS,
Have you tried doing the following?

cat /proc/cpuinfo

Seeing how many cores you have and the hosts CPU.

How many users does your site have?
Are you using a control panel?