shell script to optimize database
DB_LIST=”$(mysql -u root -Bse ’show databases’ | egrep -v ‘information_schema|mysql|test’)”
for db in ${DB_LIST[@]}
do
TABLENAMES=”$(mysql -u root $db -Bse ’show tables’)”
echo “Database: “$db
for TABLENAME in ${TABLENAMES[@]}
do
mysql -u root $db -Bse “optimize TABLE $TABLENAME;”
echo $TABLENAME” table has been optimized”
done
echo $db – $TABLENAME “Optimized has been completed”
done
echo “All Databases have been successfully Optimized”
