Skip to content

Instantly share code, notes, and snippets.

@sbimikesmullin

sbimikesmullin/mysql_size.sql

Created March 14, 2015 18:24
Show Gist options
  • Save sbimikesmullin/acafe36169e11bc6123d to your computer and use it in GitHub Desktop.
Save sbimikesmullin/acafe36169e11bc6123d to your computer and use it in GitHub Desktop.
Download ZIP
MySQL Table/Database/Index Size on Disk
Raw
mysql_size.sql
SELECT table_schema, table_name AS "Tables",
round(((data_length + index_length) / 1024 / 1024), 2) "Size in MB"
FROM information_schema.TABLES
ORDER BY (data_length + index_length) DESC
LIMIT 10;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment