Depends on the result sets you want to cache. Check the other variables in the manual, you
can analyze if all the query cache is utilized at a point in time. In general 16M is low
when you have 4GB, you can safely increase it.
From: hrrg-inf@stripped [mailto:hrrg-inf@stripped]
Sent: Mittwoch, 9. März 2005 22:03
To: MySql List
Subject: Query_cache_size Question
Hi, I'm trying to tweak the execution time for querys on my mysql
server which is using InnoDB.
I know that there are a lot of things to check but one of them, perhaps
not the most important, is the query_cache_size.
I have a dual Xeon cpu with 4gb of ram and this is a Linux dedicated
server which runs only Apache and Mysql 4.1.5
I've declared Query_cache_size = 16M in the my.cnf file
and I would say that in the whole we have 60% of select querys and a
40% of update querys.
Is Query_cache_size=16M too conservative considering that I have 4Gb of
If so what would be a more efective value?
As I've said before the engine is InnoDB.
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=1