Low table cache hit ratio
I'm trying to optimize my server using MySQLTuner-perl but I'm looking at something strange; I get very a low table cache hit ratio:
Table cache hit rate: 4% (267 open / 6K opened)
The table_open_cache is currently set to 131072 and open file limit to 262304.
I went over the MySQL manual regarding opening and closing of tables (version 5.5 chapter 8.4.3.1) and there three situations are mentioned;
* When the cache is full
* When the cache contains more than table_open_cache entries
* When a table flushing operation occurs.
I know for sure the last 2 don't occur, I'm not sure which cache is referred to in the first.
Is there a way to find out why MySQL keeps closing the tables?
Thx.
Arno
Subject
Written By
Posted
Low table cache hit ratio
July 04, 2012 07:45AM
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.