 |
| MySQL |
mysql, mysql download, mysql tutorial, mysql version, mysql slow query log, mysql slow query, mysql server, mariadb slow query log,mysql download,mysql commands, mysql queries
Question : MySQL Server is slow performing ?
Question : MySQL Slow Connection Error Resolve.
MySQL Server lookup a Hostname for authentication, for example: remoteuser@10.20.2.33
So we required speed up remote connections to your remote database servers.
We Just Change Your Setting in MySQL Configuration File
Verify MySQL version
mysql -V
MySQL Configuration File :
Add following 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
