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

0 vote214 views1 answer
Redshift running queries
SQL
13 votes183 views4 answers
Mysql select last 10 rows
SQL
4 votes180 views2 answers
Sql server date now
SQL
0 vote291 views2 answers
Reduce size of SQL server log file truncate - Source :NAYCode.com
SQL
0 vote221 views1 answer
Arithmetic expression in sql
SQL
1 vote197 views2 answers
Sql multiline comment
SQL
12 votes198 views4 answers
How to check mysql version ubuntu
SQL
2 votes184 views1 answer
Sql ignore accents
SQL
1 vote284 views1 answer
Oracle see column type
SQL
1 vote208 views1 answer
Oracle compile schema
SQL