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


Comments loading...
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.