Relationship between MySQL variable open_files_limit and table_open_cache

[salman khan]

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