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

2 votes265 views6 answers
In in sql
SQL
0 vote232 views1 answer
Flask_sqlalchemy install
SQL
0 vote269 views1 answer
Oracle list proxy users
SQL
1 vote273 views3 answers
How to truncate foreign key constraint table
SQL
-1 vote313 views2 answers
Mysql get day of week
SQL
0 vote285 views1 answer
Postgresql linux password
SQL
0 vote273 views1 answer
Mysql update set sum
SQL
2 votes316 views1 answer
Oracle run_duration to number
SQL
0 vote272 views1 answer
Mariadb hours between two dates
SQL
0 vote297 views1 answer
.sql File Run in PSQL
SQL