Skip to content

Instantly share code, notes, and snippets.

@blasterpal

blasterpal/calc_mysql_db_size.txt

Created June 21, 2012 15:39
Show Gist options
  • Save blasterpal/2966490 to your computer and use it in GitHub Desktop.
Save blasterpal/2966490 to your computer and use it in GitHub Desktop.
Download ZIP
Calculate MySQL Database Size
Raw
calc_mysql_db_size.txt
SELECT table_schema "Data Base Name", SUM( data_length + index_length) / 1024 / 1024
"Data Base Size in MB" FROM information_schema.TABLES GROUP BY table_schema ;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment