Skip to content

Instantly share code, notes, and snippets.

@gwagroves

gwagroves/table_sizes.sql

Created February 2, 2017 16:09
Show Gist options
  • Save gwagroves/a3026037c1b06d907fbb00dd22089ae6 to your computer and use it in GitHub Desktop.
Save gwagroves/a3026037c1b06d907fbb00dd22089ae6 to your computer and use it in GitHub Desktop.
Download ZIP
MySQL: Shows table sizes in MB
Raw
table_sizes.sql
SELECT table_name, round(((data_length + index_length) / 1024 / 1024), 2) `Size in MB` FROM information_schema.TABLES;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment