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

[raj1126]

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.


Please help me guys... or please link to some tutorial on web, becoz i tried and didn't find anything. thanks in advance

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

[DXS]

What script are you using for your site?

[raj1126]

i'm using vbulletin. VPS is having 512 MB RAM

[DXS]

On Line 46 in your config.php change the value from false to true

Before:

$config['Database']['force_sql_mode'] = false; 

After:

$config['Database']['force_sql_mode'] = true; 

If it isn't that, then you may need to optimize your tables.

[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......

[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?

[Rapid4All]

hmm, try to optimize your my.cnf
nano /etc/my.cnf

If you are not sure about those value, you can use mysqltuner.pl, its not perfect but it gives us good advices

Also, you should read this thread, have some useful infomation there
http://www.besthostingforums.com/showthread.php?t=12287

[l0calh0st]

Try to access phpmyadmin, optimize tables and restart sql server.

[Gavo]

Buy some more ram

it could be a problem with your host overselling VPS's though

[vgnheart]

turn off apache . repair and optimize the database. then enable apache.also optimize ur my.cnf values