Skip to content

Instantly share code, notes, and snippets.

@michaelbonner

michaelbonner/size-of-tables.sql

Created August 31, 2016 15:11
Show Gist options
  • Save michaelbonner/274f097bb17a5b3c5265d59305656e16 to your computer and use it in GitHub Desktop.
Save michaelbonner/274f097bb17a5b3c5265d59305656e16 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
size-of-tables.sql
SELECT TABLE_NAME, table_rows, data_length, index_length, round(((data_length + index_length) / 1024 / 1024 ), 2 ) "MB"
FROM information_schema.TABLES
WHERE table_schema = "schema_name"
ORDER BY (data_length + index_length) DESC;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment