问题描述
该站点是一个电子商务站点:$ b $ b表中有500万条记录两台服务器:一台用于web服务器,另一台包含mysql
正在通过Sphinx服务器进行搜索。因此搜索查询不会出现在MySQL
Site is an ecommerce site: 5 Million records in tableTwo servers: one for webserver and other contains mysqlSearch 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.
我发现:
这导致我:
最后我做了经典的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的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!