Skip to content

Instantly share code, notes, and snippets.

@mrhillsman

mrhillsman/mydbsize.sh

Last active April 30, 2016 21:49
Show Gist options
  • Save mrhillsman/105fa5d392ee1043cf4689ede590fd9e to your computer and use it in GitHub Desktop.
Save mrhillsman/105fa5d392ee1043cf4689ede590fd9e to your computer and use it in GitHub Desktop.
Download ZIP
Raw
mydbsize.sh
#!/bin/bash
mysql -e "SELECT table_schema \"Data Base Name\", \
sum( data_length + index_length ) / 1024 / 1024 \"Data Base Size in MB\", \
sum( data_free )/ 1024 / 1024 \"Free Space 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