#!/bin/bashhost_name=127.0.0.1user_name=user_pwd=database=need_optmize_table=falsetables=$(/usr/local/webserver/mysql/bin/mysql -h$host_name -u$user_name -p$user_pwd $database -a -bse show tables)for table_name in $tablesdo check_result=$(/usr/local/webserver/mysql/bin/mysql -h$host_name -u$user_name -p$user_pwd $database -a -bse check table $table_name | awk '{ print $4 }') if [ $check_result = ok ] then echo it's no need to repair table $table_name else echo $(/usr/local/webserver/mysql/bin/mysql -h$host_name -u$user_name -p$user_pwd $database -a -bse repair table $table_name) fi # ...,..... if [ $need_optmize_table = true ] then echo $(/usr/local/webserver/mysql/bin/mysql -h$host_name -u$user_name -p$user_pwd $database -a -bse optimize table $table_name) fidone