Skip to content

Instantly share code, notes, and snippets.

@groggu

groggu/foo.sql

Created March 5, 2015 20:09
Show Gist options
  • Save groggu/d70834c49ee2957e2a13 to your computer and use it in GitHub Desktop.
Save groggu/d70834c49ee2957e2a13 to your computer and use it in GitHub Desktop.
Download ZIP
Get the size of all your mysql databases
Raw
foo.sql
SELECT
table_schema as "db name",
SUM( data_length + index_length) / 1024 / 1024 as "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