[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