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