慢查询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的线程