MySQL бааз руу өөр серверээс холбогдох үед тохируулах

Дусал нэвтэрхий толь-с

Сүлжээгээр MySQL серверт холбогдох үед DNS resolve хийж уддаг юм байна. Үүнийг зогсоосноор хурдан холбогдоно.

Add the following line(skip-name-resolve) in the /etc/mysql/my.cnf file


This is an option which needs to be set in the MySQL configuration file on the server. It can't be set by client APIs such as MySQLdb. This is because of the potential security implications. That is, I may want to deny access from a particular hostname. With skip-name-resolve enabled, this won't work. (Admittedly, access control via hostname is probably not the best idea anyway.)