SELECT substring_index(HOST, ':', 1) AS host_name, state, count(*) FROM information_schema. PROCESSLIST GROUP BY state, host_name;
SELECT substring_index(HOST, ':', 1) AS host_name, state, count(*) FROM information_schema. PROCESSLIST GROUP BY state, host_name;
转载于:https://www.cnblogs.com/wenq001/p/10647475.html