Skip to content

Instantly share code, notes, and snippets.

@comynli

comynli/get_size.sql

Created January 13, 2014 02:58
Show Gist options
  • Save comynli/8394027 to your computer and use it in GitHub Desktop.
Save comynli/8394027 to your computer and use it in GitHub Desktop.
Download ZIP
mysql get table size and rows
Raw
get_size.sql
SELECT TABLE_NAME,DATA_LENGTH+INDEX_LENGTH,TABLE_ROWS FROM information_schema.TABLES WHERE TABLE_SCHEMA='${database_name}' AND TABLE_NAME='${table_name}';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment