MySQL how to: size

Showing posts with label size. Show all posts

Friday, December 5, 2014

Here is a simple select that will give you the size for each databases in your MySQL instance

SELECT table_schema "db_name",

sum(data_length+index_length) /1024/1024 "db_size in Mb"

FROM information_schema.tables

GROUP BY 1;