"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]