数据库CPU飙升100%三步曲

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，代码定位，修复