欢迎各位兄弟 发布技术文章

这里的技术是共享的

You are here

稍微设置早点时间 还是稍微设晚点时间 是不是缓存时间更长了 是不是速度更快了 时区 有大用 好像没用

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


普通分类: