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.
- can you share output?
- can you run query and post output?
- 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'@'%';