RE: Cache problem in 4.1

2003-08-19 Thread Landers, Jason
than good? -Original Message- From: Victoria Reznichenko [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 19, 2003 11:18 AM To: [EMAIL PROTECTED] Subject: Re: Cache problem in 4.1 "Landers, Jason" <[EMAIL PROTECTED]> wrote: > My web site is pulling from several tables tha

Re: Cache problem in 4.1

2003-08-19 Thread Victoria Reznichenko
"Landers, Jason" <[EMAIL PROTECTED]> wrote: > My web site is pulling from several tables that don't change all that often > and seems to be an ideal candidate for query caching. I tried to enable it > by copying the my-medium.cnf to /etc/my.cnf and restarted the service. From > my query editor I ty

RE: Cache problem in 4.1

2003-08-19 Thread Landers, Jason
Further investigation shows that Qcache_free_memory = 0, Qcache_free_blocks=0, and Qcache_total_blocks=0. So it seems that the cache is enabled but no sizes/limits have been allocated? Could someone tell me what I need to add/modify to my my.cnf file to set those? Or are these variables indicating