MySQL Maxing out CPU!! Please help, URGENT!

Hey, there seems to be a problem with MySQL, the server has cPanel, and when I view the current CPU usage, this is always being displayed:
/usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/zeus1.forcium.net.pid --skip-external-locking --socket=/var/lib/mysql/mysql.sock

and usually taking up more than 80% of the CPU. Even if I stop the MySQL process (by entering 'service mysql stop') in SSH, it still shows up in the current CPU usage, and even if I try to kill the process with the MySQL service stopped, it keeps coming back.

Please help as this is taking up a load of CPU and slowing down customer websites. I'm not sure how to fix it.

Thanks in advance,
Nexopedia

 

Hello,

Check the connections to the mySQL and try to find who is opening too much connections

The command is mysqladmin proc stat

 

I have, but I have even stopped the MySQL service and it still seems to be running and comes back straight after I've killed the process.

Thanks,
Nexopedia

 

I can optimize your site and db for $100

50% advance

Regards

Alex

 

ok, so you know what site is causing this issue? If you suspend that site will you still have the cpu load?

 

I will check now

 

yes, but remember that you have to restart mySQL after suspending the account, because it not release the mySQL connections

 

OK, I suspended the account and restarted MySQL, but the CPU load is still quite high (caused by that process)

 

Could you copy and paste the output of the following commands:

mysqladmin proc stat

ps auxf

Make sure to put the output within code blocks eg. [code] place the code here [/code]

 

Perhaps you should recreate table indexes and see if it helps. You can also run

show table status;

command when you are using particular database and see if it finds any errors in table(s).

 

It's ok now, we got someone to come and fix it. Running perfectly now

 

I glad to know that your issue is fixed. I always optimize my.cnf (MySQL configuration file) on the server. Also, I install mytop on cPanel server to see the MySQL resource usage.

Kailash