Bug #30857 Add ability to create 'named connections' to connectors / processlists
Submitted: 6 Sep 2007 12:22
Reporter: Mark Leith Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Information schema Severity:S4 (Feature request)
Version:N/A OS:Any
Assigned to: CPU Architecture:Any

[6 Sep 2007 12:22] Mark Leith 
Description:
Feature request:

Add the ability to create 'named connections' within connectors, as well as the ability to view these named connections within SHOW PROCESSLIST and INFORMATION_SCHEMA.PROCESSLIST. 

This would add a new column (such as 'program_name', or 'connection_name') to the output of the processlist metadata commands, which are filled by setting a connection property within the connectors, which in turn is passed back to the server by an extension to the protocol. 

For instance, within Connector/J one can use a java property named "program_name" which can then be passed back to the server.

This is useful when you use the same username for multiple clients connecting to the database, with wildcarded hostnames - to easily identify which user a connection is associated with.

How to repeat:
N/A