As this is the top post if you google for MySQL high CPU usage or load, I'll add an additional answer:On the 1st of July 2012, a leap second was added to the current UTC-time to compensate for the slowing rotation of the earth due to the tides. When running ntp (or ntpd) this second was added to your computer's/server's clock. MySQLd does not seem to like this extra second on some OS'es, and yields a high CPU load. The quick fix is (as root):
$
/etc/init.d/ntpd stop
$ date -s "`date`" #这里设稍早的时间吧
$ /etc/init.d/ntpd start
来自
https://stackoverflow.com/questions/1282232/mysql-high-cpu-usage
