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.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.051 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.