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

Back to archive index

Kouhei Sutou kou****@clear*****
2012年 5月 30日 (水) 16:45:07 JST


$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 メーリングリストの案内
Back to archive index