By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,960 Members | 987 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,960 IT Pros & Developers. It's quick & easy.

Query Cache Hit Rate

P: 8

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

Sep 21 '12 #1
Share this Question
Share on Google+
1 Reply

Expert 100+
P: 1,031
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...
Sep 30 '12 #2

Post your reply

Sign in to post your reply or Sign up for a free account.