List:General Discussion« Previous MessageNext Message »
From:Mauricio Pellegrini Date:March 9 2005 10:03pm
Subject:Query_cache_size Question
View as plain text  
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.


Query_cache_size QuestionMauricio Pellegrini9 Mar
  • Re: Query_cache_size QuestionDan Nelson9 Mar
    • Re: Query_cache_size QuestionMauricio Pellegrini9 Mar
      • Re: Query_cache_size QuestionJocelyn Fournier10 Mar
        • Re: Query_cache_size QuestionMauricio Pellegrini10 Mar
          • Re: Query_cache_size QuestionJocelyn Fournier10 Mar
      • Re: Query_cache_size QuestionDan Nelson10 Mar
RE: Query_cache_size QuestionKostas Pyliouras9 Mar