Bug #42153 Please allow QA functionality to filter on user/remote host
Submitted: 16 Jan 2009 10:27 Modified: 5 Feb 2009 6:54
Reporter: Simon Mudd (OCA) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Enterprise Monitor: Web Severity:S4 (Feature request)
Version:2.0.1.x server OS:Any
Assigned to: CPU Architecture:Any

[16 Jan 2009 10:27] Simon Mudd
Description:
Probably an agent AND web interface issue as I guess affects both parts.

IF the Query Analysis functionality is used a lot then it's extremely useful to be able to filter queries based on the remote user@host. If the appropriate filters can be used just a single value would allow user@% or %@host, or more complex combinations like test%.

For us this would allow developers to each have a mysql account and be able to filter by developer mysql login to see the queries that they are running and statistics thereof.

In production this allows you to limit the queries you see to those coming from a specific user or host.

This is IMO a very important feature and should be added as soon as possible, at least for people who intend to use the feature where there are a large number of mysql users accessing the system.

How to repeat:
N/A

Suggested fix:
Add a "remote user" field as one of the filter criteria.