大家好,又见面了,我是你们的朋友全栈君。
SELECT
substring_index(HOST, ':', 1) AS host_name,
state,
count(*)
FROM
information_schema. PROCESSLIST
GROUP BY
state,
host_name;
发布者:全栈程序员-站长,转载请注明出处:https://javaforall.net/105907.html原文链接:https://javaforall.net
MySQL查看所有连接的客户端ipMySQL查看所有连接的客户端ip
大家好,又见面了,我是你们的朋友全栈君。
SELECT
substring_index(HOST, ':', 1) AS host_name,
state,
count(*)
FROM
information_schema. PROCESSLIST
GROUP BY
state,
host_name;
发布者:全栈程序员-站长,转载请注明出处:https://javaforall.net/105907.html原文链接:https://javaforall.net