How to get 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

5 votes144 views1 answer
Mysql count lines
SQL
0 vote131 views1 answer
Dump multiple tables mysql
SQL
3 votes150 views2 answers
Postgres alter table owner
SQL
2 votes159 views1 answer
SQL column name Postgre
SQL
0 vote150 views3 answers
Duplicate row mysql
SQL
0 vote159 views1 answer
Get initial in sql
SQL
0 vote149 views1 answer
Alter table add check constraint oracle
SQL
10 votes132 views3 answers
Sql limit results
SQL
0 vote165 views1 answer
Where field is null sql knex
SQL
3 votes167 views3 answers
Illuminate database queryexception could not find driver (sql select * from
SQL