You guess correctly :) I set the variable in my config file and the query cache does seem to be working. The counters are incrementing and it's caching the majority of my queries (it says).
I do notice a very slight improvement in the performance but it's not as fast as I was expecting. I guess since the system I'm hosting on is only a P3600 with 128MB RAM it's probably the interpreted Perl CGI code that's bogging it down now. By the way, what is an appropriate cache memory size for such a system? Is there a point where too much allocated memory does more harm 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 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 typed SHOW VARIABLES LIKE 'QUERY_CACHE_TYPE' and it > returns ON which is exactly what I want. > > I then executed several queries from my site but none of them are being > cached. They're just plain SELECTs in most cases, any ideas why the DB won't > cache them? Do they have to be executed several times first? > > When I try and check Qcache_queries_in_cache I get an empty set, likewise > for Qcache_not_cached... so it's not caching any and it's not not caching > any > What is the values of query_cache_size variable? I guess that query_cache_size=0 ... -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]