Re: Enabling Cache feature in MySQL 4

2003-01-11 Thread Paul DuBois
At 18:22 +0100 1/10/03, Blaster wrote: Happy as I was, I pulled out a test box, installed Linux Debian on it, downloaded MySQL 4 on it, everything worked smooth, now I wanted to enable the cache feature, but it didn't let me! I want the change to be permanent, so I looked up the doc pages at my

RE: Enabling Cache feature in MySQL 4

2003-01-10 Thread Andrew Braithwaite
Hi, I have a server doing 26,000 queries a second so thought it was about time to enable caching. Did some research with MySQL 4 and got it to work. After running it for a while it turned out that more than 70% of queries were coming out of cache (straight out of memory & not hitting the disk (di