Skip to content

Instantly share code, notes, and snippets.

@jordi-pascual

jordi-pascual/size_table_database.sql

Last active April 15, 2019 11:37
Show Gist options
  • Save jordi-pascual/fe05ed19c775a2dfe30c61dbcf164961 to your computer and use it in GitHub Desktop.
Save jordi-pascual/fe05ed19c775a2dfe30c61dbcf164961 to your computer and use it in GitHub Desktop.
Download ZIP
size_tables_in_database
Raw
size_table_database.sql
SELECT table_name AS "Tables",
round(((data_length + index_length) / 1024 / 1024), 2) "Size in MB"
FROM information_schema.TABLES
WHERE table_schema = "DB_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