denrepo

MySQLStorage

Database sizes

Data plus index size for each schema. Figures come from table statistics, so they're estimates.

Not yet verified. How scripts are tested

b-my-dbsize.sql 
1SELECT table_schema AS database_name,2       ROUND(SUM(data_length + index_length) / 1024 / 1024, 1) AS size_mb3FROM information_schema.tables4GROUP BY table_schema5ORDER BY size_mb DESC;

Paste it into your query tool.

Open in denrepo

More MySQL scripts: Storage