SELECT a.host,count(a.host) from (select SUBSTRING_INDEX(host,':',1) as host from information_schema.processlist) a GROUP BY a.host ORDER BY count(1) desc
SELECT a.host,count(a.host) from (select SUBSTRING_INDEX(host,':',1) as host from information_schema.processlist) a GROUP BY a.host ORDER BY count(1) desc