Why is MySQL making the CPU run at about 80%?

Posted by Robert on Server Fault See other posts from Server Fault or by Robert
Published on 2012-02-27T20:23:48Z Indexed on 2012/03/19 18:06 UTC
Read the original article Hit count: 270

Filed under:

MySQL is eating up about 80% of my CPU for no reason as far as I can see. Right now this server is rarely used, more of a test site I set up that will eventually be a used for production once I fix small problems like this. I run 3 instances of MySQL but it seems that my first instance is taking up all the CPU. When I turn off the first instance and leave the other two on everything runs fine.

Any suggestions?

I tried Show Processlist and no statements are being run besides "Sleep" and the query "Show Processlist" (obviously) at the time it's using up all this CPU.

my.cnf is basic. I did not optimize or change any MySQL settings. Do you think this would cause such strange behavior?

The machine is running Linux Centos 5.7 64 bit and MySQL 5.0.95.

Thanks

© Server Fault or respective owner

Related posts about linux