Bug #111008 Mysql Workbench take longer time (5mins) to execute first query after connecting
Submitted: 11 May 21:42 Modified: 12 May 6:45
Reporter: jayakumar Namath Email Updates:
Status: Can't repeat Impact on me:
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version:8.0.29 OS:Windows (Microsoft Windows 10 Enterprise)
Assigned to: CPU Architecture:Any
Tags: WBBugReporter

[11 May 21:42] jayakumar Namath
----[For better reports, please attach the log file after submitting. You can find it in C:\Users\MYU07HDC\AppData\Roaming\MySQL\Workbench\log\wb.log]

Mysql Workbench takes very longer time (>5mins) to execute the first query after connecting.
After opening, MySQL WB, I open a connection and execute, select database();
It takes >5mins to return the result.
In the "action output" section, until the result is fetched, it does not show up at all. So, I believe, the issue is happening somewhere from the application and not the database itself.

I read about couple of blogs / docs from MOS (2790275.1), where they have explained this behaviour.. A slowness or delay of few seconds may be acceptable; BUT, like this scenario of >5+mins is completely un-acceptable..

I tried clearing the "history output" log.. and also the .scratch / .info files from the "workspaces" directory - but it did not help my case.

How to repeat:
1. Open MySQL WB
2. Open a connection
3. Execute "select database();"
[12 May 6:45] MySQL Verification Team
Hello Jayakumar,

Thank you for the bug report.
I'm not seeing this issue at my end on Win10 with Workbench 8.0.33.
But there are similar reports, related to bug https://bugs.mysql.com/bug.php?id=96949, please follow the workaround and let us know if you are still facing the issue.

Ashwini Patil