Bug #96949 Mysql Workbench takes very long time to execute the first query after connecting
Submitted: 19 Sep 16:20 Modified: 19 Sep 16:34
Reporter: Arun Kumar Narayanaswami Email Updates:
Status: Can't repeat Impact on me:
Category:MySQL Workbench Severity:S5 (Performance)
Version:8.0.17 OS:Linux (Ubuntu 18.04 x86_64)
Assigned to: CPU Architecture:Any
Tags: WBBugReporter

[19 Sep 16:20] Arun Kumar Narayanaswami
----[For better reports, please attach the log file after submitting. You can find it in /home/aarayanaswami/.mysql/workbench/log/wb.log]

After opening a new MYSql connection in the workbench, the very first query takes a very long time (more than 2 mins) to execute.
All subsequent queries (in the same connection) work just fine. The issue occurs only for the first query executed after opening the connection.
Any new connection I open (in the same workbench) has the same issue for the first query executed in that connection.

Even though the query takes a long time, when it fetches the results (after about 2 mins), the Duration on the Action Output grid lists the Duration as only .07 seconds.

How to repeat:
1. Open MYSQL Workbench.
2. Open a new connection.
3. Run a query
[19 Sep 16:21] Arun Kumar Narayanaswami

Attachment: wb.log (text/x-log), 2.43 KiB.

[19 Sep 16:34] Miguel Solorzano
Thank you for the bug report. I couldn't repeat against MySQL Server 8.0.17, you are using a no supported server: Percona Server (GPL), Release 76.1.