Mysql implementation of the batch inspection table and repair and optimize method _mysql

This article describes the MySQL implementation of the batch inspection table and repair and optimize method. Share to everyone for your reference, specific as follows:

The following is the Shell reference code:

#!/bin/bash
host_name=192.168.0.123
user_name=xiaomo
user_pwd=my_pwd 
database=my_db_name
Need_optmize_table=true
tables=$ (mysql-h$host_name-u$user_name-p$user_pwd $database-A-bse "Show Tables")
For table_name in $tables
do
 check_result=$ (mysql-h$host_name-u$user_name-p$user_pwd $database-A-bse "check Table $table _name "| awk ' {print $} ')
 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 be raised high 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")
 fi
Done


   

You can also use the Mysqlcheck command, which allows you to check tables and automatically fix damaged tables, but this process can be time-consuming.

For more information about MySQL interested readers can view the site topics: "MySQL Transaction operation skills Summary", "MySQL stored process skills encyclopedia", "MySQL database lock related skills summary" and "MySQL common function large summary"

I hope this article will help you with the MySQL database meter.