From: Todd Lyons Date: September 29 2011 2:26pm Subject: Re: SLOW performance over network List-Archive: http://lists.mysql.com/mysql/225854 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable On Thu, Sep 29, 2011 at 7:12 AM, Jim Moseby wr= ote: > I still use the old MySQL Administrator GUI on my windows box. =A0A simpl= e 'select * from tablename' =A0that would return only three records takes j= ust over a minute to return (although it says '3 records returned in 0.0086= seconds' at the bottom). =A0I have many ODBC clients accessing this server= as well, they all have slowness problems too. > > I'm stumped. =A0What could possibly be causing this issue? Wild Guess: Does DNS resolution, especially reverse dns resolution, still work on the mysql server? ...Todd --=20 If Americans could eliminate sugary beverages, potatoes, white bread, pasta, white rice and sugary snacks, we would wipe out almost all the problems we have with weight and diabetes and other metabolic diseases. -- Dr. Walter Willett, Harvard School of Public Health