| How and where to turn MySQL Query Cache
Looking for flexible caching solution |
cosmoyoda
msg:3758345 | 7:47 pm on Oct 3, 2008 (gmt 0) |
Greetings people, 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.
|
cosmoyoda
msg:3768391 | 12:27 am on Oct 18, 2008 (gmt 0) |
Nevermind guys. Unfortunately my web host does not support this. I cannot turn MySQL Query Cache on. Instead, I will have to look for a PHP Caching solution. Personally, I think I should use the Smarty Template Engine.
|
|
|
