Innodb_force_recovery affect the recovery of the InnoDB storage engines, the default is 0, said when the need to restore perform all

Innodb_force_recovery can be set to 1 to 6, in front of the big number includes the influence of all Numbers, after setting parameter value greater than 0, the table can be select, create, drop, but the insert, update, or delete this type of operation is not allowed,

1 (SRV_FORCE_IGNORE_CORRUPT) : ignore check to corrupt page,

2 (SRV_FORCE_NO_BACKGROUND) : to stop the operation of the main thread, such as the main thread to execute full purge operations, can lead to a crash,
3 (SRV_FORCE_NO_TRX_UNDO) : don't execute transaction rollback operation,
4 (SRV_FORCE_NO_IBUF_MERGE) : do not insert buffer merge,
5 (SRV_FORCE_NO_UNDO_LOG_SCAN) : don't view the redo log, InnoDB storage engines uncommitted transactions will be deemed to have submitted,
6 (SRV_FORCE_NO_LOG_REDO) : does not perform the operation of the roll forward,