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 vote147 views1 answer
Mysql Selected All Duplicate Rows
SQL
9 votes159 views2 answers
Sql limit to 5 results
SQL
0 vote146 views1 answer
Primary key multiple colums
SQL
10 votes150 views3 answers
Sql check double value
SQL
0 vote138 views1 answer
Sql server get date of previous sunday
SQL
0 vote143 views1 answer
Find most frequent value in SQL column
SQL
0 vote144 views2 answers
Postgres show current role
SQL
2 votes195 views5 answers
Install postgresql 10 centos 7
SQL
6 votes187 views3 answers
Rename column ORACLE
SQL
0 vote146 views1 answer
Mysql create table like
SQL