mysql按ip查看连接数

SELECT SUBSTRING_INDEX(HOST, ':', 1) AS ip,count(*)

FROM information_schema. PROCESSLIST

GROUP BY ip;