Skip to content

Instantly share code, notes, and snippets.

@Mexidense

Mexidense/Table sizes

Created December 8, 2018 23:31
Show Gist options
  • Save Mexidense/218c2ea59a9d0af00b5d74729702422e to your computer and use it in GitHub Desktop.
Save Mexidense/218c2ea59a9d0af00b5d74729702422e to your computer and use it in GitHub Desktop.
Download ZIP
How to know table sizes on mysql for one DB
Raw
Table sizes
SELECT
TABLE_NAME AS `Table`,
ROUND((DATA_LENGTH + INDEX_LENGTH) / 1024 / 1024) AS `Size (MB)`
FROM
information_schema.TABLES
WHERE
TABLE_SCHEMA = "<NAME_DB>"
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