content_image/711627.jpg content_image/711625.jpg content_image/711623.jpg content_image/711619.jpg
• innodb_force_load_corrupted 

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

Permits InnoDB  to load tables at startup that are marked as corrupted. Use only during troubleshooting, to recover data that is otherwise inaccessible. When troubleshooting is complete, disable this setting and restart the server. 

• innodb_force_recovery 

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

The crash recovery mode, typically only changed in serious troubleshooting situations. Possible values are from 0 to 6. For the meanings of these values and important information about innodb_force_recovery , see Section 15.21.2, “Forcing InnoDB Recovery” . 

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

• innodb_fsync_threshold 

## Warning 

Only set this variable to a value greater than 0 in an emergency situation so that you can start InnoDB  and dump your tables. As a safety measure, InnoDB  prevents INSERT , UPDATE , or DELETE  operations when innodb_force_recovery  is greater than 0. An innodb_force_recovery setting of 4 or greater places InnoDB  into read-only mode. 

These restrictions may cause replication administration commands to fail with an error, as replication stores the replica status logs in InnoDB  tables. 

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

