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;