Skip to content

Instantly share code, notes, and snippets.

@ricardoperovano

ricardoperovano/View Tables Size Mysql

Created April 22, 2020 18:40
Show Gist options
  • Save ricardoperovano/54441812e32c24143c48683e1aa63092 to your computer and use it in GitHub Desktop.
Save ricardoperovano/54441812e32c24143c48683e1aa63092 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
View Tables Size Mysql
SELECT TABLE_NAME AS `Table`, ROUND((DATA_LENGTH + INDEX_LENGTH) / 1024 / 1024) AS `Size (MB)` FROM information_schema.TABLES WHERE TABLE_SCHEMA = "monitchat" 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