myisam自动修复表,默认为关闭(设置为""也表示关闭),可以设置为OFF, DEFAULT, BACKUP, FORCE, 或 QUICK的组合,一般设置为BACKUP, FORCE
mysql> show variables like 'myisam_recov%'; +------------------------+--------------+ | Variable_name | Value | +------------------------+--------------+ | myisam_recover_options | BACKUP,FORCE | +------------------------+--------------+ 1 row in set (0.00 sec
改参数不能动态开启,为只读参数,需要重启mysqld!
参考官方链接
http://dev.mysql.com/doc/refman/5.5/en/server-options.html#option_mysqld_myisam-recover-options
转载于:https://blog.51cto.com/imysqldba/1427375