MySQL如何查詢客戶端連接情況

更新時間：2024年08月19日 08:38:09 作者：達希_

這篇文章主要介紹了MySQL如何查詢客戶端連接情況,具有很好的參考價值,希望對大家有所幫助,如有錯誤或未考慮完全的地方,望不吝賜教

MySQL查詢客戶端連接情況

查詢MySQL當前所有連接及狀態(tài)

mysql> SELECT host, state FROM information_schema.processlist;
+----------------------+-----------+
| host                 | state     |
+----------------------+-----------+
| localhost            | executing |
| 183.192.226.255:1842 |           |
| 183.192.226.255:1841 |           |
+----------------------+-----------+
3 rows in set (0.00 sec)

查詢MySQL當前連接IP、狀態(tài)及連接數(shù)量

mysql> SELECT substring_index(host, ':', 1) AS ip, state, count(*) FROM information_schema.processlist GROUP BY ip, state;
+-----------------+-----------+----------+
| ip              | state     | count(*) |
+-----------------+-----------+----------+
| 183.192.226.255 |           |        2 |
| localhost       | executing |        1 |
+-----------------+-----------+----------+
2 rows in set (0.00 sec)

查詢MySQL當前連接IP及其連接數(shù)量

mysql> SELECT substring_index(host, ':', 1) AS ip, count(*) FROM information_schema.processlist GROUP BY ip;       
+-----------------+----------+
| ip              | count(*) |
+-----------------+----------+
| 183.192.226.255 |        2 |
| localhost       |        1 |
+-----------------+----------+
2 rows in set (0.01 sec)

查詢MySQL最大連接數(shù)

mysql> show variables like 'max_connections';
+-----------------+-------+
| Variable_name   | Value |
+-----------------+-------+
| max_connections | 600   |
+-----------------+-------+
1 row in set (0.01 sec)

查詢MySQL當前連接數(shù)

mysql> show status like 'max_used_connections';       
+----------------------+-------+
| Variable_name        | Value |
+----------------------+-------+
| Max_used_connections | 17    |
+----------------------+-------+
1 row in set (0.00 sec)