亚马逊EC2的Linux AMI MySQL的CPU @ 62％，空闲时？ [英] EC2 Amazon Linux AMI MySQL CPU @ 62% When Idle?

问题描述

我在Amazon的Linux AMI运行MySQL。没有什么连接到它。有没有使用MySQL的连接和其他应用程序的运行。这是完全处于闲置状态，不过不失，顶报道称，MySQL是使用CPU的62％？这是怎么回事，如何解决呢？

I am running MySQL on an Amazon Linux AMI. There is nothing connected to it. There are no connections and no other applications running that use MySQL. It is completely idle, but yet, top is reporting that mysql is using 62% of the CPU? Why is this happening and how do I fix it?

Cpu(s):  0.2%us,  0.2%sy,  0.0%ni, 97.8%id,  0.0%wa,  0.0%hi,  0.0%si,  1.7%st
Mem:   1738504k total,   390708k used,  1347796k free,    56888k buffers
Swap:   917500k total,        0k used,   917500k free,   229804k cached

  PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND
 2959 mysql     20   0  466m  39m 5244 S 62.2  2.3   4:00.67 mysqld
    1 root      20   0 19252 1504 1212 S  0.0  0.1   0:00.20 init
    2 root      20   0     0    0    0 S  0.0  0.0   0:00.00 kthreadd

有没有连接...

mysql> show processlist;
+----+------+-----------+------+---------+------+-------+------------------+
| Id | User | Host      | db   | Command | Time | State | Info             |
+----+------+-----------+------+---------+------+-------+------------------+
|  5 | root | localhost | NULL | Query   |    0 | NULL  | show processlist |
+----+------+-----------+------+---------+------+-------+------------------+

更新： 我的问题肯定是关系到领先第二名的错误。荣誉给尼科 - ekito 。谢谢！

UPDATE: My issue was definitely related to the Lead Second bug. Kudos to nico-ekito. Thanks!

推荐答案

收出了这个问题。我的问题确实涉及到闰秒惨败。

Closing out this question. My issue was indeed related to the Leap Second fiasco.

这篇关于亚马逊EC2的Linux AMI MySQL的CPU @ 62％，空闲时？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！