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 vote211 views1 answer
Mysql get nth highest
SQL
0 vote185 views1 answer
Mssql disable foreign key constraint
SQL
0 vote189 views1 answer
Pgsql is not permitted to log in
SQL
0 vote183 views1 answer
What is logical database schema
SQL
1 vote173 views1 answer
Oracle list datafiles in tablespace
SQL
10 votes179 views1 answer
Query to find object dependencies in oracle
SQL
9 votes175 views6 answers
Sql add column with default value
SQL
1 vote194 views1 answer
ORACLE RIGHT TWO DIGITS
SQL
0 vote198 views1 answer
Select even number id data from table
SQL
1 vote203 views1 answer
Mysql select all and rename one
SQL