Skip to content

Instantly share code, notes, and snippets.

@FreeSS

FreeSS/check-mysql-disabled-keys.sh

Forked from sorohan/check-mysql-disabled-keys.sh
Last active December 5, 2017 09:12
Show Gist options
  • Save FreeSS/1f30797ae36a87d44bb2dc4ba41dd11b to your computer and use it in GitHub Desktop.
Save FreeSS/1f30797ae36a87d44bb2dc4ba41dd11b to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. FreeSS revised this gist Dec 5, 2017. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion check-mysql-disabled-keys.sh
    View file
    Original file line number Diff line number Diff line change
    @@ -4,7 +4,7 @@
    # Check all databases/tables in mysql for disabled keys.
    #

    MYSQL="mysql"
    MYSQL="mysql -uUSER -pPASS"

    dbs=$(echo "show databases" | $MYSQL -N)
    for db in $dbs; do
  2. FreeSS revised this gist Dec 5, 2017. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion check-mysql-disabled-keys.sh
    View file
    Original file line number Diff line number Diff line change
    @@ -10,7 +10,7 @@ dbs=$(echo "show databases" | $MYSQL -N)
    for db in $dbs; do
    tables=$(echo "show tables" | $MYSQL -N $db)
    for tb in $tables; do
    indexes=$(echo "show indexes from $db.$tb" | mysql -N | grep disabled | awk '{print $3}')
    indexes=$(echo "show indexes from $db.$tb" | $MYSQL -N | grep disabled | awk '{print $3}')
    for i in $indexes; do
    echo "disabled index: $db.$tb.$i"
    done
  3. @sorohan sorohan created this gist Jul 15, 2014.
    18 changes: 18 additions & 0 deletions check-mysql-disabled-keys.sh
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,18 @@
    #!/bin/bash

    #
    # Check all databases/tables in mysql for disabled keys.
    #

    MYSQL="mysql"

    dbs=$(echo "show databases" | $MYSQL -N)
    for db in $dbs; do
    tables=$(echo "show tables" | $MYSQL -N $db)
    for tb in $tables; do
    indexes=$(echo "show indexes from $db.$tb" | mysql -N | grep disabled | awk '{print $3}')
    for i in $indexes; do
    echo "disabled index: $db.$tb.$i"
    done
    done
    done