Bug #77801 Workbench Crashes when Expanding Database Table Tree
Submitted: 22 Jul 2015 16:41 Modified: 27 Nov 2015 11:54
Reporter: Sergiu Hlihor Email Updates:
Status: Closed Impact on me:
Category:MySQL Workbench Severity:S1 (Critical)
Version: build 828 (64 bits) OS:Ubuntu (OS 64bit 14.04 desktop )
Assigned to: CPU Architecture:Any

[22 Jul 2015 16:41] Sergiu Hlihor
Expanding a database table tree with 20K+ table leads to Workbench crashing. Due to this bug, workbench is not usable on Linux. This bug impacts all 6.x versions and was previously reported for windows here: https://bugs.mysql.com/bug.php?id=66036

How to repeat:
Install Workbench on Ubuntu Desktop 14.04 LTS and create 20K+ tables in one schema then try to expand.
[23 Jul 2015 6:42] MySQL Verification Team
Hello Sergiu,

Thank you for the report.
Observed this on Windows 7 with WB 6.3.4  revision 0 build 828 (64 bit).

[21 Sep 2015 17:49] Philip Olson
Posted by developer:
Fixed as of the upcoming MySQL Workbench 6.3.5 release, and here's the changelog entry:

Expanding the schema tree for a database that contained a large number of
tables, such as 20,000 tables, would cause a crash.

Thank you for the bug report.
[27 Nov 2015 11:54] Sergiu Hlihor
Tested with 6.3.5 official release. The issue appears to be fixed, however the loading time still makes the workbench useless. It can take tens of seconds or minutes to load the tree which makes the workbench useless when looking for a particular table or set of tables. For same dataset, executing "SHOW TABLES" is instant.

Please advise if there is any configuration change that could make the loading faster. Thanks!