Mariadb used space

mysql> select table_schema, sum((data_length+index_length)/1024/1024) AS MB from information_schema.tables group by 1;
+--------------------+-----------------+
| table_schema       | MB              |
+--------------------+-----------------+
| prod               | 298025.72448921 |
| information_schema |      0.00781248 |
| maatkit            |     70.77330779 |
| mysql              |      0.66873168 |
| test               |   4752.31449127 |
+--------------------+-----------------+
5 rows in set (0.01 sec)

Source: dba.stackexchange.com

Similar codes

5 votes117 views1 answer
Mysql get last day of month
SQL
0 vote133 views1 answer
Min varias colunas spark sql
SQL
0 vote130 views1 answer
Use between operator in mysql
SQL
0 vote135 views1 answer
Postgress append string in select
SQL
0 vote143 views1 answer
Arithmetic expression in sql
SQL
2 votes123 views2 answers
Get all tables using like
SQL
1 vote203 views1 answer
Primary key reset in SQL database
SQL
0 vote141 views1 answer
Check the size of the tables here ordered from the biggest size
SQL
0 vote141 views1 answer
How to find table lock and row lock in mysql
SQL
0 vote142 views1 answer
How to populate a table in MySQL from and existing csv file
SQL