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;
标签:information,kill,mysql,PROCESSLIST,线程,卡死,select From: https://www.cnblogs.com/hdwang/p/16598382.html