Skip to content

Instantly share code, notes, and snippets.

@netsensei
Created December 13, 2011 09:51
Show Gist options
  • Save netsensei/1471445 to your computer and use it in GitHub Desktop.
Save netsensei/1471445 to your computer and use it in GitHub Desktop.
MySQL Get table sizes if you don't have PHPMyAdmin
SELECT table_schema "<tablename>", sum( data_length + index_length ) / 1024 / 1024 "Data Base Size in MB", sum( data_free )/ 1024 / 1024 "Free Space in MB" FROM information_schema.TABLES GROUP BY table_schema ;
SELECT table_name, sum( data_length + index_length ) / 1024 / 1024 FROM tables WHERE table_schema = "<tablename>";
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment