Bug #77669 Remote MySQL Query takes a long time to run

Submitted: 9 Jul 2015 14:27 Modified: 9 Jul 2015 16:19
Reporter: Shyamal Parikh Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:5.6.20 OS:Windows (C# application)
Assigned to: CPU Architecture:Any
Tags: C#, Slow connection, throughput

[9 Jul 2015 14:27] Shyamal Parikh
Description:
Running a MySQL query on a local database takes only about 20-30ms but running the same query through a remote connection(internet) takes 500ms. Is this normal? If not what could be the possible reason for such delay?

This is a wireshark time extract for a particular Query run remotely.

Time -195.768993000 --- Request Ping
Time -195.909453000 --- Response OK
Time -195.909729000 --- Request Use Database
Time -196.049567000 --- Response OK
Time -196.049918000 --- Request Query
Time -196.219660000 --- Response

How to repeat:
Try executing a remote MySQL query on a remote database.
[9 Jul 2015 16:19] MySQL Verification Team
We're sorry, but the bug system is not the appropriate forum for asking help on using MySQL products. Your problem is not the result of a bug.

Support on using our products is available both free in our forums at http://forums.mysql.com/ and for a reasonable fee direct from our skilled support engineers at http://www.mysql.com/support/

Thank you for your interest in MySQL.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.044 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.