Handle Corrupted Tables

Instead of crashing the server as they used to do, corrupted InnoDB tables are simply disabled, so that the database remains available while the corruption is being fixed.

This feature adds a new system variable.

System Variables

variable innodb_pass_corrupt_table
Command Line:Yes
Config File:Yes
Variable Type:ULONG
Default Value:0
Range:0 - 1

Pass corruptions of user tables as corrupt table instead of crashing itself, when used with innodb_file_per_table. All file I/O for the datafile after detected as corrupt is disabled, except for the deletion.

Table Of Contents

Previous topic

Error Code Compatibility

Next topic

Crash-Resistant Replication