MySQL Bugs: #62837: MySQL WorkBench takes a HUGE set of Memory, lags, has freezes, and might crash

Bug #62837	MySQL WorkBench takes a HUGE set of Memory, lags, has freezes, and might crash
Submitted:	20 Oct 2011 3:51	Modified:	12 Jan 2012 18:12
Reporter:	edouard guitton	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Workbench: Modeling	Severity:	S2 (Serious)
Version:	5.2.35.CE	OS:	Windows (win7 32bit)
Assigned to:		CPU Architecture:	Any
Tags:	freeze, lag, Memory

Description:
Hi,
After having worked for 2 months with MySQL Workbench 5.2.35CE (and the previous version too), I HAVE to report that after 2 min of working on a reversed engineered modelisation of my MySQL Database (which is not so huge : 76 tables, the SQL backup file is approx. 70 Mo), it takes huges amounts of RAM (from 1.5 to 2  Go Memory on a 4 Go DDRam Quad-core Win7 32bit Computer, so that's 3Gb only to use) and has CONSTANT lags / freezes (I mean : it will lag 5-10 ssec every time you click something in the modelisation, moving elements makes it worst).
Saving your work is painfull (Desktop icons takes 2-3 min to refresh and provide their images, before that they look like a blank no-extension file.
I also worked with it on a 4Go Quad-core Win7 64bit (so 1Go more of usable Ram) laptop at my company : same problem.
It might sometimes crash but most of times it doesn't, it just lags. Zombies in slow-motion are WAY faster !

Actual OS : Win7 Integral 32bit
Proc : Intel quad-core Q8200
DDRam : 4Gb
Free space on Disks : LOTS (btw : I have a mirroring RAID so that's not part of the problem)
Other software to be noted :
- Opera on background with 7 internal windows (takes something like 450 to 800 Mb Ram), I had to shut it down to help working
- Foobar200 (hmmm : 0% processor, 4.4Mb Ram)
- Apache / MySQL (WampServer Version 2.2a) running but doing nothing : I develop, so no one else accesses to my websites, and I don't make SQL doing anything while I'm on Workbench.

How to repeat:
- Install Apache 2.2.21 + Php 5.3.8 + Mysql 5.5.16
- Install MySQL Workbench 5.2.35CE
- Connect WorkBench to your local DB and reverse engineer it
- Work for more than 30 min on your modelisation arrangement while nothing else significant runs on your computer.
- Done : You got no memory and it lags all day long
- Cry...

Suggested fix:
I don't know HOW to solve this, but I know this :

- Most of other softwares aren't as smart as this one
- But none of them behaves like this

Conclusion : keep the good fonctionnality & desing / ergonomy up, but, redevelop the core of the application, or offer an Opteron to your users...

I forgot to mention it : my CPU usage is fairly low in comparison of memory usage : 3 of my quad cores are under 5-10%, one of them is under 30-40%, so that's more a memory problem than a CPU usage problem.

Please, send the output of Help > System Info menu item from all machines affected. I wonder what videocard is used.

P.S. I was able to work with reverse engineered schema of 200+ tables with older versions, both on Mac with 4G of RAM and on 5 years old Toshiba laptop with 1G of RAM and 32-bit Windows XP...

output of Help > System Info menu is : 

MySQL Workbench CE for Windows version 5.2.35
Configuration Directory: C:\Users\Poulpos\AppData\Roaming\MySQL\Workbench
Data Directory: C:\Program Files\MySQL\MySQL Workbench 5.2 CE
Cairo Version: 1.8.8
Rendering Mode: OpenGL is available on this system, so OpenGL is used for rendering.
OpenGL Driver Version: 3.3.0
OS: Microsoft Windows 7 Ultimate Edition Service Pack 1 (build 7601), 32-bit
CPU: 4x Intel(R) Core(TM)2 Quad  CPU   Q8200  @ 2.33GHz, 3.3 GiB RAM
Active video adapter: NVIDIA GeForce GT 130
Installed video RAM: 768 MB
Current video mode: 1920 x 1080 x 4294967296 couleurs
Used bit depth: 32
Driver version: 8.17.12.7533
Installed display drivers: nvd3dum.dll,nvwgf2um.dll,nvwgf2um.dll
Current user language: Français (France)

As I moved backed to Paris, I don't have anymore access to the laptop I was using @ work, I'll ask them to try to mail to me.

I also noticed that a way to reduce this effects is to save work, close MWB, en re-open my file every hour, so I can @ least work 20-30 min with very few lags and a more "normal" memory usage.

Hello edouard.
Can you please do the following for us:
- Provide a sample (.mwb file) of a Model where you can reproduce the problem.
- Can you give a try with the newest WB version (5.2.36).
Thanks.

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".