Skip to content

Instantly share code, notes, and snippets.

@maheshgawali

maheshgawali/mysql_innodb_space_usage.sql

Created February 10, 2020 12:09
Show Gist options
  • Save maheshgawali/eabf678e08a53ef1d99c7f02097f350a to your computer and use it in GitHub Desktop.
Save maheshgawali/eabf678e08a53ef1d99c7f02097f350a to your computer and use it in GitHub Desktop.
Download ZIP
mysql query to get approximate space usage per table (for innodb)
Raw
mysql_innodb_space_usage.sql
SELECT table_schema as `Database`, table_name AS `Table`, round(((data_length + index_length) / 1024 / 1024), 2) `Size in MB` FROM information_schema.TABLES where table_schema = "<YOUR_DATABASE_NAME_HERE>" ORDER BY (data_length + index_length) DESC;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment