SLOW performance over network

2011-09-29 Thread Jim Moseby
mysql Ver 14.12 Distrib 5.0.51a, for debian-linux-gnu (i486) using readline 5.2 Strange, strange problem. Everything was fine yesterday morning, then all of a sudden any query over the network takes a REALLY long time to return. If I log in at the server console, every query is

Re: SLOW performance over network

2011-09-29 Thread Todd Lyons
On Thu, Sep 29, 2011 at 7:12 AM, Jim Moseby jmos...@elasticfabrics.com wrote: I still use the old MySQL Administrator GUI on my windows box.  A simple 'select * from tablename'  that would return only three records takes just over a minute to return (although it says '3 records returned in

Re: SLOW performance over network

2011-09-29 Thread Jim Moseby
Yeah: # host 72.30.2.43 /* yahoo.com */ 43.2.30.72.in-addr.arpa domain name pointer ir1.fp.vip.sk1.yahoo.com. # host 10.1.20.97 /* my windows box */ 97.20.1.10.in-addr.arpa has no PTR record Todd Lyons tly...@ivenue.com 9/29/2011 10:26 AM On Thu, Sep 29, 2011 at 7:12 AM, Jim Moseby

Re: SLOW performance over network

2011-09-29 Thread Johnny Withers
Check your auto negotiate setting on your nic. Run ifconfig and see if there are a lot of errors. On Sep 29, 2011 10:13 AM, Jim Moseby jmos...@elasticfabrics.com wrote: Yeah: # host 72.30.2.43 /* yahoo.com */ 43.2.30.72.in-addr.arpa domain name pointer ir1.fp.vip.sk1.yahoo.com. # host