#!/bin/bash
# Scott Sullivan (ssullivan@liquidweb.com) 
problems=( $(mysql -Bse "SELECT TABLE_SCHEMA,TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA NOT IN ('information_schema','mysql') AND Data_free > 0 AND NOT ENGINE='MEMORY';") )
count=0
for i in "${problems[@]}" ; do
        count=$(($count + 1))
        oddCheck=$[ $count % 2 ]
        if [ $oddCheck -eq 1 ] ; then
                result="odd"
                db="$i"
        else
                result="even"
                table="$i"
        fi
        if [ $result = "even" ] ; then
                echo "mysql -e use $db optimize table $table" 
                mysql -e "use $db; optimize table $table;"
        fi
done