Remote connection to MySQL slow causes and solutions

Because of the deployment of MySQL server in the network, there is no load, the local connection speed is also normal, but the network connection is particularly slow, and finally check that the original DNS resolution problem

In MySQL configuration file/etc/my.cnf [mysqld], add

Skip-name-resolve

Reboot, the test speed is normal.

This article is from "Maple Night" blog, please be sure to keep this source http://fengwan.blog.51cto.com/508652/1665657

Remote connection to MySQL slow causes and solutions