Check used & available maximum connection in MySQL

Check used & available maximum connection in MySQL

Check maximum available connection in MySQL

mysql> show global variables like 'max_connections';

Check used connection in MySQL

mysql> show global status like 'max_used_connections';

Check connected session list or Process list in MySQL

select id,user,host,db,command,time,state,info from information_schema.processlist;