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.
nobody but you can answer that question - if you have more reads the writes on the same tables: yes - but why don't you just try it and get "mysqltuner" which will tell you something about hit rates
if you have a table which is permanently changed - no but then RTFM and disable the cache in the relevant queries itself which can not benefit from it
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.