Bug #60179 Memory leaks and slow app
Submitted: 19 Feb 2011 13:50 Modified: 18 May 2011 15:35
Reporter: Boro Bokic Email Updates:
Status: Can't repeat Impact on me:
Category:MySQL Workbench Severity:S2 (Serious)
Version:5.2.31 OS:Linux (Arch linux x86_64)
Assigned to: CPU Architecture:Any
Tags: memory leak workbench slow aplication

[19 Feb 2011 13:50] Boro Bokic
When I use this aplicatiof for cca 1h it becomes very slow. 
When I mark some query and hit "Ctrl+Shift+Return" it needs cca 5s to start executing. When I look in System Monitor, I see that WB uses 200MB+ (when I start it, that value is cca 50MB).

I have 4GB RAM, Intel i5 processor (quad core)

It's very poor to restart application every few hours, since I'm entering queries (not using GUI), so I need to have opened application and its query tabs all  time.

How to repeat:
Use application for a 1h. For example you can export some result set with 1000+ rows and go to "Open SQL script" and execute it. I think that will use more RAM
[23 Apr 2011 15:10] Valeriy Kravchuk
Please, check if the same problem still happens with a newer version, 5.2.33.
[17 May 2011 13:11] Boro Bokic
I think it work now normally!
Thank you!
[18 May 2011 15:35] Valeriy Kravchuk
Not repeatable with 5.2.33 it seems.
[23 May 2011 1:21] ;Matti Ressler
Workbench Memory Leak

Attachment: Workbench.png (image/png, text), 159.59 KiB.

[23 May 2011 1:25] ;Matti Ressler
I have version 5.2.33 and it has a massive memory leak.

Working on a database with around 100 tables, just adding unsigned to all the INT columns and the application choked, pulling a constant 3.14GB of RAM and pronounced CPU spikes on both processors.

Running Window 7 - 64 bit, AMD Turion Ultra Dual Core Mobile M620 2.5GHz, 4GB RAM

See above attachment
[23 May 2011 1:34] ;Matti Ressler
I should probably also mention that I was also dragging columns during the process, grouping all my INT, TINYINT, VARCHAR, TEXT etc. columns together for easier reading, so maybe this could be the culprit.
[23 May 2011 4:06] ;Matti Ressler
Also, in regard to the attachment.  That memory usage is not going up and down, its just sitting there constantly at 3.14GB while the processors spike as steady as a heartbeat.