# To configure the slow query analytics in PMM QAN dashboard performing in kubernetes environment

**URL:** <https://forums.percona.com/t/to-configure-the-slow-query-analytics-in-pmm-qan-dashboard-performing-in-kubernetes-environment/15862>\
**Category:** PMM 2.x\
**Tags:** community, pmm, mysql, percona, new-release\
**Created:** [May 27, 2022, 8:47am UTC](https://forums.percona.com/t/to-configure-the-slow-query-analytics-in-pmm-qan-dashboard-performing-in-kubernetes-environment/15862 "2022-05-27T08:47:15Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Somasuntaram\_M](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/somasuntaram_m/32/5351_2.png) [@Somasuntaram\_M](https://forums.percona.com/u/Somasuntaram_M)\
**Post date:** [May 27, 2022, 8:47am UTC](https://forums.percona.com/t/to-configure-the-slow-query-analytics-in-pmm-qan-dashboard-performing-in-kubernetes-environment/15862/1 "2022-05-27T08:47:15Z")

</div>

PMM server and PMM client are deployed and running.  
When cross verified, we are not able to get in the PMM Query analytics dashboard the slow query logs ( also difference in query time) that is shown in the slow-query log file present in MySQL. I tried to configure using [This](https://docs.percona.com/percona-monitoring-and-management/setting-up/client/mysql.html) but there was no changes.  
The other logs and metrices are working fine.  
what needs to be done to fix QAN ? can anyone please help

---

<div class="post-metadata">

**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:** [May 27, 2022, 4:45pm UTC](https://forums.percona.com/t/to-configure-the-slow-query-analytics-in-pmm-qan-dashboard-performing-in-kubernetes-environment/15862/2 "2022-05-27T16:45:41Z")

</div>

PMM can use either the slow query log or the `performance_schema` to gather query information. The pmm-client must have disk-level access to the slow log. If this is not possible, then you must configure the pmm-client to use the performance schema as the query source. Check the PMM documentation for how to change this setting.

---

<div class="post-metadata">

**Author:** ![Somasuntaram\_M](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/somasuntaram_m/32/5351_2.png) [@Somasuntaram\_M](https://forums.percona.com/u/Somasuntaram_M)\
**Post date:** [May 31, 2022, 3:19am UTC](https://forums.percona.com/t/to-configure-the-slow-query-analytics-in-pmm-qan-dashboard-performing-in-kubernetes-environment/15862/3 "2022-05-31T03:19:16Z")

</div>

After configuring the slow query logs and creating a service for MySQL in pmm inventory as mentioned in the documentation.  
The logs are not getting reflected in the query analytics dashboard.  
I expect the slow query logs whatever get logged in the slowquery.log storage in MySQL to be reflected in QAN dashboard.  
I am working in GKE environment with MySQL version8.0 and Percona xtraDB cluster version /v1-11-0

---

<div class="post-metadata">

**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:** [May 31, 2022, 1:11pm UTC](https://forums.percona.com/t/to-configure-the-slow-query-analytics-in-pmm-qan-dashboard-performing-in-kubernetes-environment/15862/4 "2022-05-31T13:11:28Z")

</div>

Is pmm-client running within the same container as MySQL? As I said above, the pmm-client must be running inside the same container/pod as MySQL and the pmm-client must be able to read the files on disk. Otherwise, you must use perf-schema as slow source.
