Bug #88173 MySQL Workbench hangs on the first query on a fresh connection
Submitted: 21 Oct 2017 10:44 Modified: 10 Mar 2018 10:59
Reporter: mert can Email Updates:
Status: Unsupported Impact on me:
None 
Category:MySQL Workbench Severity:S5 (Performance)
Version:6.3.9 OS:Windows (Microsoft Windows 10 Pro)
Assigned to: CPU Architecture:Any
Tags: hang on first query, hung execution, stalling, WBBugReporter

[21 Oct 2017 10:44] mert can
Description:
Whenever a new connection opened in the workbench -no matter if the connection exists on another tab, no matter if there are existing connections, no matter if there are programs running in background- the very first query just "Hangs" independent from the complexity of the query and the GUI just stops responding. After a little while (approx. 20-30secs) the workbench GUI comes back and then starts to execute the query.
This problem gets resolved when I re-install the Workbench but only for a couple of weeks. Then the said behaviour arises again.

How to repeat:
The problem emerges by itself unfortunately. But after it did, can easily be repeated by simple opening a connecting and trying to run a(ny) query.

Suggested fix:
I am failing to understand the chemistry of the problem but since it happens to be recurring after some time of the reinstallation I suspect the local files that workbench cumulates by time is the culprit.
[21 Oct 2017 15:19] MySQL Verification Team
Thank you for the bug report. I could not repeat, please provide more information about the kind of connection (local, remote, etc), Server are you trying to connect. Thanks.
[21 Oct 2017 15:34] mert can
Sorry I forgot to share that.
I am connecting a remote server through Standard(TCP/IP) method.

Here is the mysql --version result in the server :
Ver 15.1 Distrib 10.1.20-MariaDB, for Linux (x86_64) using readline 5.1

Will share any further info if needed.
[21 Oct 2017 22:00] MySQL Verification Team
Thank you for the bug report. The server you are connected isn't supported by WorkBench.
[22 Oct 2017 11:30] mert can
Oh, I see. Is there any plan or intention of support in the future that you know of or should I check somewhere else ?

Thank you for the lightning fast response by the way.
[9 Mar 2018 22:06] Djo Suze
Hi, i found a solution for this problem.

I have clear the following directories in C:/Users/<%User>/AppData/Roaming/MySQL/Workbench:
- log
- sql_history

I hope it can help you.
[10 Mar 2018 10:59] mert can
Thank you for the solution. Yes it does solve the issue but only for a limited time (Most likely until the files reach a certain size). One needs to remove the said files regularly depending on the use frequency.
[21 Nov 2018 21:47] Christian Hesse
Same here, thanks for the workaround!
[9 Jan 6:04] Aryan Grover
Hi
I'm still facing the same kinda issue and After connecting to my company's database
First query generally takes a lot of time and then the execution time is normal.
Is it like due to Caching Problems

Please tell regarding that.