Skip to content

Instantly share code, notes, and snippets.

@rpuglielli

rpuglielli/tableSize.txt

Created January 18, 2017 17:46
Show Gist options
  • Save rpuglielli/ee6885db73e5aef797065337eb8213df to your computer and use it in GitHub Desktop.
Save rpuglielli/ee6885db73e5aef797065337eb8213df to your computer and use it in GitHub Desktop.
Download ZIP
Size of table
Raw
tableSize.txt
SELECT nomeDaTabela, data_length / 1024 / 1024 "Tamanho da tabela - MB", index_length / 1024 / 1024 "Tamanho do indice - MB", engine
FROM information_schema.TABLES WHERE table_name like 'nomeDaTabela';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment