SELECT
	SUBSTRING_INDEX(HOST, ':', 1) AS ip,
	COUNT(*) 
FROM
	information_schema.PROCESSLIST 
GROUP BY
	ip;