Comments - MyISAM plus INNODB enable query cache?

7 years, 9 months ago Chris Matthews

mysqltuner tells me to enable query_cache, but then it also says I should increase thread_cache_size which is rubbish as in MariaDB 10.* thread pool is enabled so thread_cache_size is ignored. Anyway thanks for answering.

 
7 years, 9 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.

 
7 years, 9 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.