Skip to content

Instantly share code, notes, and snippets.

@brianwebb01

brianwebb01/get_mysql_db_size.sql

Created October 21, 2015 12:38
Show Gist options
  • Save brianwebb01/50f9107464630d8426ec to your computer and use it in GitHub Desktop.
Save brianwebb01/50f9107464630d8426ec to your computer and use it in GitHub Desktop.
Download ZIP
SQL to find how big mysql report the database data to be.
Raw
get_mysql_db_size.sql
SELECT table_schema "YOUR_DB_NAME", Round(Sum(data_length + index_length) / 1024 / 1024, 1) "DB Size in 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