Tuning mysql's query cache
I'm looking into tuning the query cache on mysql on my linode 360. When I started, it was set at 32MB, and I was getting a non-trivial amount of qcachelowmemprunes. I added a cronjob to run FLUSH QUERY CACHE periodically, which helped, but not enough. I've been enlarging it gradually, but even at 80MB __, I still see lowmem prunes.
OTOH, I only have about a 50% hit ratio [i.e., Qcachehits is about half of Qcachehits+Comselect]. I strongly suspect that many of my queries are one time queries, and therefore should not be cached. I'd like to identify them, and mark them with SQLNO_CACHE.
Any suggestions for an easy way to do this?
It's also possible that some of my queries are not cached since the tables have changed, although I don't think, based on a rough mental model, that this is the case. At least, the results should be consistant for most queries; I'm using InnoDB, so my understanding is that a random UPDATE does not necessarily invalidate all SELECTs. Is this correct?__