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

0 vote289 views1 answer
Restart postgresql.service Failed to restart postgresql.service: Unit not found.
SQL
0 vote342 views1 answer
Sql to search who modified
SQL
5 votes355 views2 answers
How to ascending order in sql
SQL
-2 votes312 views1 answer
No module named '_sqlite3
SQL
0 vote316 views1 answer
SQL Server Enterprise
SQL
1 vote263 views1 answer
Flask-sqlalchemy filter_by contains
SQL
0 vote294 views1 answer
FIND AVERAGE SALARY EARNER IN SQL
SQL
0 vote314 views1 answer
How to add timestamp column in mysql
SQL
2 votes316 views2 answers
Sql percentage
SQL
-1 vote298 views3 answers
Psql get last rows
SQL