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

2 votes101 views1 answer
Enum in SQL Server
SQL
0 vote102 views4 answers
Mysql select bottom 10 rows
SQL
1 vote120 views3 answers
Connection string mysql
SQL
2 votes119 views1 answer
Oracle percentage
SQL
1 vote121 views2 answers
How to install mysql workbench in ubuntu 20.04
SQL
9 votes121 views3 answers
Where clause sql
SQL
0 vote76 views2 answers
How to combine two sql queries in one result
SQL
0 vote234 views2 answers
Mysql insert rows to another database
SQL
0 vote103 views1 answer
Login failed for login due to trigger execution
SQL
3 votes106 views2 answers
Postgres show table schema
SQL