Mysql db size

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 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 vote111 views1 answer
Illuminate/Database/QueryException with message 'SQLSTATE[42S02]
SQL
1 vote107 views1 answer
Sql server get users
SQL
3 votes100 views1 answer
Mysql set field unique
SQL
0 vote96 views1 answer
Mysqldump ignore table
SQL
0 vote142 views1 answer
Sql query to select even numbers
SQL
3 votes99 views2 answers
Laravel tosql with bindings
SQL
0 vote99 views1 answer
Postgresql like
SQL
0 vote103 views2 answers
Check mysql timezone
SQL
0 vote102 views1 answer
Postgressql uuid
SQL
0 vote110 views1 answer
Mysql changer nom table
SQL