select * from information_schema.processlist show full processlist
# 获得
select user,substring_index(host,‘:‘,1) as ip,count(1) as total from information_schema.processlist group by ip order by total desc;
原文：https://www.cnblogs.com/igoodful/p/11681595.html