homepage Welcome to WebmasterWorld Guest from 54.211.157.103
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member
Visit PubCon.com
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderators: physics

Databases Forum

    
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.

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved