From: Jim Ginn (jimoats.com)
Date: Tue Jan 06 2009 - 08:41:50 CST

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

Jed:

Are you using an in-network IP to access the database ie:

127.0.0.1
192.168.98.##

or are you using a public IP or full domain name ie:

DB001.MY-DOMAIN.COM
...

Jim

> 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
> To unsubscribe: http://lists.mysql.com/mysql?unsub=jimoats.com
>
>

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

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