Skip to content

Instantly share code, notes, and snippets.

@hotsaucejake

hotsaucejake/mysql-size.md

Last active February 7, 2019 17:41
Show Gist options
  • Save hotsaucejake/0591e07cadf2446f15e5ed0723b031b2 to your computer and use it in GitHub Desktop.
Save hotsaucejake/0591e07cadf2446f15e5ed0723b031b2 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. hotsaucejake renamed this gist Feb 7, 2019. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion mysql-size → mysql-size.md
    View file
    Original file line number Diff line number Diff line change
    @@ -1,4 +1,4 @@
    ```
    ```sql
    SELECT table_schema "DB Name",
    ROUND(SUM(data_length + index_length) / 1024 / 1024, 1) "DB Size in MB"
    FROM information_schema.tables
  2. hotsaucejake revised this gist Feb 7, 2019. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion mysql-size
    View file
    Original file line number Diff line number Diff line change
    @@ -1,4 +1,4 @@
    ```mysql
    ```
    SELECT table_schema "DB Name",
    ROUND(SUM(data_length + index_length) / 1024 / 1024, 1) "DB Size in MB"
    FROM information_schema.tables
  3. hotsaucejake revised this gist Feb 7, 2019. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion mysql-size
    View file
    Original file line number Diff line number Diff line change
    @@ -1,4 +1,4 @@
    ```sql
    ```mysql
    SELECT table_schema "DB Name",
    ROUND(SUM(data_length + index_length) / 1024 / 1024, 1) "DB Size in MB"
    FROM information_schema.tables
  4. hotsaucejake created this gist Feb 7, 2019.
    6 changes: 6 additions & 0 deletions mysql-size
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,6 @@
    ```sql
    SELECT table_schema "DB Name",
    ROUND(SUM(data_length + index_length) / 1024 / 1024, 1) "DB Size in MB"
    FROM information_schema.tables
    GROUP BY table_schema;
    ```