<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">
<meta http-equiv="CONTENT-TYPE" content="text/html;
charset=ISO-8859-1">
<p style="margin-bottom: 0cm" lang="en-GB">Hi Tatsuo,</p>
<p style="margin-bottom: 0cm" lang="en-GB">Our configuration are:
<br>
master_slave_mode = on<br>
master_slave_sub_mode =
'stream'<br>
load_balance_mode = off</p>
<p style="margin-bottom: 0cm" lang="en-GB">If memory_cache_enabled
=
on, in PostgreSQL slave backend log display internal PgPool
queries,
for example:</p>
<p style="margin-bottom: 0cm" lang="en-GB"><br>
</p>
<p style="margin-bottom: 0cm" lang="en-GB">2013-05-28 09:56:05
CEST
[3498]:[422] LOG: statement: BEGIN<br>
2013-05-28 09:56:05 CEST
[3371]:[659] LOG: execute pgpool3347/pgpool3347: SELECT count(*)
FROM pg_class AS c, pg_namespace AS n WHERE c.relname =
'est_config'
AND c.relnamespace = n.oid AND n.nspname ~ '^pg_temp_'<br>
2013-05-28 09:56:05 CEST
[3484]:[385] LOG: statement: BEGIN<br>
2013-05-28 09:56:05 CEST
[3371]:[660] LOG: execute pgpool3347/pgpool3347: SELECT count(*)
FROM pg_catalog.pg_class AS c WHERE c.oid =
pgpool_regclass('est_config') AND c.relpersistence = 'u'<br>
2013-05-28 09:56:05 CEST
[3473]:[541] LOG: execute pgpool3329/pgpool3329: SELECT count(*)
FROM pg_class AS c, pg_namespace AS n WHERE c.relname =
'est_context'
AND c.relnamespace = n.oid AND n.nspname ~ '^pg_temp_'<br>
2013-05-28 09:56:05 CEST
[3374]:[465] LOG: execute pgpool3240/pgpool3240: SELECT count(*)
FROM pg_class AS c, pg_namespace AS n WHERE c.relname =
'est_capabilities' AND c.relnamespace = n.oid AND n.nspname ~
'^pg_temp_'<br>
2013-05-28 09:56:05 CEST
[3407]:[430] LOG: execute pgpool3337/pgpool3337: SELECT count(*)
FROM pg_catalog.pg_class AS c WHERE c.oid =
pgpool_regclass('est_context') AND c.relpersistence = 'u'<br>
2013-05-28 09:56:05 CEST
[3479]:[444] LOG: statement: COMMIT</p>
<p style="margin-bottom: 0cm" lang="en-GB">In otherwise, when
memory_cache_enabled = off, same postgresql log only show DCL
queries, for example:</p>
<p style="margin-bottom: 0cm" lang="en-GB">2013-05-28 09:15:18
CEST
[30353]:[514] LOG: statement: SET statement_timeout TO DEFAULT<br>
2013-05-28 09:15:18 CEST
[30320]:[441] LOG: statement: COMMIT<br>
2013-05-28 09:15:18 CEST
[30363]:[475] LOG: statement: BEGIN<br>
2013-05-28 09:15:18 CEST
[30353]:[515] LOG: statement: COMMIT<br>
2013-05-28 09:15:18 CEST
[30330]:[530] LOG: statement: BEGIN<br>
2013-05-28 09:15:18 CEST
[30363]:[476] LOG: statement: SET statement_timeout TO DEFAULT<br>
2013-05-28 09:15:18 CEST
[30330]:[531] LOG: statement: SET statement_timeout TO 120000<br>
2013-05-28 09:15:18 CEST
[30363]:[477] LOG: statement: COMMIT<br>
2013-05-28 09:15:18 CEST
[30330]:[532] LOG: statement: COMMIT<br>
2013-05-28 09:15:18 CEST
[30324]:[472] LOG: statement: BEGIN<br>
2013-05-28 09:15:18 CEST
[30324]:[473] LOG: statement: SET statement_timeout TO 120000<br>
2013-05-28 09:15:18 CEST
[30352]:[606] LOG: statement: BEGIN<br>
2013-05-28 09:15:18 CEST
[30352]:[607] LOG: statement: SET statement_timeout TO 120000<br>
2013-05-28 09:15:18 CEST
[30352]:[608] LOG: statement: COMMIT<br>
2013-05-28 09:15:18 CEST
[30319]:[520] LOG: statement: BEGIN<br>
2013-05-28 09:15:18 CEST
[30352]:[609] LOG: statement: BEGIN</p>
<p style="margin-bottom: 0cm" lang="en">Why this change of
behavior
by changing this parameter<span lang="en-GB">?</span></p>
<br>
<title></title>
<meta name="GENERATOR" content="LibreOffice 4.0.2.2 (Linux)">
<style type="text/css">
<!--
@page { margin: 2cm }
P { margin-bottom: 0.21cm }
-->
</style><br>
Regards,<br>
Toni<br>
<br>
Al 28/05/13 01:15, En/na Tatsuo Ishii ha escrit:<br>
</div>
<blockquote
cite="mid:20130528.081531.626534788666461630.t-ishii@sraoss.co.jp"
type="cite">
<blockquote type="cite">
<pre wrap="">Hi,
We have experimented an abnormal situation when set on memory
cache. We have configured PgPool 3.2.3 version, in master-slave mode
and disabled load balancing.
I understand reading the documentation, if we have set on master-slave
mode, although load balancing parameter was disabled, it has no
effect, and Pgpool applied load query balancing. This is true?
Agree, the configuration set master-slave mode with stream
replication, and load balancing set off. The abnormal situation
appears when I have set on or off memory cache. If we have disabled
memory cache, Pgpool no applied load query balancing. In otherwise,
when memory cache is enabled, PgPool applied load query
balancing. This is normal situation, or there may be an bug?
</pre>
</blockquote>
<pre wrap="">
Are you saying that "load_balance_mode = off" does not take effect if
"memory_cache_enabled = on"? Did not reproduce here. Can you please
show us more details.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: <a class="moz-txt-link-freetext" href="http://www.sraoss.co.jp/index_en.php">http://www.sraoss.co.jp/index_en.php</a>
Japanese: <a class="moz-txt-link-freetext" href="http://www.sraoss.co.jp">http://www.sraoss.co.jp</a>
</pre>
</blockquote>
<br>
<br>
<pre class="moz-signature" cols="72">--
Toni Mas
Universitat de les Illes Balears
Ctra. Valldemossa Km 7,5
971 17 27 21</pre>
</body>
</html>