[groonga-dev,00915] Re: 更新処理時のbinlog誤データの記入

Back to archive index

nn2480 nishi****@webre*****
2012年 6月 1日 (金) 22:57:37 JST


$B?\F#MM(B

$B$$$D$bBgJQ$*$;$o$K$J$C$F$*$j$^$9!#(B
mroonga$B$rMxMQ$5$;$FD:$$$F$$$^$7$F!"46<U$b$&$7$"$2$^$9!#(B
$BBgJQ$"$j$,$?$$$G$9!#(B
$B%-!<%o%I8!:w$K4X$7$F$b%"%I%P%$%9D:$-$"$j$,$H$&$4$6$$$^$7$?!#(B


$B$3$N8!:w%-!<%o!<%IO3$l$N7o$G$9$,!"%F%9%H4D6-2<!J(Bnode8$B!K$G(B
$B2<5-$N;n9T:x8m$r9T$C$F$$$^$9$,!"$^$@!"2r7h$O$7$F$*$j$^$;$s!"(B


$B#1!K;n9T:x8mFbMF(B
$B!!(Bmecab-ipadic$B$rJQ99$7$F!"(Bmecab-naist-jdic$B$G$N%F%9%H$*$h$S!"(B
$B!!(Bmecab-unidic$B$G$N%F%9%H$r$*$3$J$$$^$7$?$,!"(B
$B!!J}K!$,0-$$$N$+!"$&$^$/8!:w$G$-$^$;$s$G$7$?!"(B
$B!!$=$3$G!"%f!<%6!<<-=q$K!"(B
$B!!%O%$%M$N%-!<%o!<%I$rDI2C$7$F$_$^$7$?!((B

[root @ node8 ~]# echo $B%O%$%M(B | mecab
$B%O%$%M(B  $BL>;l(B,$B8GM-L>;l(B,$B?ML>(B,$BL>(B,*,*,$B%O%$%M(B,$B$O$$$M(B,$B$O$$$M(B
$B>e5-%f!<%6!<<-=q$rDI2C$7$F%H%i%$$7$^$7$?$,!"(B
$B$&$^$/$$$-$^$;$s$G$7$?!"!"(B

$B8=:_!"@_Dj$O!"2<5-$K$J$C$F$$$^$9!#(B

[root @ node8 ~]# mecab -D
filename:       /usr/local/lib/mecab/dic/naist-jdic/sys.dic
version:        102
charset:        utf8
type:   0
size:   485863
left size:      1396
right size:     1396

filename:       /home/nn2480/user.dic
version:        102
charset:        utf8
type:   1
size:   4
left size:      1396
right size:     1396

$B%O%$%M$N<-=q$O2<5-$N$h$&$K$J$C$F$$$^$9!#(B

[root @ node8 ~]# echo $B%O%$%M(B | mecab -a
$B%O%$(B    $BL>;l(B,$B0lHL(B,*,*,*,*,*
$B%O%$(B    $BL>;l(B,$B8GM-L>;l(B,$BCO0h(B,$B0lHL(B,*,*,*
$B%O%$(B    $BL>;l(B,$B8GM-L>;l(B,$BAH?%(B,*,*,*,*
$B%O%$(B    $BL>;l(B,$B8GM-L>;l(B,$B?ML>(B,$B0lHL(B,*,*,*
$B%O%$(B    $BL>;l(B,$B8GM-L>;l(B,$B0lHL(B,*,*,*,*
$B%O%$(B    $B46F0;l(B,*,*,*,*,*,*
$B%O(B      $BL>;l(B,$B0lHL(B,*,*,*,*,*
$B%O(B      $BL>;l(B,$B8GM-L>;l(B,$BCO0h(B,$B0lHL(B,*,*,*
$B%O(B      $BL>;l(B,$B8GM-L>;l(B,$BAH?%(B,*,*,*,*
$B%O(B      $BL>;l(B,$B8GM-L>;l(B,$B?ML>(B,$B0lHL(B,*,*,*
$B%O(B      $BL>;l(B,$B8GM-L>;l(B,$B0lHL(B,*,*,*,*
$B%O(B      $B46F0;l(B,*,*,*,*,*,*
$B%O%$%M(B  $BL>;l(B,$B0lHL(B,*,*,*,*,*
$B%O%$%M(B  $BL>;l(B,$B8GM-L>;l(B,$BCO0h(B,$B0lHL(B,*,*,*
$B%O%$%M(B  $BL>;l(B,$B8GM-L>;l(B,$BAH?%(B,*,*,*,*
$B%O%$%M(B  $BL>;l(B,$B8GM-L>;l(B,$B?ML>(B,$B0lHL(B,*,*,*
$B%O%$%M(B  $BL>;l(B,$B8GM-L>;l(B,$B0lHL(B,*,*,*,*
$B%O%$%M(B  $B46F0;l(B,*,*,*,*,*,*
$B%O%$%M(B  $BL>;l(B,$B8GM-L>;l(B,$B?ML>(B,$BL>(B,*,*,$B%O%$%M(B,$B$O$$$M(B,$B$O$$$M!!!!"+!!$3$3$,%f!<%6<-=q$GDI2C$7$?ItJ,(B
$B%O%$(B    $BL>;l(B,$B0lHL(B,*,*,*,*,$B%O%$(B,$B%O%$(B,$B%O%$(B,,
$B%$(B      $BL>;l(B,$B0lHL(B,*,*,*,*,*
$B%$(B      $BL>;l(B,$B8GM-L>;l(B,$BCO0h(B,$B0lHL(B,*,*,*
$B%$(B      $BL>;l(B,$B8GM-L>;l(B,$BAH?%(B,*,*,*,*
$B%$(B      $BL>;l(B,$B8GM-L>;l(B,$B?ML>(B,$B0lHL(B,*,*,*
$B%$(B      $BL>;l(B,$B8GM-L>;l(B,$B0lHL(B,*,*,*,*
$B%$(B      $B46F0;l(B,*,*,*,*,*,*
$B%$%M(B    $BL>;l(B,$B0lHL(B,*,*,*,*,*
$B%$%M(B    $BL>;l(B,$B8GM-L>;l(B,$BCO0h(B,$B0lHL(B,*,*,*
$B%$%M(B    $BL>;l(B,$B8GM-L>;l(B,$BAH?%(B,*,*,*,*
$B%$%M(B    $BL>;l(B,$B8GM-L>;l(B,$B?ML>(B,$B0lHL(B,*,*,*
$B%$%M(B    $BL>;l(B,$B8GM-L>;l(B,$B0lHL(B,*,*,*,*
$B%$%M(B    $B46F0;l(B,*,*,*,*,*,*
$B%$%M(B    $BL>;l(B,$B0lHL(B,*,*,*,*,$B%$%M(B,$B%$%M(B,$B%$%M(B,,
$B%M(B      $BL>;l(B,$B0lHL(B,*,*,*,*,*
$B%M(B      $BL>;l(B,$B8GM-L>;l(B,$BCO0h(B,$B0lHL(B,*,*,*
$B%M(B      $BL>;l(B,$B8GM-L>;l(B,$BAH?%(B,*,*,*,*
$B%M(B      $BL>;l(B,$B8GM-L>;l(B,$B?ML>(B,$B0lHL(B,*,*,*
$B%M(B      $BL>;l(B,$B8GM-L>;l(B,$B0lHL(B,*,*,*,*
$B%M(B      $B46F0;l(B,*,*,*,*,*,*
$B%M(B      $B=u;l(B,$B=*=u;l(B,*,*,*,*,$B%M(B,$B%M(B,$B%M(B,,
EOS


$BG0$N$?$a$K!"(Bmysql$B$r%j%9%?!<%H$7$?$j!"(Bapache$B$r%j%9%?!<%H$5$;$?$j!"(B
fulltext$B$N(Bindex$B$r(Bdrop$B$7!":FEY(Bcreate$B$7$?$j$r$7$F$_$^$7$?$,!"(B
$B$^$@@.8y$7$F$O$$$^$;$s!"!"(B

$B$J$K$+$r @ _Dj%_%9$7$F$$$k$H$*$b$&$N$G$9$,!"!"!"(B
$B$J$K$+%R%s%H$G$b$$$?$@$1$^$7$?$i!"BgJQ$"$j$,$?$$$G$9!#(B

$B59$7$/$*4j$$$$$?$7$^$9!#(B

$B#2#0#1#2G/#67n#1F|!!@>;3GR(B







----- Original Message ----- 
From: "Kouhei Sutou" <kou****@clear*****>
To: <groon****@lists*****>
Sent: Wednesday, May 30, 2012 4:45 PM
Subject: [groonga-dev,00913] Re: $B99?7=hM};~$N(Bbinlog$B8m%G!<%?$N5-F~(B


> $B?\F#$G$9!#(B
> 
> In <71E00B89608D42FCB0D0C97050965480 @ winxp130>
>  "[groonga-dev,00903] Re: $B99?7=hM};~$N(Bbinlog$B8m%G!<%?$N5-F~(B" on Sat, 26 May 2012 00:12:24 +0900,
>  "nn2480" <nishi****@webre*****> wrote:
> 
>> $B#2!K8!:w%-!<%o!<%I$G$N8!:wO3$l$NLdBj(B
>> $B8!:w$O!"(Bmecab ipadic$B$rMxMQ$7!!(Bin boolean mode$B$G8!:w$7$F$$$^$9$,!"(B
>> $B$?$H$($P!"%O%$%M$H8!:w8l$rF~$l$?>l9g!"(B
>> $B%O%$%M;m=8!"%O%$%M!&2sA[O?$J$I$O!"8!:w$5$l$k$N$G$9$,!"$J$<$+(B
>> $B%O%$%M8&5f$O8!:w$5$l$^$;$s!"!"(B
>> 
>> $B$3$N860x$,$h$/$o$+$i$J$$$N$G$9$,!"(B
>> $B-!(Bin boolean mode$B$G!"%O%$%M$HF~$l$?>l9g!"%O%$%M8&5f$b8!:w$5$;$k(B
>> $B$K$O!"$I$&$7$?$i$h$$$N$G$7$g$&$+!)(B
> 
> $B1sF#$5$s$+$i$N%3%a%s%H$K$"$k$h$&$K!"(BMeCab$B$N<-=q$r6/2=$9$k$+(B
> N-gram$B$J%H!<%/%J%$%6!<$r;HMQ$7$^$9!#(B
> 
> groonga$B$G$O%H!<%/%J%$%6!<$N0c$&J#?t$N%$%s%G%C%/%9$rF1;~$K;H$C(B
> $B$FA4J88!:w$r$9$k$3$H$,$G$-$^$9!#$=$N5!G=$r;H$&$H(BTokenMecab$B$G(B
> $B%^%C%A$7$?>l9g$O%R%C%H%9%3%"$rBg$-$a$K$7$F!"(BTokenBigram$B$K%^%C(B
> $B%A$7$?>l9g$O%R%C%H%9%3%"$r>.$5$a$K$9$k!"$J$I$7$F!"(BMeCab$B$G%^%C(B
> $B%A$7$J$$>l9g$G$b$G$-$k$@$18!:wO3$l$r>/$J$/=PMh$^$9!#(B
> 
> $B$?$@!"(BMySQL$B$K$OA4J88!:w;~$K;HMQ$9$k%$%s%G%C%/%9$r;XDj$9$k9=(B
> $BJ8$,$J$$$N$G!"",$,$G$-$J$$$N$G$9!#!#!#(B
> 
> $B%*!<%P!<%X%C%I$,$"$C$F$b5vMFHO0OFb$G$"$l$P!"(B
> 
>  CREATE TABLE ... (
>    body TEXT,
>    body_bigram TEXT,
>    FULLTEXT INDEX body_index_mecab (body) COMMENT 'parser "TokenMecab"',
>    FULLTEXT INDEX body_index_bigram (body) COMMENT 'parser "TokenBigram"'
>  ) ENGINE=mroonga ...;
> 
> $B$H$$$&$h$&$K$7$F!"(Bbody$B$K$b(Bbody_bigram$B$K$bF1$8%G!<%?$rF~$l$l$P!"(B
> 
>  SELECT MATCH (body) AGAINST ("$B%O%$%M(B" IN BOOLEAN MODE) * 100 + 
>           MATCH (body_bigram) AGAINST ("$B%O%$%M(B" IN BOOLEAN MODE) AS score
>         table
>         WHERE MATCH (body) AGAINST ("$B%O%$%M(B" IN BOOLEAN MODE) AND
>           MATCH (body_bigram) AGAINST ("$B%O%$%M(B" IN BOOLEAN MODE);
> 
> $B$H$$$&$h$&$J$3$H$b$G$-$k$+$J$!$H;W$$$^$7$?$,!"$@$$$V6/0z$G$9$M!#!#!#(B
> 
>> $B-"(Bmecab$B$N<-=q$r!"8=:_$N(Bipadic$B$+$i!"(Bnaist-jdic,unidic$B$J$I$KJQ99$9$l$P!"(B
>> $B$3$NLdBj$O2r7h$9$k$N$G$7$g$&$+!)(B
> 
> MeCab$B$,$I$N$h$&$K%H!<%/%J%$%:$9$k$+$O0J2<$N%3%^%s%I$G3NG'$G(B
> $B$-$^$9!#(B
> 
>  % echo "$B3N$+$a$?$$J8=q(B" | mecab
> 
> $BNc$($P!":#2s$NNc$G$G$F$-$?$b$N$O0J2<$N$h$&$K$J$j$^$9!#(B
> $B!J(BNAIST-jdic$B$r;H$C$?>l9g!K(B
> 
>  % echo $B%O%$%M(B | mecab
>  $B%O%$(B $BL>;l(B,$B0lHL(B,*,*,*,*,$B%O%$(B,$B%O%$(B,$B%O%$(B,,
>  $B%M(B $B=u;l(B,$B=*=u;l(B,*,*,*,*,$B%M(B,$B%M(B,$B%M(B,,
>  EOS
>  % echo $B%O%$%M;m=8(B | mecab
>  $B%O%$%M(B $BL>;l(B,$B0lHL(B,*,*,*,*,*
>  $B;m=8(B $BL>;l(B,$B0lHL(B,*,*,*,*,$B;m=8(B,$B%7%7%e%&(B,$B%7%7%e!<(B,,
>  EOS
>  % echo $B%O%$%M!&2sA[O?(B | mecab
>  $B%O%$(B $BL>;l(B,$B0lHL(B,*,*,*,*,$B%O%$(B,$B%O%$(B,$B%O%$(B,,
>  $B%M(B $B=u;l(B,$B=*=u;l(B,*,*,*,*,$B%M(B,$B%M(B,$B%M(B,,
>  $B!&(B $B5-9f(B,$B0lHL(B,*,*,*,*,$B!&(B,$B!&(B,$B!&(B,,
>  $B2sA[(B $BL>;l(B,$B%5JQ@\B3(B,*,*,*,*,$B2sA[(B,$B%+%$%=%&(B,$B%+%$%=!<(B,,
>  $BO?(B $BL>;l(B,$B@\Hx(B,$B0lHL(B,*,*,*,$BO?(B,$B%m%/(B,$B%m%/(B,,
>  EOS
>  % echo $B%O%$%M8&5f(B | mecab
>  $B%O%$%M(B $BL>;l(B,$B0lHL(B,*,*,*,*,*
>  $B8&5f(B $BL>;l(B,$B%5JQ@\B3(B,*,*,*,*,$B8&5f(B,$B%1%s%-%e%&(B,$B%1%s%-%e!<(B,,
>  EOS
> 
> $B$^$:!"8!:w%/%(%j!<$N!V%O%$%M!W$,!V%O%$!W$H!V%M!W$GJ,$+$l$F$$(B
> $B$k$N$G!"8!:wBP>]$NJ}$b!V%O%$!W$H!V%M!W$KJ,$+$l$F$$$kI,MW$,$"(B
> $B$j$^$9!#$h$C$F!"$3$N>l9g$G$O!V%O%$%M!&2sA[O?!W$7$+%^%C%A$7$^(B
> $B$;$s!#(B
> 
> $B<-=q$rJQ$($?$j!"<+J,$GJT=8$7$?>l9g$O$3$N$h$&$K5sF0$rM=A[$9$k(B
> $B$3$H$,$G$-$^$9!#!J(Bgroonga$B%l%Y%k$GA0=hM}$r$7$F$+$i(BMeCab$B$KJ8=q(B
> $B$rEO$9%1!<%9$b$"$k$N$G!">l9g$K$h$C$F$O(Bmecab$B%3%^%s%I$N7k2L$H(B
> $B0lCW$7$J$$$3$H$b$"$j$^$9!#!K(B
> 
> -- 
> $B?\F#(B $B8yJ?(B <kou****@clear*****>
> $B3t<02q<R%/%j%"%3!<%I(B <http://www.clear-code.com/> (03-6231-7270)
> 
> groonga$B%5%]!<%H(B:
>  http://groonga.org/ja/support/
> $B%W%m%0%i%_%s%0$,9%$-$J%=%U%H%&%'%"3+H/<T$rJg=8Cf(B:
>  http://www.clear-code.com/recruitment/
> 
>


--------------------------------------------------------------------------------


> _______________________________________________
> groonga-dev mailing list
> groon****@lists*****
> http://lists.sourceforge.jp/mailman/listinfo/groonga-dev
>




groonga-dev メーリングリストの案内
Back to archive index