MySQL open skip-name-resolve and skip-networking optimization

Use Skip-name-resolve to increase remote connection speed

Skip-name-resolve

This option means disabling DNS resolution, which is a special setting on an official system regardless of the way the link is through the hosts or IP mode, he will do the DNS counter-check, because the anti-check resolution too slow, you will not be able to cope with the excessive query.

Single-machine running MySQL using skip-networking to turn off MySQL TCP/IP connection mode

Skip-networking

You cannot access MySQL remotely after you turn on this option

For security reasons, you can add Bind-address=ip to the configuration file if you want to specify IP access to MySQL, as long as you turn off skip-networking

bind-address=192.168.1.100

MySQL optimization should be configured according to the actual situation

MySQL open skip-name-resolve and skip-networking optimization