April 2025
M T W T F S S
 123456
78910111213
14151617181920
21222324252627
282930  

Categories

April 2025
M T W T F S S
 123456
78910111213
14151617181920
21222324252627
282930  

MySQL slow remote connection causes and solutions

Because the network is deployed MySQL server, there is no load, when the speed local connections are normal, but it is especially slow when connected via a network, the last inspection found that a DNS resolution problem

In the MySQL configuration file /etc/my.cnf in the [mysqld] added

skip-name-resolve

Reboot, test the normal speed.

Leave a Reply

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>