Simple command to check mysql max_connections limit

command to check mysql max_connections limit

On the dedicated server or VPS server many time, we face the server load issue because of excessive connection to the MySQL database, to resolve the excessive connection we can change the MySQL max_connections limit server-wide. To check the current MySQL max_connections limit refer the following two simple commands.

cat /etc/my.cnf | grep max_connections
or
mysqladmin variable | grep -i max_connections

 

About Anant 384 Articles
Senior technical writer