# Unable to see Database Size with MySQL remote monitoring extension

**URL:** <https://community.dynatrace.com/t/unable-to-see-database-size-with-mysql-remote-monitoring-extension/46403>\
**Category:** Extensions\
**Tags:** databases, extensions, mysql\
**Created:** [July 2, 2024, 4:50am UTC](https://community.dynatrace.com/t/unable-to-see-database-size-with-mysql-remote-monitoring-extension/46403 "2024-07-02T04:50:47Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![kms97](https://avatars.discourse-cdn.com/v4/letter/k/49beb7/32.png) [@kms97](https://community.dynatrace.com/u/kms97)\
**Post date:** [July 2, 2024, 4:50am UTC](https://community.dynatrace.com/t/unable-to-see-database-size-with-mysql-remote-monitoring-extension/46403/1 "2024-07-02T04:50:47Z")

</div>

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](https://global.discourse-cdn.com/dynatrace/original/3X/3/4/341fff73b650813553d77f502a5ab9e8f3619f67.png)

---

<div class="post-metadata">

**Author:** ![PacoPorro](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/pacoporro/32/36087_2.png) [@PacoPorro](https://community.dynatrace.com/u/PacoPorro)\
**Post date:** [July 2, 2024, 7:27am UTC](https://community.dynatrace.com/t/unable-to-see-database-size-with-mysql-remote-monitoring-extension/46403/2 "2024-07-02T07:27:46Z")

</div>

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

> **[Develop your own Extensions](https://docs.dynatrace.com/docs/ingest-from/extensions/develop-your-extensions)**
>
> Develop your own Extensions in Dynatrace.

---

<div class="post-metadata">

**Author:** ![Mike\_L](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/mike_l/32/11717_2.png) [@Mike\_L](https://community.dynatrace.com/u/Mike_L)\
**Post date:** [July 2, 2024, 9:13am UTC](https://community.dynatrace.com/t/unable-to-see-database-size-with-mysql-remote-monitoring-extension/46403/3 "2024-07-02T09:13:03Z")

</div>

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

```markup
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?

---

<div class="post-metadata">

**Author:** ![kms97](https://avatars.discourse-cdn.com/v4/letter/k/49beb7/32.png) [@kms97](https://community.dynatrace.com/u/kms97)\
**Post date:** [July 3, 2024, 12:12am UTC](https://community.dynatrace.com/t/unable-to-see-database-size-with-mysql-remote-monitoring-extension/46403/4 "2024-07-03T00:12:53Z")

</div>

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.
