Re: When need to increase table_open_cache
1433454 tables were opened in the last hour? That is a lot. In the last Year? That is insignificant. My recommendations:
Opened_tables / Uptime < 2 tables opened per second.
table_open_cache < open_files_limit / 3
If Open_tables is too much smaller than table_open_cache, them maybe the cache is too big.
Table_open_cache_misses / Uptime < 1 per second
Table_open_cache_overflows / Uptime < 1 per second
Keep in mind that the OS has a limit on files (ulimit) which feeds to open_files_limit, which constrains table_open_cache.
See also table_definition_cache, innodb_open_files, table_open_cache_instances
Subject
Views
Written By
Posted
4516
June 01, 2016 08:05AM
1813
June 03, 2016 01:13AM
Re: When need to increase table_open_cache
2009
June 04, 2016 05:24PM
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.