Results 1 to 4 of 4

Thread: Turn on MySQL query cache to speed up query performance

  1. #1
    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.

  2. #2
    Join Date
    May 2008
    Posts
    2,297

    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.

  3. #3
    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.

  4. #4
    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

Similar Threads

  1. Query cache denied problem
    By Alibamu in forum Software Development
    Replies: 6
    Last Post: 19-06-2010, 12:35 AM
  2. MySQL query in a query
    By Rail racer in forum Software Development
    Replies: 3
    Last Post: 21-07-2009, 07:06 PM
  3. MySQL Query Cache
    By Ryder in forum Software Development
    Replies: 3
    Last Post: 16-04-2009, 03:05 PM
  4. MySQL IF ELSE in Query
    By Ryder in forum Software Development
    Replies: 3
    Last Post: 27-03-2009, 05:24 PM
  5. MySQL UPDATE Query
    By ANDERS in forum Software Development
    Replies: 2
    Last Post: 10-02-2009, 11:57 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,719,246,637.63226 seconds with 17 queries