Description:
I work for multiple customers with all their own database- and monitoring-environment and with these customers I have the same issue regarding PMM QAN. I see the queries in QAN, I see the queries hovering over the ‘i’ symbol, the details tab is filled, but examples says: “Sorry, no examples found for this query”
I’ve seen just a few related topics but not a clear resolution or cause of this issue.
Version:
DATABASE SERVER
OS: Ubuntu 20.04.5 LTS
DBMS: 10.4.27-MariaDB
ProjectName: pmm-admin
Version: 2.38.1
PMMVersion: 2.38.1
ProjectName: pmm-agent
Version: 2.38.1
PMMVersion: 2.38.1
MONITORING SERVER
OS: Docker version 20.10.21, build 20.10.21-0ubuntu1~20.04.2
ProjectName: pmm-admin
Version: 2.38.1
PMMVersion: 2.38.1
ProjectName: pmm-agent
Version: 2.38.1
PMMVersion: 2.38.1
Additional Information:
PMM is running in Docker on a machine which runs Zabbix. Difference in configuration/setup is that PMM goes to port 8080 instead of 80 since this is used by Zabbix.
PMM uses performance schema as a source
pmm-admin list on the a database services provide the following information
And in PMM checking the PMM Inventory/Services I see a corresponding results to the image from above.