Skip to content

Instantly share code, notes, and snippets.

@Mexidense

Mexidense/Data free on tables of DB

Created December 8, 2018 23:46
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save Mexidense/ce9fb3818c158f6d44e8d7f27bc4f9d1 to your computer and use it in GitHub Desktop.
Save Mexidense/ce9fb3818c158f6d44e8d7f27bc4f9d1 to your computer and use it in GitHub Desktop.
Download ZIP
Data free
Raw
Data free on tables of DB
select table_name,
round(data_length/1024/1024) as data_length_mb,
round(data_free/1024/1024) as data_free_mb
from information_schema.tables
where round(data_free/1024/1024) > 5
order by data_free_mb;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment