This link has been bookmarked by 40 people . It was first bookmarked on 15 Mar 2006, by Joel Liu.
-
23 Jul 08
-
07 Apr 08
-
06 Mar 08
-
22 Nov 07
-
13 May 07
-
10 May 07
-
03 Apr 07
-
02 Apr 07
-
25 Mar 07
-
24 Mar 07
-
01 Mar 07
-
08 Sep 06
-
10 Aug 06
-
27 Jul 06
-
10 May 06
-
15 Mar 06
-
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
Would you like to comment?
Join Diigo for a free account, or sign in if you are already a member.