pgpool2.git / summary / log / commit / refs

commit    4953f2596a2b2806b372859d69cebc6ed1aa9ef6
Author:   Nozomi Anzai <anzai@sraoss.co.jp>
Date:     Fri Jan 27 09:15:08 2012 +0000

    Add desctiption about whire_memqcache_table list and black_memqcache_table_list.


 doc/pgpool-en.html | 13 ++++++++++---
 doc/pgpool-ja.html | 14 +++++++++++---
 2 files changed, 21 insertions(+), 6 deletions(-)

diff --git a/doc/pgpool-en.html b/doc/pgpool-en.html
index 933f620e2..d6587f1c3 100644
--- a/doc/pgpool-en.html
+++ b/doc/pgpool-en.html
@@ -2226,7 +2226,7 @@ See <a href="#md5">Authentication / Access Controls</a> for more details.
   the install directory.
 </p>
 
-<h2>Setting Query cache method</h2>
+<h2 id="memqcache">Setting Query cache method</h2>
 <p>The Query cache can be used in all modes in pgpool-II.
 The query cache allow to reuse the SELECT result to boost the performance.
 Activating it in  
@@ -2275,7 +2275,6 @@ Memory cache behavior can be specified by cache_param directive:<br>
 Cache store method. Either "shmem"(shared memory) or "memcached". Default is shmem. 
 </p>
 <pre>
-
 memqcache_method = 'shmem'
 </pre>
 
@@ -2328,11 +2327,19 @@ Cache block size in bytes<br>
 Only meaning full when memqcache_method=shmem. Memory cache is devided into fixed size of block.<br>
 If the block size is small, memory usage is efficient, but processing might be slow. On the other hand,<br>
 if the block size is large, memory usage is not efficient but processing might be fast. Default is 8192. <br>
-
 </p>
 <pre>
 memqcache_cache_block_size= 8192
+</pre>
 
+<p>
+In white_memqcache_table_list specify a comma separated list of table names to be cached, and<br>
+in black_memqcache_table_list specify the ones not to be cached.
+</p>
+<p>You can use regular expression into the list to match table names.</p>
+<pre>
+white_memqcache_table_list = ''
+black_memqcache_table_list = ''
 </pre>
 
 <h3>memcached Installation</h3>
diff --git a/doc/pgpool-ja.html b/doc/pgpool-ja.html
index d658918d2..c5ac9117b 100644
--- a/doc/pgpool-ja.html
+++ b/doc/pgpool-ja.html
@@ -2138,7 +2138,7 @@ md5$B$K4X$7$F$O!"(Bpool_passwd$B$H$$$&%Q%9%o!<%I%U%!%$%k$rJ;MQ$9$k$3$H$K$h$C$
    $B$@$5$$!#(B
 </p>
 
-<h2>$B%/%(%j%-%c%C%7%e$N@_DjJ}K!(B</h2>
+<h2 id="memqcache">$B%/%(%j%-%c%C%7%e$N@_DjJ}K!(B</h2>
 
 <p>
 	pgpool-II$B$G$O!"$9$Y$F$N%b!<%I$G%/%(%j%-%c%C%7%e$rMxMQ$9$k$3$H$,$G$-$^$9!#(B
@@ -2199,7 +2199,6 @@ Memcached$B$r;HMQ$9$k>l9g$O!"(BMemcached$B$N%]!<%HHV9f$r0J2<$N$h$&$K@_Dj$7$^$
 </p>
 <pre>
 memqcache_memcached_port = 11211
-
 </pre>
 
 <p>
@@ -2239,10 +2238,19 @@ memqcache_maxcache = 512
 $B%-%c%C%7%e%V%m%C%/%5%$%:$O0J2<$N$h$&$K@_Dj$7$^$9!#C10L$O%P%$%H$G!"%G%U%)%k%H$O(B8192$B$G$9!#(B
 </p>
 <pre>
-
 memqcache_cache_block_size= 8192
 </pre>
 
+<p>
+white_memqcache_table_list $B$K$O(B SELECT $B7k2L$r%-%c%C%7%e$7$?$$%F!<%V%kL>$r!"(B
+black_memqcache_table_list $B$K$O%-%c%C%7%e$7$?$/$J$$%F!<%V%kL>$r;XDj$7$^$9!#(B
+</p>
+<p>$B$3$3$G$O@55,I=8=$r;H$&$3$H$,$G$-$^$9!#(B</p>
+<pre>
+white_memqcache_table_list = ''
+black_memqcache_table_list = ''
+</pre>
+
 <h3>memcached$B$N%$%s%9%H!<%k(B</h3>
 
 <p>


[parent: 433b50798169]