shell script to Analyze 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 “Analyze TABLE $TABLENAME;”
echo $TABLENAME “Analyze has been done”
done
echo $db – $TABLENAME “Analyzis has been completed”
done
echo “All Databases have been successfully Optimized”
