Skip to content

Instantly share code, notes, and snippets.

@markomilivojevic
Created February 22, 2019 12:40
Show Gist options
  • Save markomilivojevic/77ab990cded8573163ed217db25567fc to your computer and use it in GitHub Desktop.
Save markomilivojevic/77ab990cded8573163ed217db25567fc to your computer and use it in GitHub Desktop.
SELECT
table_schema AS `Database`,
table_name AS `Table`,
ROUND(((data_length + index_length) / 1024 / 1024 / 1024),
2) `Size in GB`
FROM
information_schema.TABLES
WHERE
ROUND(((data_length + index_length) / 1024 / 1024 / 1024), 2) > 1
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