#!/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