Skip to content

Instantly share code, notes, and snippets.

@ericfourrier

ericfourrier/get_size_db_mysql.sql

Created February 16, 2016 18:36
Show Gist options
  • Save ericfourrier/86b1c7e5dfe307869c04 to your computer and use it in GitHub Desktop.
Save ericfourrier/86b1c7e5dfe307869c04 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
get_size_db_mysql.sql
SELECT table_schema AS "database_name", SUM(data_length + index_length) / 1024 / 1024 AS "Size (MB)" FROM information_schema.TABLES GROUP BY table_schema;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment