#!/usr/local/bin/bash
# Quick script to find out which databases and tables needs to be optimized
# Written by hip0
# Licensed under GPL 2.0
# http://www.gnu.org/licenses/gpl-2.0.txt
f=0;
mysql_bin=/usr/local/bin/mysql;
mysql_pass="pass";
echo $mysql_pass;
for i in $(echo "show databases" | $mysql_bin -u root -p"$mysql_pass" | grep -v Database); do
if [ "$(echo "use $i; show table status where Data_free!=0;" | $mysql_bin -u root -p"$mysql_pass")" ]; then
echo "Database: $i needs to be OPTIMIZED";
echo "use $i; show table status where Data_free!=0;" | $mysql_bin -u root -p"$mysql_pass";
fi
done