Comments - MyISAM plus INNODB enable query cache?

4 years, 10 months ago Daniel Black

mysqltuner will give you a result based on hitrate. What isn't accounted for is:

  • this the cost of the hit;
  • the cost of the lookup;
  • the cost of cache invalidation; or
  • if the query cache queries are actually just as quick to calculate without a cache.

If you have lots of threads_running you will have contention on the query cache lock QC is enabled.

You are probably better off measuring query response time overall in a production environment with and without query cache and making a decision based on that.

 
4 years, 10 months ago Chris Matthews

Thanks for your answer.

 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.