MySQL Forums
Forum List  »  InnoDB

When need to increase table_open_cache
Posted by: hua kai
Date: June 01, 2016 08:05AM

Always see some post and some tuning tool said if Opened_tables is large and increase fast, it's time to increase table_open_cache.

But also see other posts that when create tmp tables also will Opened_tables, so Opened_tables high may not because table_open_cache small.
And sometimes setting table_open_cache high will has problem

So which one is really true?

I have one database with table_open_cache with default value 2000, Opened_tables is 1433454, shall I increase table_open_cache?
Or I need to increase only when the Open_tables status always keep at around 1999, I found that at usage peak period, the Open_tables status reach 1999. Is this means I need to increase the value, is 3000 safe?

open_files_limit setting is 65535. Is table_open_cache setting less than open_files_limit always safe?

Options: ReplyQuote

Written By
When need to increase table_open_cache
June 01, 2016 08:05AM

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.