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 vote128 views1 answer
Window function to forward fill
SQL
0 vote129 views1 answer
Into operator in sql
SQL
0 vote119 views1 answer
Mysql cli output to a file
SQL
0 vote125 views1 answer
Convert polygon to text in mysql
SQL
2 votes123 views1 answer
Pdo mysql insert
SQL
1 vote104 views2 answers
Mysql type conversion
SQL
0 vote129 views1 answer
Add sqlcmd to path linux
SQL
10 votes68 views1 answer
Oracle view dependencies
SQL
0 vote117 views1 answer
Alter precision
SQL
1 vote115 views1 answer
Loading local data is disabled mysql
SQL