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.

 

[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

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 ,

Thank you for the report.
Verified as described. Sending the concern to engineering for further review and updates.

Details

Assignee

Reporter

Priority

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

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

Flag notifications