[펌] HOWTO: Turn off MySQL reverse DNS lookup to speed up response times

내용을 요약 하자만.. mysql이 접속 할때 reverse DNS lookup을 하는데 이때 시간이 많이 걸리니
이를 skip처리 하면 접속 속도가 많이 빨라 진다는 이야기..

 

 

http://developer.sugarcrm.com/2012/01/10/howto-turn-off-mysql-reverse-dns-lookup-to-speed-up-response-times/

Our support team was recently working on a case where pages were taking 5 seconds or longer for each load, even after tackling all of the common performance tweaks. Digging in a bit further, they realized that connecting to the MySQL database was taking an awful long time from looking at the logs.

As you can see, it’s taking nearly 5 seconds for MySQL to do a reverse DNS lookup on the client, which is completely unneeded. Fortuantely, there is a simple fix to this problem; just add the following line into your MySQL configuration file and restart the server.

[mysqld]

# Skip reverse DNS lookup of clients

skip-name-resolve

With that one change, the page load times ducked underneath a half a second. So definitely check your MySQL servers and make sure this is set this way.