Query analyzer does not filter username when using mysql_perfschema_agent. Username shows as n/a

Description

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

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

Assignee

Reporter

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

Created October 7, 2022 at 9:27 AM
Updated November 13, 2024 at 8:29 AM