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 vote123 views1 answer
Oracle dynamic select into
SQL
5 votes128 views1 answer
Add column table sql default value
SQL
2 votes134 views2 answers
Microsoft sql server extract hour and minute from datetime
SQL
0 vote131 views1 answer
Oracle calculate statistics on partition
SQL
0 vote123 views1 answer
Select from 3 tables one is empty
SQL
16 votes141 views3 answers
Get count of duplicate records
SQL
18 votes132 views3 answers
'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004',
SQL
1 vote116 views1 answer
Oracle truncate partition
SQL
0 vote206 views1 answer
"inspanel" intitle:"login" -"cannot" "Login ID" -site:luckyfish.io
SQL
3 votes207 views2 answers
Savepoint in sql
SQL