PMM v2 (AWS AMI) Query Analytics not working for MySQL RDS

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

Hello,

I have MySQL RDS 8.0.17 with performance_schema ON

Yet the Query Analytics panel doesnot even shows the instance.

Is there something else I need to do ?

2

Hi, please review https://www.percona.com/doc/percona-monitoring-and-management/conf-mysql.html#perf-schema

also make sure the PMM user has proper grants e.g.

GRANT SELECT, PROCESS, REPLICATION CLIENT, RELOAD ON . TO ‘pmm’@‘%’ IDENTIFIED BY ‘*****’ WITH MAX_USER_CONNECTIONS 10;

GRANT SELECT, UPDATE, DELETE, DROP ON performance_schema.* TO ‘pmm’@‘%’;

3

Ok I am going to close the circle.

Firsts, Thanks to all those that tried to help! Username, Password and security settings had all been granted from the start.

What happened was that there were Permission Policies blocking the access on the target VPC.

It would be nice if we can add a “test” button at instance addition time so that people can check then and there to know if something is not right and not silently take the settings.

Thanks again!

4

Thanks for the additional info. I will check with the dev team about your suggestion.