查询执行时间超长的进程
SELECT * FROM information_schema.PROCESSLIST WHERE command != 'Sleep' ORDER BY time DESC
列出要结束的进程
select concat('kill ', id, ';') from information_schema.processlist where command != 'Sleep' and time > 100 order by time desc
执行列出的命令
kill 1;