we.jpg
按客户端 IP 分组,看哪个客户端的链接数最多

select client_ip,count(client_ip) as client_num from (select substring_index(host,':' ,1) as client_ip from information_schema.processlist ) as connect_info group by client_ip order by client_num desc;

查看正在执行的线程,并按 Time 倒排序,看看有没有执行时间特别长的线程

select * from information_schema.processlist where Command != 'Sleep' order by Time desc;

杀死堵塞进程

select concat('kill ', id, ';')
from information_schema.processlist
where command != 'Sleep'
and time > 2*60

发表评论

您的电子邮箱地址不会被公开。 必填项已用*标注

Captcha Code