查看mysql连接的ip和连接个数 select SUBSTRING_INDEX(host,':',1) as ip , count(*) from information_schema.processlist group by ip;