MySql kill 锁掉的进程

展示进程详情

show full processlist;

杀掉锁掉的进程

Select concat('KILL ',id,';') from information_schema.processlist WHERE state like '%Waiting for table%';

杀掉所有进程

Select concat('KILL ',id,';') from information_schema.processlist;

将结果复制执行即可：