Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 07-07-2009
Member
 
Join Date: Apr 2009
Posts: 32
Turn on MySQL query cache to speed up query performance

I know there are different way to speed up performance of web based application, but i want some information on query cache of database to speed up web application.
Reply With Quote
  #2  
Old 07-07-2009
Member
 
Join Date: May 2008
Posts: 2,293
Re: Turn on MySQL query cache to speed up query performance

Query cache is great for certain applications, typically simple applications deployed on limited scale or applications dealing with small data sets. query_cache_size – This is the size of the cache in bytes. Setting this value to 0 will effectively disable caching. When using a standard MySQL binary, this value is always YES, even if query caching is disabled.The query cache is also controlled by the setting of the query_cache_type variable.
Reply With Quote
  #3  
Old 07-07-2009
Member
 
Join Date: Jan 2009
Posts: 199
Re: Turn on MySQL query cache to speed up query performance

To speed up query, enable the MySQL query cache, before that you need to set few variables in mysql configuration file (usually is my.cnf or my.ini). It can be seen worse if your query cache size is in GigabytesQuery caching can be enabled by setting the server variables query_cache_type, query_cache_size, and query_cache_limit. If any of these three variables is set to 0, query caching will be disabled.
Reply With Quote
  #4  
Old 07-07-2009
Member
 
Join Date: Dec 2008
Posts: 177
Re: Turn on MySQL query cache to speed up query performance

To enable mysql query cache write the following command in to cache.cnf file :

Code:
query_cache_size = 268435456
query_cache_type=1
query_cache_limit=1048576
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Turn on MySQL query cache to speed up query performance"
Thread Thread Starter Forum Replies Last Post
Query cache denied problem Alibamu Software Development 6 19-06-2010 12:35 AM
MySQL query in a query Rail racer Software Development 3 21-07-2009 07:06 PM
MySQL Query Cache Ryder Software Development 3 16-04-2009 03:05 PM
MySQL IF ELSE in Query Ryder Software Development 3 27-03-2009 05:24 PM
MySQL UPDATE Query ANDERS Software Development 2 10-02-2009 11:57 AM


All times are GMT +5.5. The time now is 05:09 AM.