MySQL Bugs: #59467: 4 second lockup when creating a new table

Bug #59467	4 second lockup when creating a new table
Submitted:	13 Jan 2011 13:31	Modified:	13 Jun 2013 23:18
Reporter:	Mihai Draghicioiu	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench: Modeling	Severity:	S5 (Performance)
Version:	5.2.31	OS:	Linux (Debian Squeeze, Ubuntu 10.04)
Assigned to:		CPU Architecture:	Any
Tags:	lockup

Description:
When creating a new table, there is a 100%cpu usage freeze for 4 seconds. It seems to be related to the Columns tab. It only happens when switching to the Columns tab and there is no column yet in the new table. The first row in the list of columns has an editable name (text box). If I switch to another tab it works fine (under a second, though still very slow :P ), but when i switch back to the Columns tab (before adding any columns), it does the 4 second lockup again. Also, this seems to happen when the Datatype is in editable mode as well, and there is only 1 column.

How to repeat:
Click on 'Create table' either on a diagram or in a model tab. The lockup should occur immediately. Then, without adding any columns or doing anything else, click on another tab ('Indexes' for example), and then click on Columns again. The same thing should happen, a 4 second freeze.

Suggested fix:
booze

Cpu is intel celeron, single core, 1.80GHz
Ram is 2GB
Gfx is Intel Corporation 82945G/GZ Integrated Graphics Controller

I agree that we have a notable delay (4 seconds or so) while clicking on Column tab. Verified under 32-bit Ubuntu 10.04 virtual machine:

MySQL Workbench CE for Linux/Unix version 5.2.31
Configuration Directory: /home/openxs/.mysql/workbench
Data Directory: /usr/share/mysql-workbench
Cairo Version: 1.8.10
Rendering Mode: OpenGL is not available on this system, so Native is used for rendering.
OS: Linux 2.6.32-27-generic
CPU: Intel(R) Pentium(R) 4 CPU 3.00GHz 2992.958 MHz, 0.7 GB RAM

Fixed as of the upcoming MySQL Workbench 6.0.2 public beta release, and here's the changelog entry:

Switching to the "Columns" tab while creating a new table would cause
MySQL Workbench to spike its CPU usage.

Thank you for the bug report.