select SUBSTRING_INDEX(host,':',1) as ip , count(*) from information_schema.processlist group by ip;
转载于:https://www.cnblogs.com/ClassNotFoundException/p/5983403.html
select SUBSTRING_INDEX(host,':',1) as ip , count(*) from information_schema.processlist group by ip;
转载于:https://www.cnblogs.com/ClassNotFoundException/p/5983403.html