Skip to content

Instantly share code, notes, and snippets.

@adimircolen

adimircolen/Mysql_DB_Size

Created July 13, 2015 14:23
Show Gist options
  • Save adimircolen/e428ae2273b4b0cb0b78 to your computer and use it in GitHub Desktop.
Save adimircolen/e428ae2273b4b0cb0b78 to your computer and use it in GitHub Desktop.
Download ZIP
Mysql Database Size
Raw
Mysql_DB_Size
SELECT table_schema "DATABASE", 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