Query analyzer does not filter username when using mysql_perfschema_agent. Username shows as n/a
General
Escalation
General
Escalation
Description
How to test
None
How to document
None
Attachments
3
Smart Checklist
Activity
Show:

Aaditya Dubey October 11, 2022 at 10:31 AM
Hi ,
Thank you for the report.
Verified as described. Sending the concern to engineering for further review and updates.
Details
Details
Assignee
Unassigned
UnassignedReporter

Priority
Components
Needs QA
No
Needs Doc
No
Affects versions
Environment
Hello Team,
When we use performance schema as an agent type, it does not record the usernames from which the query was run,
You can see User filter is shown as n/a. All the queries are shown 100% under it.
While when we use slowlog_agent, it shows the user properly
This is not specific to any version. Same behaviour is noticed on latest version too as well as old versions.
Regards,
Yunus Shaikh
Smart Checklist
Open Smart Checklist
Smart Checklist

Open Smart Checklist
Created October 7, 2022 at 9:27 AM
Updated November 13, 2024 at 8:29 AM
Hello Team,
When we use performance schema as an agent type, it does not record the usernames from which the query was run,
You can see User filter is shown as n/a. All the queries are shown 100% under it.
While when we use slowlog_agent, it shows the user properly
This is not specific to any version. Same behaviour is noticed on latest version too as well as old versions.
Regards,
Yunus Shaikh