=?iso-2022-jp?b?W3BncG9vbC1nZW5lcmFsLWpwOiA0NjBdICAbJEItNhsoQhsk?= =?iso-2022-jp?b?QiRHJE4bKEIoQkRCGyRCJSIlLyU7JTlALUc9JEsbKEIbJEIkRCQkJEYb?= =?iso-2022-jp?b?KEI=?=

2008年 6月 19日 (木) 09:48:00 JST

$BEP[k$G$9!#(B
$B!!$*@$OC$K$J$C$F$*$j$^$9!#(B

$B!!(BJDBC$B$NFbItE*$JH/9T$N5sF0$K$D$$$F!";d!">\$7$/$J$/!"(B
$B!!?=$7Lu$"$j$^$;$s!"$o$+$j$^$;$s!J$o$+$j$^$;$s$G$7$?!K!#(B

$B!!(BpostgreSQL$B$N%m%0$K$D$$$F!"@_Dj$rJQ99$7<hF@$7$F$_$^$7$?!#(B
$B!!8!>Z$K;H$C$F$$$?%P%C%A$K$F!"0l2s$N(BSQL$BH/9T$r<B9T$7$?:]$N%m%0$,(B
$B!!0J2<$K$J$j$^$9!#(B

--- DB1$B9f5!(B(java$B<B9T(B) -----$B!!(B
LOG:  execute <unnamed>: SELECT abalance  FROM accounts where aid = $1
DETAIL:  parameters: $1 = '53518'
LOG:  statement:  RESET ALL
LOG:  statement:  SET SESSION AUTHORIZATION DEFAULT

--- DB2$B9f5!(B(java$B<B9T(B) -----$B!!(B
LOG:  statement:  RESET ALL
LOG:  statement:  SET SESSION AUTHORIZATION DEFAULT

$B!!$A$J$_$K(Bphp$B$G$N<B9T$O0J2<$G$9!#(B
--- DB1$B9f5!(B(php$B<B9T(B) -----$B!!(B
LOG:  statement: select abalance from accounts where aid = 54329;
LOG:  statement:  RESET ALL
LOG:  statement:  SET SESSION AUTHORIZATION DEFAULT

--- DB2$B9f5!(B(php$B<B9T(B) -----$B!!(B
LOG:  statement:  RESET ALL
LOG:  statement:  SET SESSION AUTHORIZATION DEFAULT

$B!!>e5-$N%m%0$+$i$O!"(Bjava$B$G$N<B9T$b(Bphp$BF1MM%m!<%I%P%i%s%9$5$l$F$$$k$h$&$K(B
$B!!9M$($F$*$j$^$9!#(B

$B!!B>!"$3$A$i$G<hF@$7$?%m%0$+$i$N5?LdE@$G$9$,!"(Bpostgresql.conf$B$N(Blog_min_messages$B$N(B
$B!!%G%P%C%0%l%Y%k$r>e$2$?:]$K!"(Bjava$BB&$G$O0J2<$N%m%0$,<h$l$^$7$?!#(B

$B!!2<5-%m%0$N(B1$B9TL\!V(BDEBUG:  parse <unnamed......$B!W$+$i(B5$B9TL\$K$D$$$F$ON>J}$N(BDB$B$K$F(B
$B!!<B9T$N:]!"Kh2s=PNO$5$l$F$*$j!"(Bphp$B$N<B9T$N:]$O=PNO$,$J$$$b$N$G$9!#(B
$B!!?dB,$G?=$7Lu$J$$$N$G$9$,!J$^$@3NG'$G$-$F$*$i$:!"$^$?3NG'$N;EJ}$b8!F$$G$-$F$$$J$$$N$G$9$,!#!#!#!K(B 
$B!!$3$N(BSQL$B$N(Bparse$B=hM}$,Fs$D$N(BDB$B$G<B9T$5$l!"$=$NJ,(BDB2$BBf$N>l9g$O(B1$BBf$N>l9g$K(B
$B!!Hf$YM>7W$K=hM};~4V$,$+$+$C$F$$$k$N$G$O$J$$$+!)(B
$B!!$H9M$($F$$$k$N$G$9$,!"2DG=@-$OGv$$$G$7$g$&$+!#!#!#(B

DEBUG:  parse <unnamed>: SELECT abalance  FROM accounts where aid = $1
DEBUG:  StartTransactionCommand
DEBUG:  StartTransaction
DEBUG:  name: unnamed; blockState:       DEFAULT; state: INPROGR, xid/subid/cid: 7713422/1/0, nestlvl: 1, children: <>
DEBUG:  bind <unnamed> to <unnamed>
LOG:  execute <unnamed>: SELECT abalance  FROM accounts where aid = $1
DETAIL:  parameters: $1 = '35041'
DEBUG:  CommitTransactionCommand
DEBUG:  CommitTransaction
DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR, xid/subid/cid: 7713422/1/2, nestlvl: 1, children: <>
DEBUG:  StartTransactionCommand
DEBUG:  StartTransaction
DEBUG:  name: unnamed; blockState:       DEFAULT; state: INPROGR, xid/subid/cid: 7713423/1/0, nestlvl: 1, children: <>
LOG:  statement:  RESET ALL
DEBUG:  ProcessUtility
DEBUG:  CommitTransactionCommand
DEBUG:  CommitTransaction
DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR, xid/subid/cid: 7713423/1/0, nestlvl: 1, children: <>
DEBUG:  StartTransactionCommand
DEBUG:  StartTransaction
DEBUG:  name: unnamed; blockState:       DEFAULT; state: INPROGR, xid/subid/cid: 7713424/1/0, nestlvl: 1, children: <>
LOG:  statement:  SET SESSION AUTHORIZATION DEFAULT
DEBUG:  ProcessUtility
DEBUG:  CommitTransactionCommand
DEBUG:  CommitTransaction
DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR, xid/subid/cid: 7713424/1/0, nestlvl: 1, children: <>

$B!!0J>e!"$h$m$7$/$*4j$$CW$7$^$9!#(B

"Wed, 18 Jun 2008 19:32:11 +0900 (JST)"
"Yoshiyuki Asaba <y-asaba ＠ sraoss.co.jp>"$B$5$s$O=q$-$^$7$?!'(B
> $B ＠ u1)$G$9!#(B
> 
> From: TONAGI Masao <tonagi ＠ kke.co.jp>
> Subject: [pgpool-general-jp: 455] $B-6$G$N(B(BDB$B%"%/%;%9 ＠ -G=$K$D$$$F(B
> Date: Mon, 16 Jun 2008 16:23:12 +0900
> 
> > $B8=:_!"(Btomcat$B>e$K:\$;$?(Bjava$B$N(Bweb$B%"%W%j$K$D$$$F!"(Bpgpool$B-6$r(B
> > $B;H$C$F!"(BpostgreSQL$B$K@\B3$9$k%7%9%F%`$N8!>Z$r9T$C$F$*$j$^$9!#(B
> > $B$=$NCf$N8!>Z7k2L$K$D$$$F5?LdE@$"$j!"Ej9F$5$;$FD:$-$^$7$?!#(B
> > 
> > $B!c5?LdE@!d(B
> > $B8!>Z$NCf$G!"(BpostgreSQL$B$r$N$;$?(BDB$B%5!<%P$r(B2$BBf$K$9$k$H!"(BDB$B%5!<%P(B
> > 1$BBf$N;~$KHf$Y ＠ -G=$,Ls(B1/2$B$K$J$k8!>Z7k2L$H$J$C$F$7$^$&!#(B
> 
> JDBC $B%I%i%$%P$N5sF0$r$h$/3P$($F$$$J$$$N$G$b$7$4B8CN$G$"$l$P65$($F$/$@(B
> $B$5$$!#(BsetAutoCommit() $B$r<B9T$7$J$+$C$?>l9g!"FbItE*$K(B BEGIN $B$,H/9T$5$l(B
> $B$k$N$G$7$g$&$+!)(B
> 
> $B$b$7$=$&$@$H$9$k$H!"%H%i%s%6%/%7%g%s%V%m%C%/Fb$KF~$C$F$7$^$&$?$a!"%m!<(B
> $B%I%P%i%s%9$,8z$+$J$/$J$j$^$9!#$?$@!"$=$l$G$b(B 1/2 $B$K$J$k$3$H$O9M$($K$/(B
> $B$$$N$G!"(B2 $BBf$N%5!<%P$G(B postgresql.conf $B$N(B log_statement $B$rM-8z$K$7$F$$(B
> $B$?$@$-!"$I$N$h$&$J%/%(%j$,H/9T$5$l$F$$$k$+$43NG'$/$@$5$$!#(B
> 
> $B$h$m$7$/$*4j$$$7$^$9!#(B
> --
> Yoshiyuki Asaba
> y-asaba ＠ sraoss.co.jp
> 
> 
> 
> > 
> > $B8!>ZMQ$K8!:w$N$_$N(Bjava$B%"%W%j$r:n ＠ .$7$FF0:n$5$;$F$_$^$7$?$,!"(B
> > $B>e5-(BDB$B%5!<%P(B2$BBf$N>l9g$K(B1$BBf$KHf$Y ＠ -G=$,Nt2=$9$k;v>]H/@8CW$7$^$7$?!#(B
> > $B!J(BDB$B%5!<%P(B2$BBf$G$"$l$P!"FC$K8!:w$N$_$N=hM}$G$"$l$P!"=hM}@-G=$,(B
> > $B8~>e$9$k$b$N$H;W$C$F$*$j$^$9!K(B
> > 
> > $B ＠ _Dj8m$j$r5?$C$F$$$^$9$,!"$I$&$7$F$b2r7h$G$-$J$$$G$*$j$^$9!#(B
> > $B;v>]$N3NG'J}K!$d!"2r7h:vEy!"%"%I%P%$%9Ey$4$6$$$^$;$s$G$7$g$&$+!#(B
> > 
> > $B8!>Z$KMQ$$$F$$$k(BMW$B9=@.$d$3$A$i$G$N8!>Z$N35MW$J$I!"(B
> > $B0J2<$NDL$j$H$J$j$^$9!#(B
> > +++++
> > $B!c(BMW$B9=@.!d(B
> > 1)apache(2.2)+tomcat(5.5)
> > 2)pgpool$B-6(B(1.3)
> > 3)postgreSQL(8.2)
> > $B"((BWeb$B%5!<%P!"(BDB$B%5!<%P$r(B2$BBf$E$DMQ0U!"(Bapache,tomcat,pgpool$B$r(B
> > $B!!(BWeb$B%5!<%P$G!"(BpostgreSQL$B$r(BDB$B%5!<%P$GF0:n$5$;$F$$$^$9!#(B
> > 
> > $B!c(Bjava$B4XO"!d(B
> > 1)java(jdk1.5)
> > 2)postgresql-8.2-505.jdbc3
> > 
> > $B!c(Bpgpool$B-6 ＠ _Dj!d(B
> > $B"(K\%a!<%k$K(Bpgpool.conf$B$rE:IUCW$7$^$9!#(B
> > 
> > $B!cHw9M!d(B
> > $B$3$A$i$G8!>Z$7$?35MW$K$D$$$F!"0J2<$K5-$7$^$9!#(B
> > $B8!>Z(B1)$B8!:w$N$_$N(Bjava$B%5!<%V%l%C%H$r:n ＠ .$7!"@-G=B,Dj$r<B;\(B
> > $B!!"*7k2L!((BDB$B%5!<%P(B2$BBf$r;HMQ$7$?:]!"@-G=$,(BDB1$BBf$KHf$YH>J,$KMn$A$k!#(B
> > 
> > $B8!>Z(B2)$B8!>Z(B1$B$H$[$\F1$8=hM}$r$9$k(Bphp$B%"%W%j$r:n ＠ .$7!"(Bapache$B>e$G(B
> > $B!!F0:n3NG'$r<B;\$9$k!#(B
> > $B!!"*7k2L!((BDB$B%5!<%P(B2$BBf$N;~$NJ}$,!"(BDB$B%5!<%P(B1$BBf$KHf$Y!"Ls(B1.1$BG\$N(B
> > $B!!!!@-G=8~>e$,$_$i$l$k!#(B
> > $B!!"(8!>Z$KMxMQ$7$?(Bphp$B%U%!%$%k$rE:IUCW$7$^$9(B(dbtest4.php)$B!#(B
> > 
> > $B8!>Z(B3)$B8!>Z(B1$B$HF1$8$h$&$J=hM}$r$9$k(Bjava$B%"%W%j$rMQ0U$7F0:n3NG'$r<B;\$9$k!#(B
> > $B!!"*7k2L!(8!>Z(B1$B$HF1MM$K!"(BDB$B%5!<%P(B2$BBf$r;HMQ$7$?:]!"@-G=$,(BDB1$BBf$K(B
> > $B!!!!Hf$YH>J,$KMn$A$k!#(B
> > $B!!"(8!>Z$KMxMQ$7$?(Bjava$B%U%!%$%k!J$*$h$S(Bjava$B$r%-%C%/$9$k%7%'%k(B)$B$r(B
> > $B!!!!E:IUCW$7$^$9(B(DatabaseTest8.java$B!"(Bdbtest8.sh$B!K!#(B
> > 
> > $B8!>Z(B2,3$B$G$O!"(BpostgreSQL$B$K$"$k(Bpgbench$B$K$F:n ＠ .$5$l$k(BDB$B!J%F!<%V%k!K$K(B
> > $B%"%/%;%9$7$FF0:n3NG'$r$7$F$*$j$^$9!#(B
> > +++++
> > 
> > $BD9J8$H$J$j?=$7Lu$"$j$^$;$s!#0J>e!"$h$m$7$/$*4j$$CW$7$^$9!#(B
> > 
> > ----------
> > TONAGI Masao(tonagi ＠ kke.co.jp)
> 
> 
> _______________________________________________
> pgpool-general-jp mailing list
> pgpool-general-jp ＠ sraoss.jp
> http://www.sraoss.jp/mailman/listinfo/pgpool-general-jp
> 
> 
>