content_image/756390.jpg content_image/756394.jpg
## QUICK 

Set the MyISAM  storage engine recovery mode. The variable value is any combination of the values of OFF , DEFAULT , BACKUP , FORCE , or QUICK . If you specify multiple values, separate them by commas. Specifying the variable with no value at server startup is the same as specifying DEFAULT , and specifying with an explicit value of ""  disables recovery (same as a value of OFF ). If recovery is enabled, each time mysqld  opens a MyISAM  table, it checks whether the table is marked as crashed or was not closed properly. (The last option works only if you are running with external locking disabled.) If this is the case, mysqld  runs a check on the table. If the table was corrupted, mysqld  attempts to repair it. 

The following options affect how the repair works. 

<img src='content_image/756390.jpg'>

Before the server automatically repairs a table, it writes a note about the repair to the error log. If you want to be able to recover from most problems without user intervention, you should use the options BACKUP,FORCE . This forces a repair of a table even if some rows would be deleted, but it keeps the old data file as a backup so that you can later examine what happened. 

See Section 16.2.1, “MyISAM Startup Options” . 

• myisam_repair_threads 

<img src='content_image/756394.jpg'>

