Skip to content

Instantly share code, notes, and snippets.

@viezel

viezel/databases sizes.sql

Created January 29, 2020 12:21
Show Gist options
  • Save viezel/ab107eaad5499a2fba108c0b59a868b1 to your computer and use it in GitHub Desktop.
Save viezel/ab107eaad5499a2fba108c0b59a868b1 to your computer and use it in GitHub Desktop.
Download ZIP
Get sizes of all databases in server
Raw
databases sizes.sql
SELECT
table_schema 'Database Name',
SUM(data_length + index_length) 'Size in Bytes',
ROUND(SUM(data_length + index_length) / 1024 / 1024, 2) 'Size in MiB'
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