Skip to content

Instantly share code, notes, and snippets.

@zomberg

zomberg/gist:d85d08556ee3978e8b47335369dd4611

Created January 28, 2017 09:28
Show Gist options
  • Save zomberg/d85d08556ee3978e8b47335369dd4611 to your computer and use it in GitHub Desktop.
Save zomberg/d85d08556ee3978e8b47335369dd4611 to your computer and use it in GitHub Desktop.
Download ZIP
Calculate size of databases
Raw
gistfile1.txt
SELECT
table_schema,
ROUND(SUM(data_length + index_length) / 1024 / 1024) "size, MB"
FROM information_schema.TABLES
WHERE table_schema NOT IN ('mysql', 'information_schema', 'performance_schema', 'test')
GROUP BY table_schema;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment