MySQL Bugs: #88173: MySQL Workbench hangs on the first query on a fresh connection

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

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.

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.

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.

Thank you for the bug report. The server you are connected isn't supported by WorkBench.

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.

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.

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.

Same here, thanks for the workaround!

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.