查询mysql数据库目前有哪些链接 具体ip及数量

SELECT substring_index(host, ':',1) AS host_name,state,count(*) FROM information_schema.processlist GROUP BY state,host_name;