Bug #68777 Documentation is backwards for innodb_open_files in MySQL 5.6
Submitted: 26 Mar 2013 10:46 Modified: 26 Mar 2013 22:32
Reporter: Sheeri Cabral (Candidate Quality Contributor) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:5.6 OS:Any
Assigned to: Paul Dubois CPU Architecture:Any

[26 Mar 2013 10:46] Sheeri Cabral
Description:
http://dev.mysql.com/doc/refman/5.6/en/innodb-parameters.html#sysvar_innodb_open_files states:

"As of MySQL 5.6.6, the default value is 300 if innodb_file_per_table is enabled, and the higher of 300 and table_open_cache otherwise. Before 5.6.6, the default value is 300."

How to repeat:
On a clean install of MySQL:

mysql> show variables like 'version';
+---------------+--------------+
| Variable_name | Value        |
+---------------+--------------+
| version       | 5.6.9-rc-log |
+---------------+--------------+
1 row in set (0.00 sec)

mysql> show variables like 'innodb_open%';
+-------------------+-------+
| Variable_name     | Value |
+-------------------+-------+
| innodb_open_files | 2000  |
+-------------------+-------+
1 row in set (0.00 sec)

mysql> show variables like 'innodb_file_per_table';
+-----------------------+-------+
| Variable_name         | Value |
+-----------------------+-------+
| innodb_file_per_table | ON    |
+-----------------------+-------+
1 row in set (0.00 sec)

mysql> show variables like 'table_open_cache';
+------------------+-------+
| Variable_name    | Value |
+------------------+-------+
| table_open_cache | 2000  |
+------------------+-------+
1 row in set (0.00 sec)

Suggested fix:
Add the word "not" before enabled:

As of MySQL 5.6.6, the default value is 300 if innodb_file_per_table is *NOT* enabled, and the higher of 300 and table_open_cache otherwise. Before 5.6.6, the default value is 300.
[26 Mar 2013 11:38] Umesh Shastry
Hello Sheeri,

Thank you for the report.
Verified as described.

Thanks,
Umesh
[26 Mar 2013 11:39] Umesh Shastry
##  5.6.10-debug-log

mysql> show variables like 'innodb_open%';
+-------------------+-------+
| Variable_name     | Value |
+-------------------+-------+
| innodb_open_files | 2000  |
+-------------------+-------+
1 row in set (0.01 sec)

mysql> show variables like 'innodb_file_per_table';
+-----------------------+-------+
| Variable_name         | Value |
+-----------------------+-------+
| innodb_file_per_table | ON    |
+-----------------------+-------+
1 row in set (0.01 sec)

mysql> show variables like 'table_open_cache';
+------------------+-------+
| Variable_name    | Value |
+------------------+-------+
| table_open_cache | 2000  |
+------------------+-------+
1 row in set (0.00 sec)
[26 Mar 2013 22:32] Paul Dubois
Thank you for your bug report. This issue has been addressed in the documentation. The updated documentation will appear on our website shortly, and will be included in the next release of the relevant products.