#!\/bin\/bash
\nhost_name=localhost
\nuser_name=root
\nuser_pwd=123456
\ndatabase=cyxbj
\nneed_optmize_table=fales
\ntables=$(mysql -h$host_name -u$user_name -p$user_pwd $database -A -Bse “show tables”)
\nfor table_name in $tables
\ndo
\ncheck_result=$(mysql -h$host_name -u$user_name -p$user_pwd $database -A -Bse “check table $table_name” | awk ‘{ print $4 }’)
\nif [ “$check_result” = “OK” ]
\nthen
\necho “It’s no need to repair table $table_name”
\nelse
\necho $(mysql -h$host_name -u$user_name -p$user_pwd $database -A -Bse “repair table $table_name”)
\nfi<\/p>\n
if [ $need_optmize_table = true ]
\nthen
\necho $(mysql -h$host_name -u$user_name -p$user_pwd $database -A -Bse “optimize table $table_name”) \u00a0>> \/var\/log\/mysql\/check.log
\nfi
\ndone<\/p>\n
<\/p>\n
<\/p>\n
\u8bb0\u5f97\u53bb\u521b\u5efa\u6587\u4ef6\/var\/log\/mysql\/check.log<\/p>\n","protected":false},"excerpt":{"rendered":"