select SUBSTRING_INDEX(host,‘:‘,1) as ip , count(*) from information_schema.processlist group by ip;
查看mysql 服务有哪些ip地址在连接。
原文：https://www.cnblogs.com/ruize-coding/p/11336505.html
