Find out MySQL Database sizes
March 6, 2019
DB Groesse (GB)
code
SELECT TABLE_SCHEMA AS db,
ROUND(SUM(data_length + index_length) / 1024 / 1024 / 1024, 2) AS size_gb
FROM information_schema.tables
GROUP BY TABLE_SCHEMA;
DB Groesse (MB)
code
SELECT TABLE_SCHEMA AS db,
ROUND(SUM(data_length + index_length) / 1024 / 1024, 2) AS size_mb
FROM information_schema.tables
GROUP BY TABLE_SCHEMA;