SLOW performance over network

SLOW performance over network

am 29.09.2011 16:12:16 von Jim Moseby

--=__Part0E21C9D0.0__=
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: quoted-printable

mysql Ver 14.12 Distrib 5.0.51a, for debian-linux-gnu (i486) using =
readline 5.2
=20
Strange, strange problem.
=20
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 snappy-fast. There had been no changes to clients =
or server when this happened. All other networking services on the =
machine seem to be fine. Processors are between 0-3% utilization, disk is =
at 8% utilization.
=20
Server runs apache as well. There are many php pages on this web server =
that access the database, and display the results, all snappy-fast as =
usual.
=20
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 0.0086 =
seconds' at the bottom). I have many ODBC clients accessing this server =
as well, they all have slowness problems too.
=20
I'm stumped. What could possibly be causing this issue?
=20
Thanks for any ideas!
=20
Jim
=20
=20

CONFIDENTIALITY NOTICE: This message is directed to and is for the use of =
the above-noted addressee only, and its contents may be legally privileged =
or confidential. If the reader of this message is not the intended =
recipient, you are hereby notified that any distribution, dissemination, =
or copy of this message is strictly prohibited. If you have received this =
message in error, please delete it immediately and notify the sender. =
This message is not intended to be an electronic signature nor to =
constitute an agreement of any kind under applicable law unless otherwise =
expressly indicated herein.

--=__Part0E21C9D0.0__=--

Re: SLOW performance over network

am 29.09.2011 16:26:56 von Todd Lyons

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

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

Re: SLOW performance over network

am 29.09.2011 17:12:35 von Jim Moseby

--=__PartDBF41CF3.1__=
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: quoted-printable

Yeah:
=20
# 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
=20


>>> Todd Lyons 9/29/2011 10:26 AM >>>
On Thu, Sep 29, 2011 at 7:12 AM, Jim Moseby =
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 0.0086 =
seconds' at the bottom). I have many ODBC clients accessing this server =
as well, they all have slowness problems too.
>
> I'm stumped. What 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

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Djmoseby@elasticfabr=
ics.com



CONFIDENTIALITY NOTICE: This message is directed to and is for the use of =
the above-noted addressee only, and its contents may be legally privileged =
or confidential. If the reader of this message is not the intended =
recipient, you are hereby notified that any distribution, dissemination, =
or copy of this message is strictly prohibited. If you have received this =
message in error, please delete it immediately and notify the sender. =
This message is not intended to be an electronic signature nor to =
constitute an agreement of any kind under applicable law unless otherwise =
expressly indicated herein.

--=__PartDBF41CF3.1__=--

Re: SLOW performance over network

am 30.09.2011 01:23:07 von Johnny Withers

--0016364181c394577004ae1ccad1
Content-Type: text/plain; charset=ISO-8859-1

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" 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 10.1.20.97 /* my windows box */
97.20.1.10.in-addr.arpa has no PTR record



>>> Todd Lyons 9/29/2011 10:26 AM >>>

On Thu, Sep 29, 2011 at 7:12 AM, Jim Moseby
wrote:
> I still use the ol...
To unsubscribe:
http://lists.mysql.com/mysql?unsub=jmoseby@elasticfabrics.co m




CONFIDENTIALITY NOTICE: This message is directed to and is for the use of
the above-noted addres...

--0016364181c394577004ae1ccad1--