Speed up MySQL connection

According to:

http://forums.mysql.com/read.php?24,23390,23395#msg-23395

Slow connection is mainly due to slow DNS resolve process. Other than adding a host-IP value pair in Linux /etc/hosts file, I added the following line in /etc/my.cnf :

[mysqld]
skip-name-resolve

It can definitely make your mysql connection instantaneous! The only drawback is that you can only connect to your mysql databases using IP but not host name.

Hope it helps.

Comments

Popular posts from this blog

TCPDF How to show/display Chinese Character?

Wordpress Load balancing: 2 web servers 1 MySQL without any Cloud services

Using wget bypass htaccess username password 401 authorization