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 vote263 views1 answer
Order by ip address sql
SQL
0 vote308 views1 answer
Disable database droping sql
SQL
0 vote272 views1 answer
Cursor.execute (sql, value) ValueError: operation parameter must be str
SQL
5 votes285 views2 answers
Get number of columns sql
SQL
13 votes306 views4 answers
What is sql
SQL
1 vote270 views1 answer
Mysql best tutorial for beginners
SQL
0 vote272 views1 answer
Liquibase update row
SQL
2 votes279 views1 answer
How to get non distinct values in sql
SQL
0 vote274 views2 answers
Close external port 3306 with iptables
SQL
1 vote265 views1 answer
Return size of tables in mysql
SQL