Bug #72984 Dashboard Client Connections

• Submitted: 12 Jun 2014 9:16
• Modified: 5 Nov 2014 2:36
• Reporter: Matthias Maier
• Status: Closed
• Category: MySQL Workbench: Administration
• Severity: S3 (Non-critical)
• Version: 6.1.6
• OS: Microsoft Windows (7 SP1)
• CPU Architecture: Any
• Tags: Client Connections, dashboard

[12 Jun 2014 9:16] Matthias Maier

Description:
In MySQL Workbench Dashboard charts for Client Connections latest current value is always null and current, max, limit values are drawn on top of each other (see attached screenshots).

How to repeat:
Navigator -> Performance Dashboard -> Client Connections
See latest value on the right. Monitor current, max and limit vlaue that are drawn on top of each other. (Set connection limit accordingly)

Suggested fix:
Set current connection value to correspondant value instead of null, like it is already done in the other dashboard charts.
Arrange values (current, max, limit) so that they are not drawn on top of each other.

[12 Jun 2014 9:17] Matthias Maier

Dashboard client connections (on top of each other)

Attachment: Dashboard_maxConn1.png (image/x-png, text), 6.31 KiB.

[12 Jun 2014 9:18] Matthias Maier

Dashboard client connections (latest current value zero)

Attachment: Dashboard_maxConn2.png (image/x-png, text), 5.87 KiB.

[12 Jun 2014 10:50] MySQL Verification Team

Hello Matthias,

Thanks you for the bug report.
Verified as described.

Thanks,
Umesh

[12 Jun 2014 10:54] MySQL Verification Team

// How to repeat

1. Setup MySQL instance with max_connections to > 150
2. Put some load with the help of mysqlslap

 mysqlslap --concurrency=150 --iterations=100 --number-int-cols=2 --number-char-cols=3 --auto-generate-sql

3. Monitor the Client Connection graphs
  WB -> Performance -> Dashboard and locate client connection(total) graph
 max, limit and current would be overlapped..

[12 Jun 2014 11:08] MySQL Verification Team

On Ubuntu 14.0.4

// With the below load it can overlap even network graphs shown above client connection graphs..

mysqlslap --concurrency=450 --iterations=200 --number-int-cols=2 --number-char-cols=10 --auto-generate-sql --auto-generate-sql-load-type=mixed

[5 Nov 2014 2:36] Philip Olson

Posted by developer:
 
Fixed as of the upcoming MySQL Workbench 6.2.4 release, and here's the changelog entry:

The "Dashboard" charts for "Client Connections" latest current value was
always null, and the current, max, and limit values were overlapped.

Thank you for the bug report.