MySQL 查询客户端连接情况

最新推荐文章于 2025-03-27 19:44:39 发布

达希_

最新推荐文章于 2025-03-27 19:44:39 发布

阅读量2.3k

点赞数 1

分类专栏： MySQL 文章标签： mysql

本文链接：https://blog.csdn.net/nibonnn/article/details/118945976

版权

MySQL 专栏收录该内容

4 篇文章

订阅专栏

本文展示了如何使用SQL查询来获取MySQL服务器的当前连接状态，包括连接的IP、状态及数量，同时展示了最大连接数和当前使用的连接数，为数据库性能监控提供参考。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

查询MySQL当前所有连接及状态：

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、状态及连接数量：

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及其连接数量：

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最大连接数：

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

查询MySQL当前连接数：

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