Hello.
I think you have a big fragmentation of your query cache. Fragmentation can force the query cache to prune (delete) queries from the cache due to lack of memory. See: http://dev.mysql.com/doc/mysql/en/query-cache-configuration.html Remigiusz Soko$owski <[EMAIL PROTECTED]> wrote: > let's say that we have the following settings: > Variable_name: query_cache_limit Value: 64kB > Variable_name: query_cache_size Value: 4MB > > and status: > > | Qcache_queries_in_cache | 1679 | > | Qcache_inserts | 2242534 | > | Qcache_hits | 1058592 | > | Qcache_lowmem_prunes | 135641 | > | Qcache_not_cached | 2558808 | > | Qcache_free_memory | 1717208 | > | Qcache_free_blocks | 485 | > | Qcache_total_blocks | 3885 | > > I wonder why Qcache_lowmem_prunes grows, even though Qcache_free_memory > is almost 2MB. > I thought that queries are thrown from cache only in situation, when: > 1. there were some changes in data of that query > 2. there is no memory for new query > > and Qcache_free_memory should be close to 0 to achieve the state when > queries are thrown away. > Anybody has an explaination for such behaviour? > > Thanks in advance > Remigiusz > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [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]
