Archive for the ‘Mysql + phpmyadmin’ Category
Simple command to check mysql max_connections limit
April 23rd, 2012 | Author: Gunjan
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
You can also refer to the following URL for proper mysql tunning
http://www.theperfectarts.com/2011/12/mysql-tuner-to-tune-mysql-service/
Posted in Dedicated Server Issue, Linux Administrator Interview Questions, Mysql + phpmyadmin, VPS | 
Tags: check max_connections limit, decrease max_connections limit, increase max_connections limit, max_connections issue, resolve max_connections issue, update max_connections limit | 
Comments Closed