Advanced Search

Get the MySQL databases size from

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

Expand | Embed | Plain Text

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.