Bug #92590 Workbench client connections memory leak
Submitted: 27 Sep 2018 19:51 Modified: 29 Oct 2018 14:12
Reporter: Jason Brunette Email Updates:
Status: Open Impact on me:
Category:MySQL Workbench: Administration Severity:S2 (Serious)
Version:8.0.12 OS:Microsoft Windows
Assigned to: CPU Architecture:Any
Tags: memory leak client connections

[27 Sep 2018 19:51] Jason Brunette
Windows 10 64bit
Windows 7 64bit

MySQL Workbenchs 6.3.9 - 8.0.12
MySQL Servers 5.5.29 - 5.7.19

The Administrative - Client Connections tab leaks significant amounts of memory, especially when a Refresh Rate is active and long running queries are common.

How to repeat:
On an idle server, Open the Administrative - Client Connections tab and set the Refresh Rate to .5s, then run the following SQL. Where it says "REPEAT 10000x", it means to copy/paste the "1=1 AND ..." line within the comment 10000 times.

The SQL required to trigger the memory leak is by no means limited to what is used below.  Larger queries simply amplify the effect, making it easier to witness the leak.  The contents of the comment are not important.  The use of SLEEP() is not important, nor is the presence of a comment.

1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND 1=1 AND

While the query is executing, observe memory usage with your favorite tool.
[27 Sep 2018 19:54] Jason Brunette
Process Explorer performance graph

Attachment: leak.png (image/png, text), 12.92 KiB.

[27 Sep 2018 19:56] Jason Brunette
In the above image, the client connections tab was refreshing every .5 seconds on a completely idle server.  The increase in the Private Bytes graph is when the query was executed.  The end of the increases occurs when the query completes.  the client connections tab was closed but resulted in no memory being freed.
[29 Oct 2018 14:12] Jason Brunette
Affects any architecture.