Monday, February 10, 2014

Size of MySql Databases

This seems to work pretty well.
 SELECT table_schema "DB Name", 
   sum( data_length + index_length ) / 1024 / 1024 "DB Size in MB" 
   FROM information_schema.TABLES GROUP BY table_schema ; 

No comments:

Post a Comment