MySQLのIPあたりの接続数を監視する
MySQLコマンド:
select SUBSTRING_INDEX(host,’:’,1) as ip , count(*) from information_schema.processlist group by ip;
Coding Changes the World
MySQLコマンド:
select SUBSTRING_INDEX(host,’:’,1) as ip , count(*) from information_schema.processlist group by ip;