数据库CPU飙升100%三步曲

95 阅读1分钟

1,查询慢语句

SELECT * FROM information_schema.PROCESSLIST WHERE command != 'Sleep' ORDER BY time DESC

2,生成KILL命令

select concat('kill ', id, ';') from information_schema.processlist where command != 'Sleep' and time > 100 order by time desc;

3,执行KILL命令

kill 14657501;

4,代码定位,修复