Unable to see Database Size with MySQL remote monitoring extension

[kms97]

Hi team, we installed MySQL Remote Monitoring Extension to monitor our databases in RDS. We can see all the dashboards populating except for database sizes which shows 0MB. Not sure which permissions are missing and how to get it populating. 

[PacoPorro]

Can I suggest you check remote extension logs in your Activegate?

https://docs.dynatrace.com/docs/shortlink/troubleshooting-active-extension#check-logs

[Mike_L · Accepted solution]

If nothing sticks out in the logs, this is the query we execute to get the size:

SELECT table_schema AS "database",
        ROUND(SUM(data_length + index_length) / 1024 / 1024, 1) as "size"
      FROM information_schema.tables
      WHERE table_schema NOT IN ('information_schema', 'sys', 'performance_schema')
      GROUP BY table_schema;

Can you run that one as the configured user and see what it returns in your environment?

[kms97]

Okay this query works as expected. The configured user wasn't granted permissions to the databases we wanted to show. Thanks, I'll mark this accepted.