# "N/A" show but not displaying username on the QAN dashboard for Mysql queries **URL:** \ **Category:** PMM 2.x\ **Tags:** pmm, mysql, mongodb\ **Created:** [December 3, 2024, 2:52pm UTC](https://forums.percona.com/t/n-a-show-but-not-displaying-username-on-the-qan-dashboard-for-mysql-queries/35442 "2024-12-03T14:52:50Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![Duygu](https://avatars.discourse-cdn.com/v4/letter/d/2acd7d/32.png) [@Duygu](https://forums.percona.com/u/Duygu)\ **Post date:** [December 3, 2024, 2:52pm UTC](https://forums.percona.com/t/n-a-show-but-not-displaying-username-on-the-qan-dashboard-for-mysql-queries/35442/1 "2024-12-03T14:52:51Z")
## Description: Hello, I am using PMM (managed via Docker on a VM). I want to display “User” information in the QAN dashboard for my MySQL and MongoDB instances and filter queries based on it. While QAN can accurately display “User” and “Client Host” information for PostgreSQL, it shows “n/a” for MySQL and MongoDB. How can I resolve this? Let me explain the issue using a test MySQL server (PMM-TEST) as an example. In the QAN dashboard filters, the “User” information for MySQL and MongoDB appears as “n/a.” ![qan1](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/3X/3/9/398ba8c3b63427f3ca48e21022dc447c3a559a64.jpeg) However, in the “MySQL/MySQL User Details” dashboard, I can see detailed user information. But when I click on a query and try to access it in the QAN dashboard, I encounter an error, and the filter does not work. Example link: https:///graph/d/pmm-qan/pmm-query-analytics?var-service\_name=$%7B\_\_field.labels.service\_name%7D&var-username=$%7B\_\_field.labels.user%7D&var-environment=All&var-cluster=All&var-replication\_set=All&var-database=All&var-schema=All&var-node\_name=All&var-client\_host=All&var-service\_type=All&var-node\_type=All&var-city=All&var-az=All&var-interval=auto&columns=%5B%22load%22,%22num\_queries%22,%22query\_time%22%5D&group\_by=username&order\_by=-load&from=now-12h&to=now&page\_number=1&page\_size=25&totals=false&details\_tab=details Additionally, I can view the user metrics received from the VM UI. The parameters recommended by PMM are already configured in my MySQL configuration file.[Percona Monitoring and Management](https://docs.percona.com/percona-monitoring-and-management/setting-up/client/mysql.html#settings_1) ## Version: Mysql used Performance Schema, MySQL version 8.3 , PMM Server and PMM2 agent v2.43.2 ---
**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\ **Post date:** [December 5, 2024, 2:02pm UTC](https://forums.percona.com/t/n-a-show-but-not-displaying-username-on-the-qan-dashboard-for-mysql-queries/35442/2 "2024-12-05T14:02:59Z")
Hello @Duygu, > MySQL version 8.3 ?? That’s not considered a GA version of MySQL. 8.1-8.3 were considered “innovation” releases, and not production worthy. What is your QAN source? Slow log, or perf schema? User information is not available when using perf\_schema, only when using slow log. ---
**Author:** ![Duygu](https://avatars.discourse-cdn.com/v4/letter/d/2acd7d/32.png) [@Duygu](https://forums.percona.com/u/Duygu)\ **Post date:** [December 6, 2024, 11:09am UTC](https://forums.percona.com/t/n-a-show-but-not-displaying-username-on-the-qan-dashboard-for-mysql-queries/35442/3 "2024-12-06T11:09:45Z")
Hi @matthewb , Yes, I use perfs\_schema as QAN source. Slow log is not effective for my environment. But I can see user statistics from info\_schema from prometheus metrics. Even data comes from Mysql User Details Dashboard. QAN cannot read user information from info\_schema? What can I do other than slow log? ![Screenshot 2024-12-06 at 14.02.30](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/3X/2/0/20efcde6dfaa1d14d0d3384983226c6d38aac1fa.png) ---
**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\ **Post date:** [December 6, 2024, 6:08pm UTC](https://forums.percona.com/t/n-a-show-but-not-displaying-username-on-the-qan-dashboard-for-mysql-queries/35442/4 "2024-12-06T18:08:02Z")
> [@Duygu](#): > > QAN cannot read user information from info\_schema? No, it cannot. There’s no way to correlate query data from perf-schema to user data in info-schema. ---
**Author:** ![Duygu](https://avatars.discourse-cdn.com/v4/letter/d/2acd7d/32.png) [@Duygu](https://forums.percona.com/u/Duygu)\ **Post date:** [December 6, 2024, 7:02pm UTC](https://forums.percona.com/t/n-a-show-but-not-displaying-username-on-the-qan-dashboard-for-mysql-queries/35442/5 "2024-12-06T19:02:43Z")
Sorry, I was wondering about this: in the QAN dashboard variable, an info-schema query has been assigned to “username”. And this query metrics are displayed in Explore\> Metrics. There must be an explanation for this. Could it be a bug for QAN? ![Screenshot 2024-12-06 at 21.53.00](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/3X/2/1/2103b7396de37e8608d6b51dad0ac43aba44e311.png) ---
**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\ **Post date:** [December 6, 2024, 9:27pm UTC](https://forums.percona.com/t/n-a-show-but-not-displaying-username-on-the-qan-dashboard-for-mysql-queries/35442/6 "2024-12-06T21:27:21Z")
If you are using the slow log as QAN source, then the ‘username’ filter can be used because the slow log contains a mapping of query-\>user. The perf schema does not contain this info, thus PMM cannot correlate the two data points together. ---
**Author:** ![Duygu](https://avatars.discourse-cdn.com/v4/letter/d/2acd7d/32.png) [@Duygu](https://forums.percona.com/u/Duygu)\ **Post date:** [December 6, 2024, 10:31pm UTC](https://forums.percona.com/t/n-a-show-but-not-displaying-username-on-the-qan-dashboard-for-mysql-queries/35442/7 "2024-12-06T22:31:11Z")
Okay thanks, my last question is why there is no user information in the queries for mongodb in QAN. What can I do for this? ---
**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\ **Post date:** [December 6, 2024, 10:52pm UTC](https://forums.percona.com/t/n-a-show-but-not-displaying-username-on-the-qan-dashboard-for-mysql-queries/35442/8 "2024-12-06T22:52:24Z")
Not sure on Mongo; I’m not a mongo guy 😉 I would assume a similar reason. Check the query logs in mongo and verify user information is visible.