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.
Can I suggest you check remote extension logs in your Activegate?
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?
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.
