MySQL query_cache_size advice
Hi experts,
I'm running a site that is serving up about 8000 pageviews per day and that is expected to increase to about 20000 or so. I want to optimize the server so that it remains fast and can handle plenty of traffic, so for now I'm focussing on MySQL tuning.
I'm using the mysqltuner.pl script and it is suggesting that I up my query_cache_size higher than 128MB at which it is currently set. I'm wondering is there a theoretical maximum setting before this has a negative impact? The server has 1.5GB of RAM.
Memory usage last 48 hours
Mysql selects 48 hours
Mysql updates last 48 hours
I'm running a site that is serving up about 8000 pageviews per day and that is expected to increase to about 20000 or so. I want to optimize the server so that it remains fast and can handle plenty of traffic, so for now I'm focussing on MySQL tuning.
I'm using the mysqltuner.pl script and it is suggesting that I up my query_cache_size higher than 128MB at which it is currently set. I'm wondering is there a theoretical maximum setting before this has a negative impact? The server has 1.5GB of RAM.
Memory usage last 48 hours
Mysql selects 48 hours
Mysql updates last 48 hours
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
I wouldn't set the limit too low, if you have lots of "big" result sets, they won't be cached.
Maybe some of these sites can help you out:
http://www.sitebuddy.com/m
http://www.digimantra.com/
http://www.mysqlperformanc
http://dev.mysql.com/tech-
Maybe some of these sites can help you out:
http://www.sitebuddy.com/m
http://www.digimantra.com/
http://www.mysqlperformanc
http://dev.mysql.com/tech-
ASKER
Would you advise having a lower query_cache_limit or just bump up the query_cache_size?