[geeklog-devtalk] Optimizing MySQL

[Tony Bibbs]

Dirk Haun wrote:


>We tend to have quite a few requests that are created on the fly

>specifically for the current user, though, so that there's probably not a

>lot to cache.

>  

>

That's more a function of the amount of memory and how big of queries 
you want to cache. I'd encourage you to install MySQL Administrator and 
point it to geeklog.net during a peak period and watch the cache hit 
graph.  While it's not always high, it's definitely helping.

And, btw, I just noticed MySQL Browser...what a long over due tool.

--Tony.