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 vote298 views1 answer
Limit and offset in stored procedure mssql
SQL
2 votes423 views2 answers
SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' (SQL: select * from information_schema.tables where table_schema = laravel and table_name = migrations and table_type = 'BASE TABLE')
SQL
1 vote334 views1 answer
Dropping a constraint in ms sql
SQL
0 vote254 views1 answer
Oracle sql developer script output limit
SQL
24 votes301 views2 answers
Alter table delete column
SQL
0 vote298 views1 answer
Sql server convert date to weekday
SQL
0 vote288 views1 answer
How to count with except in psql
SQL
21 votes302 views3 answers
Search for column name in sql db when i don't know which table it is in
SQL
10 votes263 views1 answer
Oracle view dependencies
SQL
3 votes294 views2 answers
WhereIn SQL
SQL