topic Unable to see Database Size with MySQL remote monitoring extension in Extensions

Unable to see Database Size with MySQL remote monitoring extension

kms97 — Mon, 19 Aug 2024 07:58:19 GMT

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.

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

PacoPorro — Tue, 02 Jul 2024 07:27:46 GMT

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

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

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

Mike_L — Tue, 02 Jul 2024 09:13:03 GMT

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?

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

kms97 — Wed, 03 Jul 2024 00:12:53 GMT

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.