Skip to content

Instantly share code, notes, and snippets.

@davidromani

davidromani/get MySQL databases size

Last active August 29, 2015 13:57
Show Gist options
  • Save davidromani/9531321 to your computer and use it in GitHub Desktop.
Save davidromani/9531321 to your computer and use it in GitHub Desktop.
Download ZIP
Get MySQL databases size
Raw
get MySQL databases size
SELECT table_schema, sum(data_length + index_length)/1024/1024 AS used_space_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