Mysql查看用户连接数配置及每个IP的请求情况

show full processlist;
shop processlist;

  show variables like ‘%max_connections%‘;

show variables like ‘%max_user_connections%‘;

select USER , count(*) from information_schema.processlist group by USER;

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

select host,user,time,state,info from information_schema.processlist order by time desc limit 10;

show variables like ‘%conn%‘;