mysql执行语句卡死后杀线程

1.查询正在运行的线程

SHOW PROCESSLIST;
#或
select *  from information_schema.PROCESSLIST;

2.批量生成杀线程的命令

select concat("kill ", ID, ";") as command
from information_schema.PROCESSLIST
where DB  = "pbocbdms";

3.执行命令

kill 318;
kill 317;
kill 208;
kill 162;