List MySQL Table and Index Size
MariaDB [(none)]> SELECT table_schema "DB Name", Round(Sum(data_length + index_length) / 1024 / 1024, 1) "DB Size in MB"
FROM information_schema.tables
GROUP BY table_schema;
+--------------------+---------------+
| DB Name | DB Size in MB |
+--------------------+---------------+
| hope | 75714.0 |
| information_schema | 0.2 |
| mysql | 1.9 |
| performance_schema | 0.0 |
+--------------------+---------------+