MySQL Forums
Forum List  »  MySQL Workbench

Slow first statement after connection to remote MySQL server
Posted by: David Del Signore
Date: July 25, 2023 02:36PM

Workbench 8.0.34, MS Windows 10. Backend db mysql-community-server-5.7.43-1.el7.x86_64

When connecting to remote MySQL servers (from USA to Asia, via private 150 Mbps MPLS circuit) the first statement executed takes excessively long to return a result - on the order of 3 minutes. For example, execution of the statement "SELECT 1;" took 195 seconds.

This lag is not reflected in the duration/fetch column in the action output panel - the duration displayed is very short (0.2s for the above query).

After the first statement completes, subsequent statements perform normally, with no unexpected lag. For example, repeating the above select statement completed immediately.

This behavior is not observed when connecting to a local replica of the remote server, or other local servers.

This behavior is not observed under Workbench 6.3.

This behavior is not observed using the CLI from a local machine.

Connection settings:
Require SSL
Use compression (same behavior with compression off)
DbSqlEditor:LastDefaultSchema=xxx
OPT_READ_TIMEOUT=300
lastConnected=1690316305
no-auto-rehash=
serverVersion=5.7.43-log
skip_auto_rehash=

Options: ReplyQuote


Subject
Views
Written By
Posted
Slow first statement after connection to remote MySQL server
840
July 25, 2023 02:36PM


Sorry, you can't reply to this topic. It has been closed.

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.