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

0 vote256 views1 answer
Mysql installer did not find packages in the current bundle suitable for installation
SQL
15 votes235 views4 answers
How to get all tables in sql
SQL
0 vote231 views1 answer
Como hacer un select entre fechas mysql
SQL
7 votes223 views1 answer
Oracle set sequence value to max(id)
SQL
0 vote233 views2 answers
Oracle create chain rule
SQL
0 vote244 views1 answer
Mysql root permission denied lost
SQL
0 vote248 views1 answer
Sqlcl format
SQL
0 vote220 views4 answers
Sql limit 1 offset 1
SQL
0 vote221 views1 answer
Mysql get 2nd value in comma separated list
SQL
1 vote235 views1 answer
Select count distinct multiple columns sql server
SQL