MySQL初级性能排查

查询执行时间超长的进程

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;