External host connection MySQL server latency critical problem

1, Reason: because of MySQL to connect the client DNS reverse resolution 2, disable DNS resolution, add Skip-name-resolve 3 in/etc/my.cnf,reverse parsing instructions:

The so-called inverse parsing is this: When MySQL receives the connection request, it obtains the client's IP, in order to better match the permission record in the Mysql.user (some are defined by hostname). If the MySQL server has a DNS server set up and the client IP does not have a corresponding hostname on the DNS, then this process is slow and causes the connection to wait. After adding skip-name-resolve, I skipped a process.

Original link: http://www.cnblogs.com/seafood/p/mysql_dns.html, declined reprint!

External host connection MySQL server latency critical problem