Skip to content

Instantly share code, notes, and snippets.

@CB9TOIIIA

CB9TOIIIA/[mysql] Узнаём размер БД через консоль

Created May 28, 2018 12:15
Show Gist options
  • Save CB9TOIIIA/4bc9f5eb41998773502927a3ce099413 to your computer and use it in GitHub Desktop.
Save CB9TOIIIA/4bc9f5eb41998773502927a3ce099413 to your computer and use it in GitHub Desktop.
Download ZIP
[mysql] Узнаём размер БД через консоль
Raw
[mysql] Узнаём размер БД через консоль
SELECT table_schema "database_name", sum( data_length + index_length )/1024/1024 "Data Base Size in MB" FROM information_schema.TABLES GROUP BY table_schema;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment