即使没有人连接到Mysql，MYSQL也会突然使用CPU [英] MYSQL suddenly uses CPU even when no one user is connected to Mysql

问题描述

该站点是一个电子商务站点：$ b​​ $ b表中有500万条记录两台服务器：一台用于web服务器，另一台包含mysql
正在通过Sphinx服务器进行搜索。因此搜索查询不会出现在MySQL

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配置中：双四核Zeoo 2.0、146 GB，16 GB RAM。
Web服务器配置：Dual Quad Core Zeoo 2.0、146 GB，16 GB RAM。

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.

在过去四天里，我发现MySQL至少连续6年来一直在使用CPU。一天-7个小时。在那之后它变得正常。即使我重新启动，它也不会停止。它在2至3分钟内再次使用CPU。我什至尝试停止Apache，并确保没有人连接到Mysql。

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.

推荐答案

我只是在服务器上注意到了同样的问题，并且试图做些什么。我升级了mysql，它所做的只是减少了CPU使用量-从100％减少到55％

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%

我思考我的问题与Le秒有关-我注意到您的问题是领先秒后15天。

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

我发现：
EC2 Amazon Linux AMI MySQL CPU @ 62％处于空闲状态？

这导致我：
为什么Second秒导致问题？

最后我做了经典的Windows修复程序，然后重新启动了linux框-这行得通（没有检查内核是否同时进行了升级）

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)

这篇关于即使没有人连接到Mysql，MYSQL也会突然使用CPU的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！