Skip to content

Instantly share code, notes, and snippets.

@YourFriendCaspian

YourFriendCaspian/calc_mysql_db_size.txt

Forked from blasterpal/calc_mysql_db_size.txt
Created August 29, 2017 05:06
Show Gist options
  • Save YourFriendCaspian/60ab3c8d09bbf3e192aadc290a8868d1 to your computer and use it in GitHub Desktop.
Save YourFriendCaspian/60ab3c8d09bbf3e192aadc290a8868d1 to your computer and use it in GitHub Desktop.
Download ZIP
Calculate MySQL Database Size
Raw
calc_mysql_db_size.txt
SELECT table_schema "Data Base Name", SUM( data_length + index_length) / 1024 / 1024
"Data Base 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