Shell script to realize MySQL regular batch check table repair and optimized table optimize table

This article mainly explains "shell script to achieve MySQL regular batch check table repair and optimized table optimize table", interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Next let the editor to take you to learn "shell script to achieve MySQL regular batch check table repair and optimized table optimize table" bar!

#! / bin/bashhost_name=192.168.0.123user_name=jincon.comuser_pwd=jincon.com database=my_db_nameneed_optmize_table=truetables=$ (mysql-h$host_name-u$user_name-p$user_pwd $database-A-Bse "show tables") for table_name in $tablesdo check_result=$ (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 $(mysql-h$host_name-u$user_name-p$user_pwd $database-A-Bse" repair table $table_name ") fi # optimization table Can improve performance if [$need_optmize_table = true] then echo $(mysql-h$host_name-u$user_name-p$user_pwd $database-A-Bse "optimize table $table_name") fidone to this I believe that the "shell script to achieve MySQL regular batch check table repair and optimized table optimize table" have a deeper understanding, might as well to the actual operation of it! Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!