Skip to content

Instantly share code, notes, and snippets.

@motammem

motammem/database table sizes

Created May 9, 2017 09:17
Show Gist options
  • Save motammem/08374f8cb780bbf05ca5709f69e8ab95 to your computer and use it in GitHub Desktop.
Save motammem/08374f8cb780bbf05ca5709f69e8ab95 to your computer and use it in GitHub Desktop.
Download ZIP
Get database table sizes in mb and desc order
Raw
database table sizes
SELECT
table_name AS `Table`,
round(((data_length + index_length) / 1024 / 1024), 2) `Size in MB`
FROM information_schema.TABLES
WHERE table_schema = "__database__"
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