Bug #49914 To hard to find a connection
Submitted: 24 Dec 2009 16:43 Modified: 20 Aug 2010 10:13
Reporter: Mike Frank Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:5.2.11 OS:Any
Assigned to: Alfredo Kojima CPU Architecture:Any

[24 Dec 2009 16:43] Mike Frank
Description:
If you have 20 or more connections. LRU pushes new connection to bottom so that is confusing.  also if many hard to find a connection

How to repeat:
Go to home screen - create 40 or so connections

Try to navigate

Suggested fix:
HOME screen -- 
Option to sort
Connection list in alpha by connection name

and

Type ahead find in the list
[24 Dec 2009 16:59] Valeriy Kravchuk
Thank you for the feature request.
[26 Mar 2010 14:28] Sheeri Cabral
This is *definitely* a problem.  The home screen itself only shows the first 7 or so (and I have a high-res monitor, etc).  

Here are some ways to do it:

0) easy hacky way:  keep the list sorted in lexical order.  Then users can workaround by naming our "most frequently used" connections something like "aaa db1" and our least frequently used connections something like "zzz db2".

1) a little harder, but much nicer:  Be able to drag-and-drop sort the list of connections in "Manage Connections".

2) most difficult, but best for all:  Have nested groups (default is top-level group) shown in tree format so users can start to make connections and see them like this:

db1
db2
db3
qadb1
qadb2
qadb3

(just like current functionality)

and then when the list starts to get unwieldy, servers can be grouped tree-wise so users will see:

+ production
+ qa

which when expanded will be:

- production
 - db1
 - db2
 - db3
- qa
 - qadb1
 - qadb2
 - qadb3

There should be an implicit top-level group and any number of nested groups (theoretically unlimited, but practically there will be a maximum, probably 10 is plenty of levels).  So we could have something like this:

- backupdb (server)
- production (groupname)
 - master (groupname)
  - db1 (server)
 - read slaves (groupname)
  - db2 (server)
  - db3 (server)
- qa (groupname)
 - qadb1 (server)
 - read slaves (groupname)
  - qadb2 (server)
  - qadb3 (server)

Type-ahead can be implemented at any of these levels.
[8 Apr 2010 22:11] Alfredo Kojima
Added alphabetical sorting to the connection and instance lists. 
Manual reordering of the list will be added at a later time.
[20 Aug 2010 10:13] Johannes Taxacher
Thank you for your bug report. This issue has already been fixed in the latest released version of that product, which you can download at

  http://www.mysql.com/downloads/