通过sql查看数据库连接情况
host_name 客户端IP
state 连接状态
count(*) 连接数
SELECT substring_index(host, ':',1) AS host_name,state,count(*) FROM information_schema.processlist GROUP BY state,host_name;
通过sql查看数据库连接情况
host_name 客户端IP
state 连接状态
count(*) 连接数
SELECT substring_index(host, ':',1) AS host_name,state,count(*) FROM information_schema.processlist GROUP BY state,host_name;