Mysql查看串連數相關資訊

標籤：sub   var   style   set   and   ring   field   order   process   

MySQL查看串連數相關資訊在

資料庫：INFORMATION_SCHEMA表：PROCESSLIST

表結構如下：

mysql> desc PROCESSLIST;+---------+-------------+------+-----+---------+-------+| Field   | Type        | Null | Key | Default | Extra |+---------+-------------+------+-----+---------+-------+| ID      | bigint(4)   | NO   |     | 0       |       || USER    | varchar(16) | NO   |     |         |       || HOST    | varchar(64) | NO   |     |         |       || DB      | varchar(64) | YES  |     | NULL    |       || COMMAND | varchar(16) | NO   |     |         |       || TIME    | int(7)      | NO   |     | 0       |       || STATE   | varchar(64) | YES  |     | NULL    |       || INFO    | longtext    | YES  |     | NULL    |       |+---------+-------------+------+-----+---------+-------+8 rows in set (0.00 sec)

 

查看單個host串連數：

select 
　　substring_index(host,":",1) as host, count(1) as cnt 
from (select * from INFORMATION_SCHEMA.PROCESSLIST) a 
group by 
　　substring_index(host,":",1) order by cnt desc;

查看db串連數：

select db,count(1) as cnt from INFORMATION_SCHEMA.PROCESSLIST group by db order by cnt desc;

 

Mysql查看串連數相關資訊