MyISAM plus INNODB enable query cache?
We have 2GB of MyISAM plus 2GB INNODB data. Running MariaDB 10.* Should we enable or disable query_cache ?
Answer Answered by Harald Reindl in this comment.
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