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
- 11 Oct 2022, 10:31 AM
- 07 Oct 2022, 09:22 AM
- 07 Oct 2022, 09:20 AM
Smart Checklist
Activity
Show:
Aaditya Dubey October 11, 2022 at 10:31 AM
Hi @Yunus Shaikh,
Thank you for the report.
Verified as described. Sending the concern to engineering for further review and updates.
Details
Details
Assignee
Unassigned
UnassignedReporter
Yunus Shaikh
Yunus ShaikhPriority
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.
[root@app1 ~]# pmm-admin list
Service type Service name Address and port Service ID
MySQL app1-mysql 127.0.0.1:3306 /service_id/d1cdc1c2-b14d-40d4-9cb7-468a025f219e
Agent type Status Metrics Mode Agent ID Service ID Port
pmm_agent Connected /agent_id/545cb37a-07bb-4fc5-9872-a852e688e029 0
node_exporter Running push /agent_id/8ea68050-69ad-493d-ac28-2d10408a1702 42001
mysqld_exporter Running push /agent_id/0e9a6525-86b6-4bb1-b849-a857370861a7 /service_id/d1cdc1c2-b14d-40d4-9cb7-468a025f219e 42000
mysql_perfschema_agent Running /agent_id/9c675684-54b6-4f5a-be2d-545afcac6784 /service_id/d1cdc1c2-b14d-40d4-9cb7-468a025f219e 0
vmagent Running push /agent_id/d1928056-0c85-4f4a-b16a-b51343aa2692 42002
While when we use slowlog_agent, it shows the user properly
[root@lb network-scripts]# pmm-admin list
Service type Service name Address and port Service ID
MySQL lb-mysql 127.0.0.1:3306 /service_id/f4bf0171-49c9-45c1-8ca7-c37dc7d79a95Agent type Status Metrics Mode Agent ID Service ID Port
pmm_agent Connected /agent_id/221880e0-b643-4db3-9203-f926c13465d7 0
node_exporter Running push /agent_id/72baeb69-c2c9-4f4c-9a50-7368cdc0a91f 42000
mysqld_exporter Running push /agent_id/b26c2c75-68e6-4d38-a186-419dc195b4db /service_id/f4bf0171-49c9-45c1-8ca7-c37dc7d79a95 42001
mysql_slowlog_agent Unknown /agent_id/47814dd3-1b2a-467a-8f8c-9ddd1abfd2e4 /service_id/f4bf0171-49c9-45c1-8ca7-c37dc7d79a95 0
vmagent Running push /agent_id/e210b9ef-5e82-4d4d-824f-c07a7aab5ae6 42002
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.
[root@app1 ~]# pmm-admin list Service type Service name Address and port Service ID MySQL app1-mysql 127.0.0.1:3306 /service_id/d1cdc1c2-b14d-40d4-9cb7-468a025f219e Agent type Status Metrics Mode Agent ID Service ID Port pmm_agent Connected /agent_id/545cb37a-07bb-4fc5-9872-a852e688e029 0 node_exporter Running push /agent_id/8ea68050-69ad-493d-ac28-2d10408a1702 42001 mysqld_exporter Running push /agent_id/0e9a6525-86b6-4bb1-b849-a857370861a7 /service_id/d1cdc1c2-b14d-40d4-9cb7-468a025f219e 42000 mysql_perfschema_agent Running /agent_id/9c675684-54b6-4f5a-be2d-545afcac6784 /service_id/d1cdc1c2-b14d-40d4-9cb7-468a025f219e 0 vmagent Running push /agent_id/d1928056-0c85-4f4a-b16a-b51343aa2692 42002
While when we use slowlog_agent, it shows the user properly
[root@lb network-scripts]# pmm-admin list Service type Service name Address and port Service ID MySQL lb-mysql 127.0.0.1:3306 /service_id/f4bf0171-49c9-45c1-8ca7-c37dc7d79a95Agent type Status Metrics Mode Agent ID Service ID Port pmm_agent Connected /agent_id/221880e0-b643-4db3-9203-f926c13465d7 0 node_exporter Running push /agent_id/72baeb69-c2c9-4f4c-9a50-7368cdc0a91f 42000 mysqld_exporter Running push /agent_id/b26c2c75-68e6-4d38-a186-419dc195b4db /service_id/f4bf0171-49c9-45c1-8ca7-c37dc7d79a95 42001 mysql_slowlog_agent Unknown /agent_id/47814dd3-1b2a-467a-8f8c-9ddd1abfd2e4 /service_id/f4bf0171-49c9-45c1-8ca7-c37dc7d79a95 0 vmagent Running push /agent_id/e210b9ef-5e82-4d4d-824f-c07a7aab5ae6 42002
This is not specific to any version. Same behaviour is noticed on latest version too as well as old versions.
Regards,
Yunus Shaikh