From: Jed Reynolds (listsbitratchet.com)
Date: Tue Jan 06 2009 - 00:35:06 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

I've started logging how long my php application takes to login to
mysql, and often it's well below 1 millisecond. However, I'll sometimes
get a wave of long login attempts that take 3 to 6 seconds. I've enabled
skip-name-resolv, and I think that helps. There are no long running
queries on the system. There are only a dozen accounts on the system.
The system is not running under stress, it's about load 0.9, four cores,
2Gz, 4GB ram, no swapping. (CentOS 5, Mysql 5.0.45).

I'd hate to set the connect timeout to 1 second, fail and retry in under
a second just to try to get a connection as fast as possible. Any thots
on how I might keep login times consistently low?

Thanks

Jed

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]