Navicat for MySQL client operation MySQL very slow problem

First look at the MySQL error log:

 cd /usr/local/mysql/var/ tail VM_79_224_centos.err

The log name may be different, depending on the actual situation
Open to see an error similar to the following:

110617 14:04:10 [Warning] IP address ‘19.200.90.16‘ could not be resolved: Temporary failure in name resolution110617 14:07:48 [Warning] IP address ‘19.200.57.44‘ could not be resolved: Temporary failure in name resolution

This error log indicates that the MySQL DNS resolution of the IP address, the solution is to modify the MY.CNF configuration file to cancel the DNS resolution
Do the following:

vi /etc/my.cnf

Add a line in MY.CNF:

skip-name-resolve

Save, exit, restart MySQL service, OK

Navicat for MySQL client operation MySQL very slow problem