Not the answer you need?
Register and ask your own question!

QAN window not logging db queries running on RDS Aurora

govindareddy20govindareddy20 ContributorCurrent User Role Beginner
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.

Comments

  • MykolaMykola Percona Percona Staff Role
    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'@'%';
    
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.