Skip to content

Instantly share code, notes, and snippets.

@thiagooak

thiagooak/table-size.sql

Created November 12, 2013 13:10
Show Gist options
  • Save thiagooak/7430553 to your computer and use it in GitHub Desktop.
Save thiagooak/7430553 to your computer and use it in GitHub Desktop.
Download ZIP
Check size of MySql tables
Raw
table-size.sql
SELECT table_name AS "table",
round(((data_length + index_length) / 1024 / 1024 / 1024), 5) "GB"
FROM information_schema.TABLES
WHERE table_schema = "database-name"
ORDER BY GB DESC;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment