Speed up MySQL connection

According to:


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 :


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.


Popular posts from this blog

TCPDF How to show/display Chinese Character?

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

How to fix fancy box/Easy Fancybox scroll not work in mobile