Hi, I've seen the stats page many times, of quite a few installations and even more servers. There's one issue that keeps bothering me: the cumulative hit ratio of the query result cache, it's almost never higher than 50%.
What are your stats? How do you deal with it? In some cases i have to disable it because of the high warming penalty i get in a frequently changing index. This penalty is worse than the very little performance gain i get. Different users accidentally using the same query or a single user that's actually browsing the result set only happens very occasionally. And if i wanted the hit ratio to climb i'd have to increase the cache size and warming size to absurd values, only then i might just reach about 60% hit ratio. Cheers,
