MySQL: Database Size

· 1 min read

I always forget how to get the size of a MySql database. So here it is:

SELECT
     table_schema as `Database`,
     table_name AS `Table`,
     round(((data_length) / 1024 / 1024), 2) `data_length`,
     round(((index_length) / 1024 / 1024), 2) `index_length`,
     round(((data_length + index_length) / 1024 / 1024), 2) `total`
FROM information_schema.TABLES
ORDER BY (data_length + index_length) DESC;

Comments