MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Jim Ginn Date:January 6 2009 2:41pm
Subject:Re: long login times?
View as plain text  
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=1
>
>

Thread
long login times?Jed Reynolds6 Jan
  • Re: long login times?Jim Ginn6 Jan
    • Re: long login times?Jed Reynolds6 Jan
      • Mysql Replication out of syncShain Miley9 Jan
  • Re: Mysql Replication out of syncJose Julian Buda9 Jan
    • Re: Mysql Replication out of syncShain Miley9 Jan