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 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
1 Like
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.
1 Like
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
1 Like
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.
2 Likes