Hi everyone, i recently installed pmm on my AWS EC2 instance, and i wanted to monitor metrics of my RDS Aurora for mysql 8.0 and i believe i managed to set everything up using this guide: https://docs.percona.com/percona-monitoring-and-management/setting-up/client/aws.html
I created and attached the IAM role with the policy they’ve put on the guide, i created and used the database user with privileges that they specified and after all that, i got a bunch of mysql metrics appearing including query analiytics, which is nice , but the actual thing that i am looking for which is the database cpu and ram usage is nowhere to be seen. On top of that, the Mysql Amazon Aurora dashboard has no data on it, as seen in the picture bellow while the Mysql instance summary and Mysql instance overview do.
This probably has something to do with the permissions whether it being the IAM policy or the Database user’s permissions. Any type of help is appreciated
Edit: My OS Node Overview for my aurora instance is also empty
Also, for a bit more context, i have enhanced monitoring and performance insights enabled for my aurora.
Here are the mysql user permissions: