MySQL: check number of existing Connections/Max Connections

 check number of existing Connections/Max Connections in MySQL

• o check the number of existing connections for MySQL:

Run the following query in MySQL Work Bench:

select count(host) from information_schema.processlist;

select * from information_schema.processlist;

or
show status where variable_name = 'threads_connected';

 

• Check the max connection allowed by MySQL:

Run the following query in MySQL Work Bench:

select @@max_connections