I’ve read around that table_cache has some performance issues if put too big. But I’ve not found any mentions what setting is too big.
I have huge about on databases with lots of tables of myisam.
So the tables just can’t fit in to table_cache and mysql opens
something like 20 tables/s which isn’t nice.
So I would like to use as big table_cache as possible. At this moment it is 2048.
There is need for filehandles for the table cache, open_files_limit is set to 16384.
Systems ulimit for open files is set to 64k.
Mysql is 5.0.45 from centos (rhel).
And the question is, how big table_cache setting i can have? and what to do sith open_files_limit (any other settings for same thing or similar thing?) and system’s ulimit.