Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I have my open table cache set to 1800 and I have a total of 1112 tables. MySQL Tuning Primer reports that 100% of my table cache is used yet my table cache hit rate is 5%. I understand that this happens due to concurrent connections all opening tables. I think I should raise the cache limit. I understand that the cache size is limited by the file descriptor limit of my operating system, but are there any other practical limitations I should be aware of?

Searching Google or this very website yields mostly posts explaining the connection-factor or come up with indecisive answers.

My question: can I safely increase the open table cache limit? Is there a maximum?

share|improve this question

1 Answer 1

Ensure that the open_files_limit is 2x - 3x the value of your table_open_cache.

As an example, I have the following values:

open_files_limit = 30000
table_open_cache = 10000
share|improve this answer
    
Thanks, but my question is not about the open_files_limit but about the table_open_cache. Are there any limitations on that, apart from the open_files_limit? –  vvanscherpenseel Oct 19 '12 at 16:28
    
Aside from the open_files_limit being set accordingly to accommodate your table_open_cache setting, the only other consideration is that your OS provides enough file descriptors to also accommodate the setting. With less than 2,000 tables you should have absolutely no worry about that. –  KayakJim Oct 19 '12 at 17:14

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.