查询mysql db的连接IP

[Han-Gang]

select substring_index(host,':',1) as ip , count(*) from information_schema.processlist group by ip;