On Wed, Jan 31, 2001 at 09:12:05AM +, Basil Hussain wrote:
>
> I think I understand this now. The table_cache is the maximum number
> of tables MySQL can keep open all the time. If your table_cache is
> lower than the actual number of tables in use (in my case 64 versus
> 70), then when a tab
Hi,
>> 1. I think I need to optimise table_cache. It's currently set to the
>> default of 64. There are a total of 70 tables on the system. The
>> manual says you should increase table_cache if the Opened_tables
>> status variable is big. How large is 'big'? This value is currently
>> 274 on my s
On Tue, Jan 30, 2001 at 10:56:56AM +, Basil Hussain wrote:
>
> Having just upgraded my MySQL server to the latest 3.23.32 version,
> I thought it would be a good idea to have a review of the
> configuration and try to optimise the setup further. I hope someone
> can help me by answering a few
