mysql innodb_force_recovery的各个恢复级别的参数说明

Bertha 。 2022-02-25 10:58 453阅读 0赞

恢复级别参数说明：  
  
1(SRV\_FORCE\_IGNORE\_CORRUPT):忽略检查到的corrupt页。  
2(SRV\_FORCE\_NO\_BACKGROUND):阻止主线程的运行，如主线程需要执行full purge操作，会导致crash。  
3(SRV\_FORCE\_NO\_TRX\_UNDO):不执行事务回滚操作。  
4(SRV\_FORCE\_NO\_IBUF\_MERGE):不执行插入缓冲的合并操作。  
5(SRV\_FORCE\_NO\_UNDO\_LOG\_SCAN):不查看重做日志，InnoDB存储引擎会将未提交的事务视为已提交。  
6(SRV\_FORCE\_NO\_LOG\_REDO):不执行前滚的操作。

源代码中的 注释说明：

enum \{  
    SRV\_FORCE\_IGNORE\_CORRUPT = 1,   /\*!< let the server run even if it  
                    detects a corrupt page \*/  
    SRV\_FORCE\_NO\_BACKGROUND = 2,    /\*!< prevent the main thread from  
                    running: if a crash would occur  
                    in purge, this prevents it \*/  
    SRV\_FORCE\_NO\_TRX\_UNDO = 3,  /\*!< do not run trx rollback after  
                    recovery \*/  
    SRV\_FORCE\_NO\_IBUF\_MERGE = 4,    /\*!< prevent also ibuf operations:  
                    if they would cause a crash, better  
                    not do them \*/  
    SRV\_FORCE\_NO\_UNDO\_LOG\_SCAN = 5, /\*!< do not look at undo logs when  
                    starting the database: InnoDB will  
                    treat even incomplete transactions  
                    as committed \*/  
    SRV\_FORCE\_NO\_LOG\_REDO = 6   /\*!< do not do the log roll-forward  
                    in connection with recovery \*/  
\};