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
• Status: Can't repeat
• Category: MySQL Workbench
• Severity: S5 (Performance)
• Version: 8.0.17
• OS: Linux (Ubuntu 18.04 x86_64)
• CPU Architecture: Any
• Tags: WBBugReporter

[19 Sep 16:20] Arun Kumar Narayanaswami

Description:
----[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

Log

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.