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

4 votes220 views2 answers
Mysql how to change default charset
SQL
2 votes213 views1 answer
Oracle create directory
SQL
0 vote216 views1 answer
Postgres select except
SQL
0 vote222 views1 answer
How to print records of employees hired in particular month in oracle
SQL
0 vote243 views1 answer
Sqlcmd xml output insert line break after every 2033 characters
SQL
0 vote241 views4 answers
What is unique key in sql
SQL
1 vote229 views1 answer
How to test for sql injection
SQL
0 vote228 views1 answer
Window function to forward fill
SQL
1 vote227 views1 answer
Oracle datafile max size 32gb
SQL
5 votes237 views2 answers
Sql server port number
SQL