mysql server查询客户端连接数

SELECT
substring_index(HOST, ':', 1) AS host_name,
state,
count(*)
FROM
information_schema. PROCESSLIST
GROUP BY
state,
host_name;