Login to Members Area

Choose the service you want to log in
     
24x7x365 Presence
1-888-289-2246
Live Chat

Hosting Blog

 

DNS lookup optimization for the MySQL server: skip-name-resolve

To increase the MySQL server performance if there are many hosts and if DNS is slow, consider disabling DNS lookups with --skip-name-resolve or consider increasing the value of HOST_CACHE_SIZE define (default value: 128) and recompiling the server. These methods are very effective and improve the server performance a lot.

Sometimes, all connections to the database appear to be slow due to the DNS being slow. In such cases, conversions from IP addresses to the corresponding hostnames can be stopped by using the skip-name-resolve parameter. To disable DNS lookups the following line can be added in the my.cnf file:-

skip-name-resolve

Abhishek Monday 21 October 2013 - 7:55 pm | | Default

two comments

One or more comments are waiting for approval by an editor.

(optional field)
(optional field)

Comment moderation is enabled on this site. This means that your comment will not be visible until it has been approved by an editor.

Remember personal info?
Small print: All html tags except <b> and <i> will be removed from your comment. You can make links by just typing the url or mail-address.