Mysql check 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 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

10 votes166 views2 answers
Mysql alter add foreign key
SQL
0 vote161 views1 answer
How to order result of subquery in select
SQL
0 vote163 views1 answer
Oracle list proxy users
SQL
1 vote170 views1 answer
Where database run
SQL
6 votes157 views4 answers
Delete table sqlite
SQL
10 votes324 views4 answers
Mysql if else
SQL
12 votes149 views5 answers
Sql merge
SQL
0 vote164 views1 answer
Insert or update cassandra
SQL
0 vote162 views1 answer
Mysql count by month
SQL
0 vote206 views1 answer
Postgres execute multiple sql file from command line
SQL