.comment-link {margin-left:.6em;}

IntTech

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 ; 

Bookmark and Share

Google