Question mysql query cache

[Franco]

Hello,

out of curiosity I run a mysqltuner on my VPS (CentoS 7, MariaDB 10.1, php-fpm with nginx) and obtained a few settings to change, but among them this one:

query_cache_size (=0)
query_cache_type (=0)
query_cache_limit (> 1M, or use smaller result sets)

I am only running wordpress websites and I do not face any apparent resource problem. Also, I am not using the full memory yet. Is it a good idea to turn it on, perhaps? What's your advice, please?

Many thanks to all who want to reply.

Regards,

Franco

 

[UFHH01]

Hi Franco,

QUOTE="Franco, post: 834027, member: 174311"]and I do not face any apparent resource problem[/QUOTE]

Is it a good idea to turn it on, perhaps?

Tuning/tweaking configuration files is never a bad idea. Pls. make a backup of your previous configuration files and try to messure results to your previous configuration. Which setting you prefer should be based on YOUR comparisons and your experiences as content, traffic and hardware / software and it's configuration is unique on your server.