Welcome to WebmasterWorld Guest from 54.166.224.46

Forum Moderators: open

Message Too Old, No Replies

How and where to turn MySQL Query Cache

Looking for flexible caching solution

     
7:47 pm on Oct 3, 2008 (gmt 0)

5+ Year Member



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.

12:27 am on Oct 18, 2008 (gmt 0)

5+ Year Member



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.

 

Featured Threads

Hot Threads This Week

Hot Threads This Month