Get database size mysql

SELECT table_schema "DB Name",
        ROUND(SUM(data_length + index_length) / 1024 / 1024, 1) "DB Size in MB" 
FROM information_schema.tables 
GROUP BY table_schema;

Source: stackoverflow.com

Mysql check db size

SELECT table_schema "DB Name",
        ROUND(SUM(data_length + index_length) / 1024 / 1024, 1) "DB Size in MB" 
FROM information_schema.tables 
GROUP BY table_schema;

Source: stackoverflow.com

Similar codes

0 vote354 views1 answer
Get statis values sql
SQL
0 vote325 views1 answer
How to connect postgresql database with java
SQL
0 vote378 views1 answer
Download sql file of countries names
SQL
0 vote349 views1 answer
SQL Server dynamic pivot unknown number of columns
SQL
0 vote360 views1 answer
Psql check table fields
SQL
-1 vote347 views1 answer
SQL SERVER microsoft How to Add Column at Specific Location in Table
SQL
-1 vote355 views3 answers
PS5
SQL
0 vote330 views1 answer
Sqlcmd xml output insert line break after every 2033 characters
SQL
0 vote344 views1 answer
Supprimer les valeur d'une table mysql
SQL
1 vote312 views2 answers
DROP TABLes regardless of constraints
SQL