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
