Bug #49753 Wrong table_definition_cache value in docs
Submitted: 16 Dec 2009 23:32 Modified: 18 Dec 2009 16:12
Reporter: Peter Brawley (Basic Quality Contributor) Email Updates:
Status: Closed Impact on me:
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:5.5 OS:Windows (XP)
Assigned to: Paul DuBois CPU Architecture:Any
Tags: qc

[16 Dec 2009 23:32] Peter Brawley
http://dev.mysql.com/doc/refman/5.5/en/news-5-5-0.html says:

Along with this change to statement repreparation, the default value of the table_definition_cache system variable has been increased from 128 to 256. The purpose of this increase is to lessen the chance that prepared statements will need repreparation due to referred-to tables/views having been flushed from the cache to make room for new entries. 

In fact the 5.5 default value is 400.

How to repeat:
As above.
[17 Dec 2009 4:19] Valeriy Kravchuk
Thank you for the bug report.
[18 Dec 2009 16:12] Paul DuBois
Actually, we don't need this entry in the 5.5.0 changelog, because that 5.1 change was early enough that it would have been carried up through all 5.4 into 5.5. I'll remove it.

I did find that the description for the variable in the system variable section was incorrect. I'll update that, too.