MySQL's Query Cache - The Diigo Meta page

• 23 Jul 08
  

  Matteo Campofiorito

  mysql database

• 07 Apr 08
  

  alfred westerveld

  cache mysql performance toread

• 06 Mar 08
  

  jarihakkarainen

  mysql cache performance optimization database query development sql

• 22 Nov 07
  

  Kevin Walter

  Web Development Hosting

• 13 May 07
  

  Karoly Sz

  mysql cache SQL

• 10 May 07
  

  Ben Godfrey

  Configuring and using MySQL's query cache.

  mysql caching performance configuration

• 03 Apr 07
  

  pfrenssen

  mysql

• 02 Apr 07
  

  quakebot

  mysql query cache

• 25 Mar 07
  

  del__t

  imported furl

• 24 Mar 07
  

  test_dellll

  cache imported:delicious mysql performance

• 

  del_ttt

  cache imported:delicious mysql performance

• 01 Mar 07
  

  Richard Klein

  mysql cache performance optimization

• 08 Sep 06
  

  Bill Milot

  General

• 10 Aug 06
  

  mom

  cache mysql performance

• 27 Jul 06
  

  Douglas Muth

  mysql performance sysadmin qcache delicious

• 10 May 06
  

  jordim

  How works mysql cache?

  MySQL Caching

• 15 Mar 06
  

  Joel Liu

  cache mysql performance

  • Note that these are results from MySQL 4.0.x - you'll see more in versions 4.1.x and beyond. The query_cache_type will be set to ON or OFF as appropriate. However, there is one more to set, and that is the query_cache_size. If set to 0 (the default), the cache will be disabled. This variable determines the memory, in bytes, used for the query cache. For our purposes, we will set it to 20 MB:
  • To make sure MySQL uses the query cache, there are a few variables you need to set in the configuration file (usually my.cnf or my.ini). First, is the query_cache_type. There are three possible settings: 0 (for off, do not use), 1 (for on, cache queries) and 2 (on demand, discussed more below). To ensure it is always on, place:
• 23 Dec 05
  

  murrayw

  How to use MySQL 4 cache. Simple as two lines in your my.cnf.

  MySQL Cache Optimization

Would you like to comment?

Join Diigo for a free account, or sign in if you are already a member.