Skip to content

Instantly share code, notes, and snippets.

@ffeast

ffeast/mysql_table_sizes.sql

Created June 21, 2016 19:02
Show Gist options
  • Save ffeast/16b8a616d8eb945f77cc8777c51eff70 to your computer and use it in GitHub Desktop.
Save ffeast/16b8a616d8eb945f77cc8777c51eff70 to your computer and use it in GitHub Desktop.
Download ZIP
Mysql table sizes in the selected database
Raw
mysql_table_sizes.sql
SELECT
table_name,
round(((data_length + index_length) / 1024 / 1024), 2) size_mb
FROM information_schema.TABLES
WHERE table_schema = (SELECT database())
ORDER BY size_mb DESC;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment