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

5 votes304 views1 answer
Oracle nls instance
SQL
0 vote302 views1 answer
Sql delete from with relation
SQL
0 vote280 views1 answer
How to to get current date and time in sql
SQL
1 vote262 views1 answer
Full text index mysql
SQL
2 votes284 views1 answer
Alter table add multiple columns postgresql
SQL
8 votes270 views3 answers
Duplicate entry
SQL
0 vote307 views1 answer
Mysql insert into select transaction c#
SQL
0 vote300 views1 answer
Test database for sql
SQL
3 votes272 views4 answers
Show sql server database
SQL
1 vote251 views1 answer
Flask-sqlalchemy filter_by contains
SQL