Skip to content

Instantly share code, notes, and snippets.

@kogoto

kogoto/mysql_check_datasize.sql

Created July 3, 2015 17:31
Show Gist options
  • Save kogoto/75b34ec5b1e9402c25b4 to your computer and use it in GitHub Desktop.
Save kogoto/75b34ec5b1e9402c25b4 to your computer and use it in GitHub Desktop.
Download ZIP
[MySQL][クエリ]容量確認
Raw
mysql_check_datasize.sql
SELECT table_schema,
Sum(data_length + index_length) / 1024 / 1024 AS MB
FROM information_schema.tables
GROUP BY table_schema
ORDER BY Sum(data_length + index_length) DESC
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment