On 5/31/2011 3:02 PM, Markus Jelsma wrote:
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
I believe you need SOME query cache even with low hit counts, for things
like a user paging through results. You want the query to still be in
the cache when they go to the next page or what have you. Other
operations like this may depend on the query cache too for good
performance.
So even
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
On May 31, 2011, at 2:02 PM, Markus Jelsma wrote:
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?
warmupTime : 0
cumulative_lookups : 394867
cumulative_hits : 394780
cumulative_hitratio : 0.99