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

0 vote371 views1 answer
Transalations from sql to Linq count and group by
SQL
2 votes355 views1 answer
Postgresql left join distinct on
SQL
1 vote368 views1 answer
Postgresql not in
SQL
4 votes354 views3 answers
Postgres set default value
SQL
6 votes381 views2 answers
Mysqldump password in file
SQL
0 vote344 views1 answer
Find all tables where column name exists oracle
SQL
16 votes352 views2 answers
Oracle ddl
SQL
0 vote361 views1 answer
Get db connection detail from sql developer profile
SQL
0 vote377 views1 answer
Sql server for loop
SQL
4 votes352 views2 answers
Show all database inside postgresql
SQL