Skip to content

Instantly share code, notes, and snippets.

@brianyoungblood

brianyoungblood/gist:561efdb3e5afc31ef39699e1672d812f

Created May 10, 2018 21:06
Show Gist options
  • Save brianyoungblood/561efdb3e5afc31ef39699e1672d812f to your computer and use it in GitHub Desktop.
Save brianyoungblood/561efdb3e5afc31ef39699e1672d812f to your computer and use it in GitHub Desktop.
Download ZIP
size of mysql db
Raw
gistfile1.txt
SELECT table_schema "DB Name",
ROUND(SUM(data_length + index_length) / 1024 / 1024, 1) "DB Size in MB"
FROM information_schema.tables
WHERE table_schema='[db-name]'
GROUP BY table_schema
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment