Bug #79329 MySQL Workbench freezing for 3.000.000+ records table
Submitted: 18 Nov 2015 14:18 Modified: 27 Jul 2016 22:08
Reporter: Salih Ozdemir Email Updates:
Status: Unsupported Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:6.3.5 Build 201 OS:Ubuntu (15.04 x64)
Assigned to: CPU Architecture:Any
Tags: big table, crash, freeze, millions of rows

[18 Nov 2015 14:18] Salih Ozdemir
Description:
I am testing the freezing issue with two user and two database on my local. One of the account has a database with 3M+ records table and when i logged in with the user on MySQL Workbench, the program is freezing and closing itself. 

With the other user, i have another database with 2000+ records table and when i logged in, everything is okay.

Only difference is row size.

I am using i5 computer with 12GB DDR3 memory on Ubuntu 15.04 x64.

IMPORTANT: I tested the same scenario on my Windows 7 Pro (64 bit) VM on VirtualBox. I connedted my localhost via NAT connection. There was no crash. It is particular problem for Ubuntu(or Linux, i don't know).

How to repeat:
Log in a database with 3M+ records and it crashs. 

Suggested fix:
Me? No...
[24 Nov 2015 22:03] MySQL Verification Team
Thank you for the bug report. Which WorkBench 6.3.5 package you used to install on Ubuntu 15.04?. Thanks.
[25 Nov 2015 7:05] Salih Ozdemir
Hey Miguel,

It's full name of the downloaded/installed package, "mysql-workbench-community-6.3.5-1ubu1504-amd64.deb"
[26 Nov 2015 14:18] MySQL Verification Team
Thank you for the feedback. Please provide the URL from where you got that package. Thanks.
[26 Nov 2015 14:19] Salih Ozdemir
https://dev.mysql.com/get/Downloads/MySQLGUITools/mysql-workbench-community-6.3.5-1ubu1504...
[26 Nov 2015 15:43] MySQL Verification Team
Thank you for the feedback.
[8 Jan 2016 13:00] Marcin Szalowicz
Hello Salih, 
could you try version 6.3.6 please?

Also please keep in mind that we no longer support Ubuntu 15.04.
[9 Feb 2016 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".
[20 Apr 2016 15:19] Boaz Yahav
This problem is definitely around and i see many with this problem.
I have two servers, one with MySQL 5.5.43 and one with 5.6.29.
I work with different mysql workbench  versions and there is no problem working with MySQL 5.5.43. When working with 5.6.29 and SELECTING with LIMIT over 500 workbench hangs...