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
ram ?

If so what would be a more efective value?

As I've said before the engine is InnoDB.

Thanks 
Mauricio




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to