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.
- variable innodb_pass_corrupt_table¶
Command Line: Yes Config File: Yes Scope: Global Dynamic: 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.