MySQL Forums
Forum List  »  Performance

Relationship between MySQL variable open_files_limit and table_open_cache
Posted by: salman khan
Date: September 09, 2016 04:34AM

Hi,

I want to know what is the relationship between the variables 'open_files_limit' and 'table_open_cache'. Does count (value) of 'open_files_limit' also include count (value) of 'table_open_cache' ?

As i am getting errno:24 can't open file (Too many open files) while altering a table in MySQL 5.6.

And my server variable are as follows:

innodb_open_files : 300
open_files_limit : 5000
table_open_cache : 3000
max_connections : 151

Do i have to increase the value of table_open_cache only or increase the value of open_files_limit and table_open_cache both ? Also what will be the impact on performance if i keep same values for both the variables?

Thanks,
Salman

Options: ReplyQuote


Subject
Views
Written By
Posted
Relationship between MySQL variable open_files_limit and table_open_cache
1594
September 09, 2016 04:34AM


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.