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

4 votes344 views1 answer
Oracle select first 10 rows
SQL
3 votes354 views2 answers
Postgres show table schema
SQL
0 vote376 views1 answer
Sql query use select name inside where clause
SQL
2 votes368 views4 answers
Check timezone of mysql database
SQL
6 votes348 views2 answers
If not exists insert sql
SQL
3 votes341 views1 answer
Two selects in one query
SQL
0 vote337 views2 answers
Find lowest number in sql
SQL
0 vote358 views1 answer
Sql server beginning of month
SQL
1 vote360 views3 answers
How to truncate table with foreign key constraint
SQL
0 vote330 views1 answer
Find number of entries sql
SQL