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 vote196 views1 answer
Query archive mode
SQL
0 vote204 views1 answer
Get date ISO in psql
SQL
0 vote198 views1 answer
My sql data file extention
SQL
9 votes193 views3 answers
Oracle undo usage by session
SQL
0 vote203 views1 answer
Client does not support authentication protocol requested by server sqlyog
SQL
0 vote208 views1 answer
WHERE not regex in SQL
SQL
2 votes196 views4 answers
ModuleNotFoundError: No module named 'mysql'
SQL
0 vote204 views3 answers
Mysql regex replace
SQL
10 votes191 views2 answers
Sql merge statement
SQL
-1 vote209 views1 answer
Add 10 to all numbers in a column sql
SQL