• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

Question mysql query cache

Franco

Regular Pleskian
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
 
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. ;)
 
Back
Top