Bug #30156 table cache not optimal advisor - incorrect information on details tab
Submitted: 31 Jul 2007 20:56 Modified: 7 Aug 2007 3:41
Reporter: Monty Taylor Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Enterprise Monitor: Advisors/Rules Severity:S3 (Non-critical)
Version:1.4 OS:Any
Assigned to: Andy Bang CPU Architecture:Any
Tags: mer 120

[31 Jul 2007 20:56] Monty Taylor 
Description:
"The table cache is used to cache open MyISAM table file handlers. As MyISAM table data is cached by the file system, only the file table handlers are held open, which is what table_cache governs. If the value of Open_tables is equal to the size of table_cache, this may indicate performance problems."

The table cache is not only used for MyISAM tables. I have actually seen severe performance problems at cluster sites when table_cache was not set high enough. Just mentioning MyISAM here could be confusing to someone not using MyISAM, they might think they can disregard this warning. 

How to repeat:
see above
[2 Aug 2007 23:08] Andy Bang 
Fixed in r6891.
[7 Aug 2007 3:41] Bill Weber 
Verified changed in Advisor jar build 1.2.0.6932.