Re: Query Cache not being used even when it has memory

Please provide exact steps to reproduce the problem and we'll look into it.

Thanks,

Ken

On Tue, Oct 16, 2012 at 10:48 AM, Philip Gladstone <philip.j.s.gladstone@gmail.com> wrote:

I have a small Cloud SQL instance and I was looking at the performance of the system.

I wondered why certain repetitive queries were not being cached by the mysql query cache. Initially, I found that I had to set the query cache size to  non-zero amount. However, after that, every query shows up in the Qcache_not_cached bucket. It appears as though there is no caching being performed. 

Is there another setting that I need to tweak to get this to work?

Philip