mysql eating 50-70% of cpu load

[imrannazir]

Hello all server admin please help me ,my vps having high load and when load reach upto 90% it crashes mysql then i have to restart mysql to make my website run ..


im totally noob in server thing someone told me to enter command TOP in order to see your ram and cpu usage

when i see it (as picture above) it shwoing 50% of just mysql usage sometimes it goes upto 60%

and this is crashing my website in every 10 minutes

HELP NEEDED

 

[Cheetah]

Chances are

poorly optimized Apache and Mysql Config
or
Host node having issues (if this is a VPS)

 

[ankurs]

you need to upgrade your vps or optimize your mysql queries

Logging slow queries with MySQL

 

[Lock Down]

First I would install htop and mytop. Both give you more information about your system.

As far as high cpu usage for mysql try editing my.cnf usually found in the folder etc.

Find the variable wait_timeout and change the value to 1200. If it is not there add it under the

[mysqld]

like this

wait_timeout = 1200

Then restart your mysql. This should hopefully take care of it.

 

[DoctorX]

can i know the following:
the size of your mysql database?
your website traffic?
your vps resources?