MySQL Forums
Forum List  »  InnoDB

Re: When need to increase table_open_cache
Posted by: Rick James
Date: June 04, 2016 05:24PM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
4503
June 01, 2016 08:05AM
Re: When need to increase table_open_cache
1998
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.