MYSQL suddenly uses CPU even when no one user is c

问题:

Site is an ecommerce site: 5 Million records in table Two servers: one for webserver and other contains mysql Search is happenning through Sphinx server. So search queries do not come to MySQL

Mysql configuration: Dual Quad Core Zeoo 2.0, 146 GB, 16 GB RAM. Webserver configuration: Dual Quad Core Zeoo 2.0, 146 GB, 16 GB RAM.

For past four days I find MySQL is using CPU continuously for at least 6-7 hours in a day. It becomes normal after that. Even if I restart, it doesnt stop. It again uses CPU in 2 to 3 mins. I even tried stopping Apache and made sure no one is connecting to Mysql.

回答1:

I just noticed the same issue on my server and tried to do something about it. I upgraded mysql and all it did was reduce the amount of CPU used - from 100% to 55%

I think my issue is Leap Second related - I notice your question is 15 days after the lead second.

I found: EC2 Amazon Linux AMI MySQL CPU @ 62% When Idle?

Which lead me to: Why Does the Leap Second Cause Problems?

Lastly I did the classic windows fix and rebooted the linux box - this worked (did not check if kernel had been upgraded in mean time)