Skip to content

Instantly share code, notes, and snippets.

@miceno

miceno/table_size.sql

Created January 2, 2011 19:18
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 miceno/762750 to your computer and use it in GitHub Desktop.
Save miceno/762750 to your computer and use it in GitHub Desktop.
Download ZIP
Get the size of all tables of a database
Raw
table_size.sql
mysql -e "show table status" | awk -F'\t' '\
{\
printf ("%-25s %15d\n", $1,$7); \
s+=$7 \
} \
END{ print "resultado: ", s} \
'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment