Skip to content

Instantly share code, notes, and snippets.

@deevis

deevis/gist:2601b62a842006547289

Created January 8, 2015 18:39
Show Gist options
  • Save deevis/2601b62a842006547289 to your computer and use it in GitHub Desktop.
Save deevis/2601b62a842006547289 to your computer and use it in GitHub Desktop.
Download ZIP
MySQL table storage summary
Raw
gistfile1.sql
SELECT table_name AS "Tables", table_rows, round(((data_length + index_length) / 1024 / 1024), 2) "Size in MB" FROM information_schema.TABLES WHERE table_schema = "pyr_revel_prod" 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