Re: long login times?

2009-01-06 Thread Jim Ginn
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.

Re: long login times?

2009-01-06 Thread Jed Reynolds
Jim Ginn wrote: 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 ... A very reasonable question. I'm connecting using IP addresses. $servers = array(

long login times?

2009-01-05 Thread Jed Reynolds
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