Comments - MyISAM plus INNODB enable query cache?
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.
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.
mysqltuner will give you a result based on hitrate. What isn't accounted for is:
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.
Thanks for your answer.