Bug #56924 Memory leak? Possibly not a bug.
Submitted: 22 Sep 2010 11:26 Modified: 2 Dec 2011 8:00
Reporter: gediminas gedusenka Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S2 (Serious)
Version:5.2.28 OS:Linux (Ubuntu 10.04)
Assigned to: CPU Architecture:Any
Tags: Leak, Memory, performance, RAM, usage

[22 Sep 2010 11:26] gediminas gedusenka
Description:
When started, mysql workbench uses about 33mb of ram. After some extensive usage (SQL Editor mode only), ram usage slowly and icreasingly grows to about 150mb and possibly more. Quite a much for such application? Even when closing all possible connection tabs, result tabs, SQL editing tabs, only "home" tab left, memory is not freed.

Moreover, if i open many tabs quite fast, memory usage stays relatively low. It grows after some time when using application.

'Using application' involves opening some database connections, opening several SQL editors, result tabs, running SQL statements, editing routines and tables.

How to repeat:
Extensively using SQL Editor. Happens all time.
[22 Sep 2010 12:08] Valeriy Kravchuk
Please, check if the same problem happens with a newer version, 5.2.28.
[22 Sep 2010 13:01] gediminas gedusenka
Just tested version 5.2.28, i'm afraid it's the same.

I can narrow down the problem. I simply open one connection, and repeat the same query for many times. Aprox. as each 5 times query is executed, memory grows ~1mb. Looks like its not related to returned rows or columns quantity - no matter 1000 or 1 row is returned, memory keeps growing. Nor its related to tab "output" contents - clearing it makes no sense. Closing all tabs (except "home") makes no sense too, no single mb of ram is freed.
[28 Sep 2010 15:58] MySQL Verification Team
Thank you for the bug report.
[2 Dec 2011 8:00] gediminas gedusenka
Same on windows version (Windows Vista x86). Version 5.2.35.
[21 Jul 2012 10:04] Robert Cabane
Hello, I believe the same bug happens by me (OpenSUSE 12.1, 64bit). 
When starting, the WB uses 38Mb more or less, which is correct. As I use more tabs and edit more tables, the memory consumption increases steadily. And, suddenly, my system becomes unresponsive, the hard disc starts to run continuously and after a couple of seconds the system is blocked, even Ctrl-Alt-BckSp has no effect.
The latter probably means a severe memory leak, eating all the available memory (swap included).
[21 Jul 2012 10:05] Robert Cabane
Forgotten : I'm using 5.2.40 version of the WB.
[21 Jul 2012 10:15] Robert Cabane
Seems to be a duplicate of
http://bugs.mysql.com/bug.php?id=64077
[28 Jul 2012 18:41] Jesper Plauborg
Happens with latest MySQL Workbench 5.2.41 9727 as well.
[30 Jul 2012 16:22] Robert Cabane
The severity of this bug should be changed to S1, since it causes a system hang.
[28 Nov 2014 13:06] Mike Knee
Same problem on Workbench 6.2.3.12312 build 2280 (64 bit) Windows 8.1 after installing mysql-connector-odbc-5.2.7-winx64.msi