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
• Status: Not a Bug
• Category: MySQL Server
• Severity: S2 (Serious)
• Version: 5.6.20
• OS: Windows (C# application)
• 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.