QAN window not logging db queries running on RDS Aurora

Percona Monitoring and Management (PMM) PMM 1.x
1

Hi,
I installed pmm 1.1.3 on EC2 instance and added aurora clusters to collect mysql metrics.
I used the below command to install pmm-server,
sudo docker run -d -p 80:80 --volumes-from pmm-data --name pmm-server -e METRICS_RETENTION=360h -e METRICS_RESOLUTION=5s --restart always percona/pmm-server:1.1.3
Performance_schema and slow_log are ON and QAN is using performance_schema. I’m not seeing actual db queries running on Aurora instance in QAN window. It’s logging the queries running by pmm-server means the queries that needs the metrics. Grafana is working fine.

2

Hi,

  1. can you share output?
  2. can you run query and post output?
  3. is monitoring user has the following grants?

GRANT SELECT, PROCESS, REPLICATION CLIENT ON *.* TO 'pmm'@'%' IDENTIFIED BY 'pass' WITH MAX_USER_CONNECTIONS 10;
GRANT SELECT, UPDATE, DELETE, DROP ON performance_schema.* TO 'pmm'@'%';
3

Do you have the solution for this issue?
I add DB from RDS Aurora to PMM but can’t see the QAN. Other metric like host utilization is available.