[CentOS] Help, PHP/Mysql connections are so slow.

Karanbir Singh mail-lists at karan.org
Mon Jun 9 22:13:05 UTC 2008

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 at icq

More information about the CentOS mailing list