PMM QAN no example query

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.

I see you are using the performance_schema as the source for QAN. Have you correctly configured the performance_schema according to our documentation?

1 Like

performance_schema=ON
performance-schema-instrument=‘statement/%=ON’
performance-schema-consumer-statements-digest=ON
innodb_monitor_enable=all

UPDATE performance_schema.setup_consumers
SET ENABLED = ‘YES’ WHERE NAME LIKE ‘%statements%’;
SET GLOBAL innodb_monitor_enable = all;

Missed this last bit of the configuration. Thanks! works perfectly now.