How to Obtain the Size of the MySQL Managed Database⚓
Summary⚓
This article will list the steps involved in obtaining the size of the MySQL Managed database on DigitalOcean.
Tip
The query listed below will be done on a Mac using TablePlus, but can be done in any application that makes use of SQL queries.
How-To⚓
- Open TablePlus and connect to the database.
username = ****************
password = ****************
host = ${{ hostname }}
port = 25060
database = defaultdb
sslmode = REQUIRED
- Open the SQL Query section.
- Run the following query, which should return the output below:
SELECT table_schema "database_name",
ROUND(SUM(data_length + index_length) / 1024 / 1024, 1) "DB Size in MB"
FROM information_schema.tables
GROUP BY table_schema;
| database_name | DB Size in MB |
|---|---|
| bookstack | 21.6 |
| defaultdb | 18.6 |
| ghost_production | 1.8 |
| information_schema | 0.0 |
| mysql | 7.8 |
| performance_schema | 0.0 |
| sys | 0.0 |