Hi, I'm trying to tweak the execution time for the querys on my mysql server 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 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? Thanks MAuricio ------------------------------------------------------- SF email is sponsored by - The IT Product Guide Read honest & candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click _____________________________________________________________________ Ltsp-discuss mailing list. To un-subscribe, or change prefs, goto: https://lists.sourceforge.net/lists/listinfo/ltsp-discuss For additional LTSP help, try #ltsp channel on irc.freenode.net