Shulou(Shulou.com)06/01 Report--

How to check the list in batches and repair,optimize? This problem may be often seen in our daily study or work. I hope you can gain a lot from this question. The following is the reference content that the editor brings to you, let's take a look at it!

The following is the reference code for shell:

#! / bin/bashhost_name=192.168.0.123user_name=xiaomouser_pwd=my_pwd 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 Improved 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

You can also use the mysqlcheck command, which can check the table and automatically repair the damaged table, but the process is time-consuming.

Thank you for reading! After reading the above, do you have a general understanding of the method of batch checklist and repair,optimize? I hope the content of the article will be helpful to all of you. If you want to know more about the relevant articles, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.