Bug #72626 innodb_open_files gives a warning when set to -1

• Submitted: 13 May 2014 2:34
• Modified: 13 May 2014 6:41
• Reporter: Dimitriy A
• Status: Verified
• Category: MySQL Server: Options
• Severity: S3 (Non-critical)
• Version: 5.6.17, 5.6.19
• OS: Any
• CPU Architecture: Any
• Tags: innodb_open_files, innodb-open-files

[13 May 2014 2:34] Dimitriy A

Description:
Documentation says that innodb_open_files can be set to -1, which means autosized (https://dev.mysql.com/doc/refman/5.6/en/innodb-parameters.html#sysvar_innodb_open_files).

However, setting innodb_open_files to -1 results in a warning message:
[Warning] option 'innodb-open-files': signed value -1 adjusted to 0

How to repeat:
Start MySQL with the following options in my.cnf:
innodb_open_files=-1
...

Check MySQL log file.

Suggested fix:
Either documentation needs to be updated or the discrepancy resolved in code.

[13 May 2014 6:41] MySQL Verification Team

Hello Dimitriy,

Thank you for the report.

Thanks,
Umesh