查看正在执行的线程,并按 Time 倒排序,看看有没有执行时间特别长的线程
select * from information_schema.processlist where Command != ‘Sleep’ order by Time desc;
找出所有执行时间超过 5 分钟的线程,拼凑出 kill 语句,方便后面查杀
select concat('kill ', id, ‘;’) from information_schema.proce sslist where Command != ‘Sleep’ and Time > 300 order by Time desc;