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.