query cache tuning

For anyone, who has questions about MySQL query cache tuning, try this tuning assistant:

http://dom.as/tech/query-cache-tuner/

This entry was posted in mysql and tagged , , , . Bookmark the permalink.

13 Responses to query cache tuning

  1. figvam says:

    Nice guide, concise and to the point…

  2. Julian says:

    Hum, okay. But I’ll ask one question that everyone finding this post via Google will ask anyways:

    Why?

  3. Why? Obviously because you want to tune your query cache.

    .. ahem.. sorry…

    The MySQL query cache can be a very useful tool, but if you have a high volume of queries and you don’t tune it properly it can become a bottleneck. By tuning the QC you eliminate that bottleneck and (hopefully) improve performance.

    • Mark Callaghan says:

      How does one tune away the mutex contention? It does not scale on multi-core servers.

    • Julian says:

      So 0 is the best tuning you can have. Sure.

  4. I like it, and I advertised it.

    But I liked your optimization operator more.

    Cheers

    Giuseppe

  5. Sandy says:

    I cant get to the URL or the guide you have told can you repost the correct URL. It can be of great help !!

    Thanks

  6. erkules says:

    domas you rock!
    rock on!

  7. James Day says:

    This is a bug report for your online query cache tuner.

    It doesn’t also say to set query_cache_type = 0 if your MySQL version is 5.5 or higher, to eliminate taking the qc mutex.

    Bet you never thought you’d get a bug report on that. :)

Comments are closed.