Recently, my website has been overloaded with database queries that tend to slow down my server. For that reason, I am looking for a caching solution. Caching database SQL queries in MySQL seems like an attractive solution, but I have no idea what config file I need to change to turn Query Cache on.
I have to change to the following:
query-cache-type = 1 query-cache-size = 50M
Is that correct, btw? No typos? Good. All I need to know is what file to open up and change to those lines.
If this helps, I am using a Mac using MAMP. Also, I would like to know whether it will be easy to turn this on in my Web Hosting server. Hopefully that is the case. If not I will have to find an alternative to MySQL Query Caching.