[SUMMARY] MySQL connection time

Hello everyone,

I would like to thank the following:

Chris Ricker
Julian Van Niejenhuis
Joakim Ryden
Neil Dombrowski
Jeremy Zawodny

Most of them related to a forward/reverse DNS resolve issue. I solved that
using Jeremy's suggestion to skip-name-resolv in my.cnf . Additionaly, I
started using persistent MySQL connections. On the whole, everything is
working really fine now.


Thanks again, everyone,

Flavio C. Prado
fprado-w57cjQFVChNwFqzsTH5u/[email protected]



----- Original Message -----
From: "Flavio C. Prado" <fprado-w57cjQFVChNwFqzsTH5u/[email protected]>
To: <linuxmanagers-35TzE1X9F6582KRnZfj+bdi2O/[email protected]>
Sent: Friday, September 12, 2003 4:15 PM
Subject: MySQL connection time


> Hello everyone,
>
>
> I have the following situation: one webserver connects to a MySQL database
> on another box. The queries themselves run fine and fast, but the problem
I
> have is that it is taking a large amount of time for the client to connect
> on the database. When I run "show processlist" on the database, it shows a
> big list of clients waiting for authentication.
>
> I can get a TCP connection between both boxes really fast, so I don't
think
> it is a network issue. Does anyone there have (or know where I can find)
> pointers to optimize MySQL authentication?
>
>
> Regards,
>
>
> Flavio C. Prado
> fprado-w57cjQFVChNwFqzsTH5u/[email protected]
_______________________________________________
LinuxManagers mailing list - http://www.linuxmanagers.org
submissions: LinuxManagers-35TzE1X9F6582KRnZfj+bdi2O/[email protected]
subscribe/unsubscribe: http://www.linuxmanagers.org/mailman/listinfo/linuxmanagers