Query Cache Hit Rate

[cryan]

Hello,

Is it better to set the query cache rate to 0 if you only have 5GB of memory allocated to the MySQL DBs?

Thanks.

[Luuk]

This might be true:
- If your database has 'a lot of changes'
- If you do 'a lot of different queries'

But if you do 'a query a lof of times', and there are not that much changes in your database, than i could be better to specify some room for query cache (depending on how much you have free of those 5Gb)

There's also some relation to the size of your database. If this is 'huge' (a couple of times those 5Gb), and there are a lot of 'random' queries, than a cache wont give much improvement...