Bug #56144 Workbench Administration, Connections tab, list always scrolling itself
Submitted: 20 Aug 2010 13:29 Modified: 13 Dec 2010 17:12
Reporter: Victor Ferrada Email Updates:
Status: Closed Impact on me:
Category:MySQL Workbench: Administration Severity:S3 (Non-critical)
Version:5.2.26 CE OS:Windows (Windows 7 64bit)
Assigned to: Mike Lischke CPU Architecture:Any

[20 Aug 2010 13:29] Victor Ferrada
Connecting to a very active database server running MySQL 5.1.33 on CentOS4 with close to 3000 connections, MySQL Workbench 5.2.26 CE running on Windows 7 Enterprise 64bit.

This is a continuous process and am unable to find any mention of this in the bug list or how to fix this. At first I thought it was a performance problem and found references to making changes to the "Undo History Size" setting but this has no effect.

I go back to using the MySQL Administrator application which works fine (and behaves more responsive, incidentally).

How to repeat:
Steps to reproduce:
1. Open up MySQL Workbench
2. Select the appropriate host under Server Administration
3. Note the settings of the Server Status, particularly the Connection Usage which in this case is sitting at just under 2800 connections
4. Watch the scroll handle on the right side of list grow then shrink back down
5. Scroll half-way down the list, after about a second, point 4 reoccurs and the list position is reset to the beginning
6. While it rescrolls, application freezes for a second
7. Forced to go back to using MySQL Administrator application to view connections

Suggested fix:
Possible problem with "auto-refresh"?
[20 Aug 2010 13:33] Victor Ferrada
I missed a step between points 3 and 4 in the "How to reproduce" section, which should state:

3.5. Click on the Connections /Edit Connection List/ tab
[24 Aug 2010 19:20] Sveta Smirnova
Thank you for the report.

Verified as described.

This can be a feature though, because if you select a connection it scrolls down in such a way so selected connection is last in the list.
[25 Aug 2010 13:06] Victor Ferrada
So will it be considered a bug? Because until it stops behaving as it does currently, it's completely unusable.
[10 Nov 2010 13:49] Mike Lischke
Fixed in repository.
[8 Dec 2010 20:40] Johannes Taxacher
fix confirmed in repository
[13 Dec 2010 17:12] Tony Bedford
An entry has been added to the 5.2.31 changelog:

In the Connections tab of the Administrator, scrolling did not work correctly when there were large numbers of connections.