[root@bbs ~]# /usr/local/mysql/bin/mysqlcheck -Aao -auto-repair -uroot -p
下面说下几个参数的含义
-a, –analyze 分析 [Analyze given tables]
-o, –optimize 优化
[Optimize table]
-A, –all-databases 所有的数据库 [Check all the
database]
–auto-repair 自动修复 [If a checked table is corrupted, automatically
fix it. Repairing will be done after all tables have been checked, if corrupted
ones were found]vi /opt/shell/mysql_opt.sh
-o, –optimize 优化
[Optimize table]
-A, –all-databases 所有的数据库 [Check all the
database]
–auto-repair 自动修复 [If a checked table is corrupted, automatically
fix it. Repairing will be done after all tables have been checked, if corrupted
ones were found]vi /opt/shell/mysql_opt.sh
/usr/local/mysql/bin/mysqlcheck -Aao -auto-repair -uroot -p
* * */1 * * /opt/shell/mysql_opt.sh
转载请注明：爱开源 » 每天MySQL自动优化