慢查询mysql processlist的注意事项
http://www.bubuko.com/infodetail-1047166.html
Mysql的全部线程
Select count(*) from information_schema.processlist;
select left(host,instr(host,‘:‘)-1) asip,count(*) as num from information_schema.processlist group by ip order by num desc;
查询执行sql的user的连接数量
mysql> select user,count(*) as num from information_schema.processlist group by user order by num desc;
+--------+-----+
| user | num |
+--------+-----+
| zabbix | 28 |
| root | 1 |
+--------+-----+
查询执行sql语句的数量
select count(*) as num,info from information_schema.processlist where info is not null group by info order by num;
show global status like 'Threads%';
查询执行sql的ip 的连接数量
mysql> select left (host,instr(host,':')-1) as ip,count(*) as num from information_schema.processlist group by ip order by num desc;
+----+-----+
| ip | num |
+----+-----+
| | 29 |
+----+-----+
查询mysql进程,因为数据库的sleep连接很多(一般都会在几千个左右),不建议直接show processlist或者show full Processlist。尽量去用select查询
正在running的线程