Posted By

sergeygerasimov on 12/15/10


Tagged

mysql


Versions (?)

Who likes this?

1 person have marked this snippet as a favorite

56k


Get the MySQL databases size from


 / Published in: SQL
 

  1. SELECT table_schema "Data Base Name",
  2. sum( data_length + index_length ) / 1024 /
  3. 1024 "Data Base Size in MB",
  4. sum( data_free )/ 1024 / 1024 "Free Space in MB"
  5. FROM information_schema.TABLES
  6. GROUP BY table_schema ;

Report this snippet  

You need to login to post a comment.