mysq锁表，批量杀死进程

mysql
查询所有锁表状态
SHOW PROCESSLIST

KILL QUERY 39983; 杀死一个锁进程

批量死一个锁进程
SELECT CONCAT('KILL ', id, ‘;’) AS kill_command
FROM information_schema.processlist
WHERE user=‘lixiang-dev’ AND command=‘Sleep’;