杀掉一个用户的全部线程：
select concat('KILL ',id,';') from information_schema.processlist
where user='wenjie.wang';
将拼好的语句拿出来执行即可。
杀掉一个库的全部线程：
select concat('KILL ',id,';') from information_schema.processlist
where DB='testDB';
筛选processlist:
select id,user,host,db,command,time,state,info
from information_schema.processlist;
查看阻塞：
SELECT
waiting_pid as '被阻塞线程',
waiting_query as '被阻塞SQL',
blocking_pid as '阻塞线程',
blocking_query as '阻塞SQL',
wait_age as '阻塞时间'
FROM
sys.innodb_lock_waits
WHERE
(UNIX_TIMESTAMP() - UNIX_TIMESTAMP(wait_started)) > 30
;
网友评论