 Hi, query_cache_type = OFF - FAIL (must be strcasecmp on) Anyone know how I can change this setting in mysql to show under site optimization as "ok"? I am on a VPS hosting, I have loved in via terminal but I can teem to find query_cache_type in my.cnf. And if I do the change how significant is it? |
OK, you can add it to the my.cnf. The way MySQL works is that if an entry is not in the my.cnf file then it uses the default; so adding the entry will make MySQL use the setting in my.cnf file. That goes for other things as well such as thread sizes. Geeks, making the world a better place |
Go to the documentation on optimising for Dolphin and follow the recommendations there; adding what is not set correctly, etc. Dolphin will perform much better. Geeks, making the world a better place |
I would just leave it off. https://dolphin-techs.com - Skype: Dolphin Techs |
I would just leave it off. More info please. Why do you say opposite of what Boonex is saying? Geeks, making the world a better place |
As of version 5.6 mysql has this off by default because of mixed use databases such as Innodb and Myisam there for they fight over each other..
Just google it i guess for more info. PS i am sure boonex wrote that before version 5.6.. https://dolphin-techs.com - Skype: Dolphin Techs |
As of version 5.6 mysql has this off by default because of mixed use databases such as Innodb and Myisam there for they fight over each other..
Just google it i guess for more info. PS i am sure boonex wrote that before version 5.6.. Thanks Jay. Hopefully Boonex will visit this. Geeks, making the world a better place |
Rules → http://www.boonex.com/terms |
