OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
RE: S L O W query over internet

From: Duncan, Kurt (MCUSA) (kurtmedconnectusa.com)
Date: Fri Apr 10 2009 - 16:07:51 CDT

One interesting note is we have a server running on the remote end and we did a test and tried to access the remote end from the server location and there 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:kurtmedconnectusa.com]
> Sent: Thursday, April 09, 2009 12:28 PM
> To: mysqllists.mysql.com
> Subject: S L O W query over internet
>
> 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?
>
> Kurt Duncan

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql