Bug #71319 Unclear text in table_open_cache_instances description
Submitted: 8 Jan 2014 21:08 Modified: 22 Jan 2014 16:48
Reporter: Valeriy Kravchuk 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
Tags: table_open_cache_instances

[8 Jan 2014 21:08] Valeriy Kravchuk
Description:
Please, check http://dev.mysql.com/doc/refman/5.6/en/server-system-variables.html#sysvar_table_open_cach...:

"A session need lock only one instance to access it for DML statements. This segments cache access among instances, permitting higher performance for operations that need to use the cache when many there are many sessions accessing tables."

I think there are at least two problems in this text.

How to repeat:
Check grammar in the text above. I'd say "to" and "s" is missing in the first sentence and there is extra "many" in the second.

Suggested fix:
Maybe it should say something like:

A session needs to lock only one instance to access it for DML statements. This segments cache access among instances, permitting higher performance for operations that need to use the cache when there are many sessions accessing tables.
[9 Jan 2014 8:52] MySQL Verification Team
Hello Valeriy,

Thank you for the report.
Verified as described.

Thanks,
Umesh
[22 Jan 2014 16:48] 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.

Yes, the wording is substandard. Revised as suggested, except that that second "needs to" can be removed as well:

A session needs to lock only one instance to access it for DML
statements. This segments cache access among instances, permitting
higher performance for operations that use the cache when there are
many sessions accessing tables.