S L O W query over internet

--_000_8C7771C0B2A3D14CB8D3FC6CA481ABAA04F9BAE1MBX13EXCHPROD US_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

We are running a remote service and have an application that queries a mysq=
l database over the public internet. The ping test shows <60ms but the que=
ries take 40 seconds to 2 minutes to run at times. When we run the same qu=
ery using a local machine with <2ms it runs fast. I have searched the int=
ernet and found several postings that this is normal but I can't believe an=
yone would wait this long... does anyone have any ideas or can you point me=
in the right direction?

Kurt Duncan


--_000_8C7771C0B2A3D14CB8D3FC6CA481ABAA04F9BAE1MBX13EXCHPROD US_--

RE: S L O W query over internet

One interesting note is we have a server running on the remote end and we d=
id a test and tried to access the remote end from the server location and t=
here was no issue. What I am wondering now is if there are configuration=
settings slowing the connection down on one server but not the other.

Kurt Duncan

> -----Original Message-----
> From: Duncan, Kurt (MCUSA) [mailto:kurt@medconnectusa.com]
> Sent: Thursday, April 09, 2009 12:28 PM
> To: mysql@lists.mysql.com
> Subject: S L O W query over internet
>=20
> We are running a remote service and have an application that queries a
> mysql database over the public internet. The ping test shows <60ms but
> the queries take 40 seconds to 2 minutes to run at times. When we run
> the same query using a local machine with <2ms it runs fast. I have
> searched the internet and found several postings that this is normal
> but I can't believe anyone would wait this long... does anyone have any
> ideas or can you point me in the right direction?
>=20
> Kurt Duncan



--
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