query cache tuning

Posted on July 8, 2009 by Domas Mituzas

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

http://mituzas.lt/tech/query-cache-tuner/

This entry was posted in mysql. Bookmark the permalink.

11 Responses to query cache tuning

  1. figvam says:
    July 8, 2009 at 20:47

    Nice guide, concise and to the point…

  2. Julian says:
    July 8, 2009 at 22:12

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

    Why?

  3. Justin Swanhart says:
    July 8, 2009 at 22:27

    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.

  4. Giuseppe Maxia says:
    July 8, 2009 at 23:58

    I like it, and I advertised it.
    http://twitter.com/datacharmer/status/2538537477
    But I liked your optimization operator more.

    Cheers

    Giuseppe

  5. Sandy says:
    July 9, 2009 at 00:14

    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:
    July 9, 2009 at 01:37

    domas you rock!
    rock on!