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