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 |
+--------------------+---------------+

Source: forknerds.com

Similar codes

2 votes151 views1 answer
Mysql Incorrect column specifier for column
SQL
7 votes153 views2 answers
Oracle sql drop index
SQL
0 vote177 views1 answer
How to enable mysql 5.7 root user password on linux
SQL
1 vote154 views1 answer
How to use db.execute
SQL
0 vote176 views1 answer
Check database restore status sql script
SQL
0 vote147 views1 answer
Sql column as header
SQL
1 vote140 views1 answer
Drop table if exists oracle
SQL
2 votes143 views1 answer
Delete all value query
SQL
0 vote147 views1 answer
Sql pad left 0
SQL
1 vote139 views1 answer
Denied
SQL