Re: A few queries about optimising MySQL variables

2001-02-01 Thread Jeremy D. Zawodny
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 table

A few queries about optimising MySQL variables

2001-01-30 Thread Basil Hussain
Hi all, 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 queries I have. Here's a bit of info about the spec. of the

Re: A few queries about optimising MySQL variables

2001-01-30 Thread Jeremy D. Zawodny
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