Re: Optimizing table_cache - Open files?

[paul ernest]

Hi,

As I tried to explain, I think that (Connections * N) is the absolute minimum figure you need for the table cache. But as I also said, I think it's unlikely that you will be having 100 simultaneous connection to mysqld, Have a look at the status variable Max_used_connections. My max_connections is 100, but my Max_used_connections is only 8.

I think that for an upper bound on the table cache work out max_connections*[tables in database], which for my case is ~10,000. I currently have my table_cache set at 1024, and in a twenty four hour period the opened tables has not increased.

I guess you need to think about the maximum number of connection to your database and whether those connections are all regularly using all of the tables in the database.