# PMM QAN Only Shows USE and BEGIN Queries in Percona XtraDB Cluster, Application Queries Not Visible **URL:** \ **Category:** PMM 2.x\ **Tags:** pmm, percona\ **Created:** [August 26, 2024, 1:29pm UTC](https://forums.percona.com/t/pmm-qan-only-shows-use-and-begin-queries-in-percona-xtradb-cluster-application-queries-not-visible/32604 "2024-08-26T13:29:51Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![emretorx](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/emretorx/32/18634_2.png) [@emretorx](https://forums.percona.com/u/emretorx)\ **Post date:** [August 26, 2024, 1:29pm UTC](https://forums.percona.com/t/pmm-qan-only-shows-use-and-begin-queries-in-percona-xtradb-cluster-application-queries-not-visible/32604/1 "2024-08-26T13:29:51Z")
Hello, I’m currently using Percona Monitoring and Management (PMM) to monitor a Percona XtraDB Cluster. However, I’m facing an issue where the Query Analytics (QAN) only displays `USE` and `BEGIN` queries, and I cannot see the application queries, including their response times. ```auto Here are the details of my setup: - **PMM Configuration:** ``` ```auto pmm-admin add mysql --username=pmm --password=secret --query-source=perfschema ``` ```auto - **MySQL Grants:** SHOW GRANTS FOR 'pmm'@'%'; +------------------------------------------------------------------------------+ | Grants for pmm@% | +------------------------------------------------------------------------------+ | GRANT SELECT, RELOAD, PROCESS, SUPER, REPLICATION CLIENT ON *.* TO `pmm`@`%` | | GRANT BACKUP_ADMIN ON *.* TO `pmm`@`%` | +------------------------------------------------------------------------------+ ``` - **Version:** ```plaintext mysql Ver 8.0.36-28.1 for Linux on x86_64 (Percona XtraDB Cluster (GPL), Release rel28, Revision bfb687f, WSREP version 26.1.4.3) ``` I have another Percona XtraDB Cluster with a similar configuration, and on that setup, I can see all application queries along with their response times in QAN. I would appreciate any guidance on why this might be happening and how I can resolve it to see the application queries in PMM QAN. Thank you! ```auto ``` ---
**Author:** ![Tibor\_Korocz\_Percona](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/tibor_korocz_percona/32/17251_2.png) [@Tibor\_Korocz\_Percona](https://forums.percona.com/u/Tibor_Korocz_Percona)\ **Post date:** [August 26, 2024, 2:01pm UTC](https://forums.percona.com/t/pmm-qan-only-shows-use-and-begin-queries-in-percona-xtradb-cluster-application-queries-not-visible/32604/2 "2024-08-26T14:01:35Z")
Hi, Are the mysql settings the same? Like performance\_schema is enabled on both cluster etc… ? Because it looks like your pmm is using performance\_schema for queries. You can share the config for both cluster. ---
**Author:** ![emretorx](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/emretorx/32/18634_2.png) [@emretorx](https://forums.percona.com/u/emretorx)\ **Post date:** [August 26, 2024, 2:08pm UTC](https://forums.percona.com/t/pmm-qan-only-shows-use-and-begin-queries-in-percona-xtradb-cluster-application-queries-not-visible/32604/4 "2024-08-26T14:08:53Z")
The Performance Schema is enabled on both clusters, as shown in the output. I forgot to mention this earlier. Thank you! mysql\> SHOW VARIABLES LIKE ‘performance\_schema’; ±-------------------±------+ | Variable\_name | Value | ±-------------------±------+ | performance\_schema | ON | ±-------------------±------+ 1 row in set (0.01 sec) ---
**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:** [August 26, 2024, 2:54pm UTC](https://forums.percona.com/t/pmm-qan-only-shows-use-and-begin-queries-in-percona-xtradb-cluster-application-queries-not-visible/32604/5 "2024-08-26T14:54:56Z")
Check the performance\_schema.events\_statements\* tables. Do you see queries there? If not, then the problem is with perf schema, not PMM. PMM only reads what it can.