InnoDB System Variables • innodb_force_load_corrupted • innodb_force_recovery • innodb_fsync_threshold 3248 Command-Line Format --innodb-fsync-threshold=# Introduced 8.0.13 System Variable innodb_fsync_threshold Scope Global These restrictions may cause replication administration commands to fail with an error, as replication stores the replica status logs in  InnoDB  tables. 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. Warning 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” . Command-Line Format --innodb-force-recovery=# System Variable innodb_force_recovery Scope Global Dynamic No SET_VAR  Hint Applies No Type Integer Default Value 0 Minimum Value 0 Maximum Value 6 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. Command-Line Format --innodb-force-load-corrupted[={OFF| ON}] System Variable innodb_force_load_corrupted Scope Global Dynamic No SET_VAR  Hint Applies No Type Boolean Default Value OFF