My MySQL query_cache_size is currently set to 50M and even at that setting I am getting a decent amount of qcache_lowmem_prunes. Queries are being removed from the cache to make room for new ones. My question is whether the queries being removed are based on time elapsed since they were added to the cache (I'm thinking FIFO) or whether MySQL is smart enough to remove queries based on their hits. (Infrequently used queries are removed first).
Dani 4,329 The Queen of DaniWeb Administrator Featured Poster Premium Member
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.