开发者

MySQL如何查询客户端连接情况

开发者 https://www.devze.com 2024-08-19 09:07 出处:网络 作者: 达希_
目录mysql查询客户端连接情况查询MySQL当前所有连接及状态查询MySQL当前连接IP、状态及连接数量查询MySQL当前连接IP及其连接数量查询MySQL最大连接数查询MySQL当前连接数总结MySQL查询客户端连接情况
目录
  • mysql查询客户端连接情况
    • 查询MySQL当前所有连接及状态
    • 查询MySQL当前连接IP、状态及连接数量
    • 查询MySQL当前连接IP及其连接数量
    • 查询MySQL最大连接数
    • 查询MySQL当前连接数
  • 总结

    MySQL查询客户端连接情况

    查询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 |           |   python     2 |
    | localhost       | executing |        1 |
    +-----------------+-----------+----------+
    2 rows in set (0.00 sec)

    查询MySQL当前连接IP及其http://www.devze.com连接数量

    mysql> SELECT substring_index(host, ':', 1) AS ip, count(*) FROM information_schema.processlist GROUP BY ip;       
    +-----------------+----------+
    | ip              | count(*) |
    +-----------------+-------www.devze.com---+
    | 183.192.226.255 |        2 |
    | localhttp://www.devze.comhost       |        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 sejavascriptc)

    总结

    以上为个人经验,希望能给大家一个参考,也希望大家多多支持编程客栈(www.devze.com)。

    0

    精彩评论

    暂无评论...
    验证码 换一张
    取 消

    关注公众号