Re: MyISAM key cache and open tables

[Brian O'Neill]

Ok, so if a file is closed its index can not be in the key cache. So from what I can gather, when my table_cache fills up and open tables are removed from the table cache it's index is also removed from the key cache. So if I want all of my indexes to stay in the cache all the time I need to have the table_cache variable set high enough to have every table open. Happen to know how well MySQL handles having 30k open file descriptors? :)

As for the key buffer numbers, I got them from watching the memory health tab in mysql administrator. I already posted this in the performance forum last night as I wasn't sure where it should go as it kind of crossed both paths.

Thanks alot for your help,
Brian