mysql使用多cpu_江湖救急mysql的cpu使用率百分之一千多！解决方法

江湖救急~~~mysql的cpu使用率百分之一千多！！

Tasks: 583 total, 4 running, 579 sleeping, 0 stopped, 0 zombie

Cpu(s): 35.3%us, 6.9%sy, 0.0%ni, 57.7%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st

Mem: 65976288k total, 50604344k used, 15371944k free, 7638260k buffers

Swap: 65537156k total, 360k used, 65536796k free, 38368636k cached

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND

620 mysql 15 0 3889m 1.3g 5820 S 1110.7 2.0 328:51.92 mysqld

10191 nobody 18 0 161m 18m 3972 R 68.9 0.0 0:02.10 httpd

9701 nobody 17 0 160m 18m 4320 R 50.6 0.0 0:04.73 httpd

10254 nobody 17 0 162m 19m 4312 R 38.4 0.0 0:02.78 httpd

10239 nobody 18 0 163m 20m 4068 S 36.8 0.0 0:01.81 httpd

10255 nobody 17 0 161m 19m 4304 S 19.0 0.0 0:04.71 httpd

9839 nobody 17 0 161m 19m 4324 S 10.5 0.0 0:04.66 httpd

9826 nobody 20 0 161m 19m 4296 S 8.5 0.0 0:04.74 httpd

10182 nobody 15 0 154m 12m 4360 S 1.6 0.0 0:03.26 httpd

各位大哥救救小弟吧，这台服务器跑着apache和mysql服务，其中mysql的使用已经1110.7%，这是什么原因哪？

------解决方案--------------------

这个百分比是每个cpu跑的加起来的总和 比如你又16核 每个跑50% 则显示800%

你在top命令后q键上面的1 就可以看到了

------解决方案--------------------

查查MySQL都在干什么

SQL code

show processlist;

------解决方案--------------------SQL code

mysql> show global variables like '%innodb_buffer_pool_size%'; +-------------------------+-----------+ | Variable_name | Value | +-------------------------+-----------+ | innodb_buffer_pool_size | 319815680 | +-------------------------+-----------+ 1 row in set (0.00 sec) mysql> show global variables like 'key_buffer_size%'; +-----------------+-----------+ | Variable_name | Value | +-----------------+-----------+ | key_buffer_size | 164626432 | +-----------------+-----------+ 1 row in set (0.00 sec)

欢迎大家阅读《江湖救急mysql的cpu使用率百分之一千多！解决方法》,跪求各位点评，by 搞代码

微信 赏一包辣条吧~

支付宝 赏一听可乐吧~