Skip to content

Instantly share code, notes, and snippets.

@lukin0110

lukin0110/gist:4066223

Created November 13, 2012 15:10
Show Gist options
  • Save lukin0110/4066223 to your computer and use it in GitHub Desktop.
Save lukin0110/4066223 to your computer and use it in GitHub Desktop.
Download ZIP
MySql schema size
Raw
gistfile1.sql
SELECT table_schema,
SUM(data_length+index_length)/1024/1024 AS total_mb
FROM information_schema.tables
GROUP BY table_schema
ORDER BY 2 DESC;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment