Bug #65568 innodb_force_load_corrupted server variable is not documented

• Submitted: 8 Jun 2012 11:33
• Modified: 21 Jun 2012 1:07
• Reporter: Valeriy Kravchuk
• Status: Closed
• Category: MySQL Server: Documentation
• Severity: S3 (Non-critical)
• Version: 5.5.18+
• OS: Any
• Assigned to: John Russell
• CPU Architecture: Any

[8 Jun 2012 11:33] Valeriy Kravchuk

Description:
Recent versions of MySQL 5.5 (since 5.5.18 probably) supports innodb_force_load_corrupted server variable. It is not described anywhere in the manual though.

How to repeat:
mysql> show variables like 'innodb_force%';
+-----------------------------+-------+
| Variable_name               | Value |
+-----------------------------+-------+
| innodb_force_load_corrupted | OFF   |
| innodb_force_recovery       | 0     |
+-----------------------------+-------+
2 rows in set (0.03 sec)

mysql> show variables like '%version%';
+-------------------------+------------------------------+
| Variable_name           | Value                        |
+-------------------------+------------------------------+
| innodb_version          | 1.1.8                        |
| protocol_version        | 10                           |
| slave_type_conversions  |                              |
| version                 | 5.5.23                       |
| version_comment         | MySQL Community Server (GPL) |
| version_compile_machine | x86                          |
| version_compile_os      | Win32                        |
+-------------------------+------------------------------+
7 rows in set (0.03 sec)

Suggested fix:
Add description to http://dev.mysql.com/doc/refman/5.5/en/server-system-variables.html and other pages. Explain how and when this variable should be used, among other things...

[10 Jun 2012 8:24] MySQL Verification Team

existing docs seem to think it's a 5.6 variable:
http://dev.mysql.com/doc/refman/5.6/en/innodb-parameters.html#sysvar_innodb_force_load_cor...

[21 Jun 2012 1:07] John Russell

Added innodb_force_load_corrupted to 5.5 manual in the same places as the 5.6 manual.