Bug #75709 Freezing UI if executing multiple queries in SQL Editor
Submitted: 31 Jan 2015 14:23 Modified: 16 Apr 2015 22:36
Reporter: Konstantinas Tarchanovas Email Updates:
Status: No Feedback Impact on me:
Category:MySQL Workbench Severity:S5 (Performance)
Version:6.2.3 OS:Linux (Ubuntu 12.04.5 LTS)
Assigned to: CPU Architecture:Any
Tags: WBBugReporter

[31 Jan 2015 14:23] Konstantinas Tarchanovas

I've been using for MySQL Workbench for 3 months and I must say it is quite a nifty tool, but one thing was bugging me the whole time and still is - occasional UI freezes.

In the previous month I've managed to detect a pattern, when those moments of freezing happen: 
It appears, that if I have "Action Output" selected in the section which is located below SQL editor (see screenshot below):


and execute multiple queries (50-100+) at once the UI freezes for a few seconds.

So importing DUMPS from some other DB is really unbearable experience.

The same thing happens, when I'm trying to import data from .CSV files, that are big enough 5-10MB+.

As the number of queries (or data from .CSV) for that matter increases the longer the UI Freezes (not only does UI become unresponsive, but also it sometimes overlays in a specific shade, that in Ubuntu indicates, that the app probably has frozen.), to a point where you can't tell if you can wait it out or just using System Monitor (or any other Process Manager) just kill MySql Workbench process.

If I just select other type of log instead of "Action Output", then this eliminates, that UI freeze for that moment, but when I open it back, then there is high chance, that UI will freeze again if there is a bunch of new messages.

This is quite annoying.

How to repeat:
- Just run 100+ queries, that execute almost instantaneously i.e. CREATE 100+ TABLES.
- Try to import 10MB+ CSV file into table using UI (without MySql terminal trickery LOAD DATA INFILE 'some_file.csv' INTO TABLE `some_table`)
[31 Jan 2015 23:16] MySQL Verification Team
Please try version 6.2.4. Thanks.
[1 Feb 2015 9:34] Konstantinas Tarchanovas
Downloaded. Updated to build 2426 (64 bits).

Tried creating 137 tables, that freezing UI is still here.
[16 Mar 2015 22:36] MySQL Verification Team
Please try version 6.2.5 and 6.2.3 rc. Thanks.
[17 Apr 2015 1:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".