Bug #72052 The default value of table_open_cache is wrong in the reference manual
Submitted: 16 Mar 2014 16:36 Modified: 17 Mar 2014 13:47
Reporter: Sadao Hiratsuka Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:5.6.16 OS:Any
Assigned to: Paul DuBois CPU Architecture:Any

[16 Mar 2014 16:36] Sadao Hiratsuka 
Description:
The default value of table_open_cache is wrong in the reference manual.

How to repeat:
http://dev.mysql.com/doc/refman/5.6/en/table-cache.html

"The cache of open tables is kept at a level of table_open_cache entries.
The default value is 400;"

Suggested fix:
I think the default value is 2,000 (5.6.8~).
[17 Mar 2014 5:43] MySQL Verification Team 
Hello Sadao,

Thank you for the report.

Thanks,
Umesh
[17 Mar 2014 13:47] 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.

Modified text:

The cache of open tables is kept at a level of table_open_cache
entries. The default value is autosized at server startup. To set the
value explicitly, set the table_open_cache system variable at
startup. Note that MySQL may temporarily open more tables than this
to execute queries.