MySQL Bugs: #106810: Slow initial query to remote DB

Bug #106810	Slow initial query to remote DB
Submitted:	23 Mar 2022 12:36	Modified:	6 Apr 2022 12:03
Reporter:	Domenick Garuccio	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Workbench	Severity:	S3 (Non-critical)
Version:	8.0.28	OS:	Any
Assigned to:		CPU Architecture:	Any

Description:
When connecting to each of my remote AWS Aurora (using MySql Engine) Databases, the first query to each takes a couple of minutes to execute.  Even just SELECT 1;

Actually if I open the connection and do nothing for a couple of minutes, the query responds as expected.  What I believe may be happening, is that there is some database discovery happening on the connection and the requested query cannot be performed until that discovery finishes.  I don't see this when connecting to my local MySql database.

How to repeat:

Open connection to remote (probably large) database.  Execute any query.

Hello Domenick Garuccio,

Thank you for the bug report.
Imho this is duplicate of Bug #96949, please see Bug #96949 and follow the suggested workaround.

Regards,
Ashwini Patil

Thanks for the response.  I had seen these reports with the the suggestion of clearing the logs and had tried that before logging a ticket.  It did not make any difference.  I deleted my connections, and removed my data folder containing all the connection history and I still see the same behavior.

Log File

Attachment: wb_2022_04_06.log (application/octet-stream, text), 6.14 KiB.