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

1 vote144 views1 answer
Postgres convert exisiting column to text
SQL
0 vote140 views1 answer
Sql query to check if column contains alphabets
SQL
2 votes150 views1 answer
Sql server check for value in multiple columns
SQL
0 vote155 views2 answers
What is rownum in oracle
SQL
0 vote143 views1 answer
Select last N rows mysql
SQL
0 vote129 views1 answer
Incorrect string value: '\xC4\x81ne' for column
SQL
0 vote160 views3 answers
Join
SQL
0 vote138 views1 answer
Postgresql conectar
SQL
0 vote127 views1 answer
Oracle sql count occurrences of value in column
SQL
0 vote138 views1 answer
Sql change date format
SQL