MySQL Forums
Forum List  »  Performance

Re: Low table cache hit rate
Posted by: Aftab Khan
Date: July 05, 2012 10:32AM

>The table_open_cache is currently set to 131072 and open file limit to 262304.
Table cache is too high! how many tables do you have? Does you application make heavy use of TEMPORARY tables?

please provide use output of:
SHOW GLOBAL STATUS;
SHOW GLOBAL VARIABLES;

Options: ReplyQuote


Subject
Views
Written By
Posted
24491
July 05, 2012 09:38AM
Re: Low table cache hit rate
12729
July 05, 2012 10:32AM
11747
July 07, 2012 01:31AM
10741
July 07, 2012 05:44AM


Sorry, you can't reply to this topic. It has been closed.

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.