Re: Low table cache hit rate
>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;
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.