Friday, March 14, 2014

Determine the size of databases in MySQL DB

mysql>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;


 

No comments:

Post a Comment