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

Erek Dyskant erek at blumenthals.com
Mon Jun 9 12:49:15 UTC 2008

On Mon, 2008-06-09 at 04:28 -0700, Pro Green European wrote:
> Delays in the connection to the db server is still around 20-30
> seconds.

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.

Have you checked that the nameservers in resolv.conf on the MySQL server
are reachable?

More information about the CentOS mailing list