Mysql中查看每个IP的连接数

No Comments mysql_mariadb

 

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

发表评论