24 July, 2013

MySQL max connection status for optimisations

you can use the below query to check the max connection statistics

select version();show variables like "%max_connections%";show global status
         like "%Max_used%";show status like "%thread%";

 Max_used_connections : The maximum number of connections that have been in use simultaneously since the server started.
max_connections : The maximum permitted number of simultaneous client connections.

No comments:

Post a Comment