slow connection error on mysql

slow connection error on mysql



Question : MySQL Server is slow performing ?

Question : MySQL Slow Connection Error Resolve.



MySQL server lookup hostnames for authentication EVEN IF you are using for example: remoteuser@10.20.2.33 so to speed up remote connections to your remote database servers Just Change Your Setting in MySQL Configuration File

Add followong Line in /etc/my.cnf

skip-locking

skip-name-resolve

# vi /etc/my.cnf

[mysqld] 

port = 3306

socket = /tmp/mysql.sock

skip-locking

skip-name-resolve


Now Restart The MySql Server

#service mysqld restart

Previous
Next Post »