9 Jun
2008
9 Jun
'08
2:49 p.m.
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?