cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

I can't see DB Size with Mysql Remote Monitoring Extension

kms97
Visitor

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. 

kms97_0-1719895521925.png

 

3 REPLIES 3

PacoPorro
Dynatrace Leader
Dynatrace Leader

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

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

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?

Mike

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. 

Featured Posts