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

1 vote298 views3 answers
Getdate function in postgresql
SQL
1 vote296 views1 answer
Drop df constraint sql server
SQL
2 votes301 views1 answer
Set username and password for postgresql database
SQL
11 votes302 views1 answer
Sql query to find duplicates in column
SQL
1 vote290 views1 answer
Error code 1055
SQL
31 votes294 views4 answers
How to get duplicate records with multiple field in sql
SQL
15 votes311 views5 answers
Show tables in oracle
SQL
0 vote351 views1 answer
Com.mysql.cj.exceptions.InvalidConnectionAttributeException more than one time zone. You must configure either the server or JD value if you want to utilize time zone support.
SQL
0 vote398 views1 answer
Php insert null mysql
SQL
0 vote337 views1 answer
CONVERT time string into 12 hours in sql
SQL