Get the MySQL databases size from


/ Published in: SQL
Save to your folder(s)



Copy this code and paste it in your HTML
  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


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.