Re: Tuning Table cache and temp table allocations

2004-04-22 Thread Jeremy Zawodny
On Thu, Apr 22, 2004 at 08:05:07PM -0700, Emmett Bishop wrote: > Howdy all, > > I've got a few questions about the table cache and the > tmp_table_size. > > First off, a little background info. The server has > been running now for 193 hours. I've got 3 GB of RAM > on my box and I'm running RH li

Tuning Table cache and temp table allocations

2004-04-22 Thread Emmett Bishop
Howdy all, I've got a few questions about the table cache and the tmp_table_size. First off, a little background info. The server has been running now for 193 hours. I've got 3 GB of RAM on my box and I'm running RH linux. The MySQL installation is version 4.0.13. After taking a look at Show Sta