Re: Help, PHP/Mysql connections are so slow.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]



Erek Dyskant wrote:
It sounds like the MySQL server is configured to do reverse DNS lookups
on incoming connections, and those DNS lookups are timing out.  For
small systems (a few web servers and a db server) I tend to add the web
servers to the system's hosts file, so the mysql server doesn't have to
do a DNS lookup for every connection.

mysqld always does reverse lookup by default. to change that, you need the 'skip-name-resolve' option in the [mysqld] section of your config file ( usually /etc/my.cnf and make sure there is no /var/lig/mysql/my.cnf )


--
Karanbir Singh : http://www.karan.org/  : 2522219@icq
_______________________________________________
CentOS mailing list
CentOS@xxxxxxxxxx
http://lists.centos.org/mailman/listinfo/centos

[Index of Archives]     [CentOS]     [CentOS Announce]     [CentOS Development]     [CentOS ARM Devel]     [CentOS Docs]     [CentOS Virtualization]     [Carrier Grade Linux]     [Linux Media]     [Asterisk]     [DCCP]     [Netdev]     [Xorg]     [Linux USB]
  Powered by Linux