Skip to content

Instantly share code, notes, and snippets.

@nawawi

nawawi/database_size.sql

Last active August 29, 2015 14:25
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save nawawi/41138bd44cab56d5a581 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save nawawi/41138bd44cab56d5a581 to your computer and use it in GitHub Desktop.
Download ZIP
sql syntax calculate size satu database
Raw
database_size.sql
-- sql syntax calculate size satu database dalam byte
-- replace namadabase kepada real database name
SELECT sum( data_length + index_length ) as size FROM information_schema.TABLES where table_schema = 'namadatabase' GROUP BY table_schema
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment