Kouhei Sutou
kou****@clear*****
2012年 6月 4日 (月) 16:56:18 JST
$B?\F#$G$9!#(B
> $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
MeCab$B$N<-=q$rJQ99$7$?>l9g$O%$%s%G%C%/%9$r:F9=C[$9$kI,MW$,$"(B
$B$k$N$G!"!V(Bfulltext$B$N(Bindex$B$r(Bdrop$B$7!":FEY(Bcreate$B$7$?$j!W$OI,?\(B
$B$G$9!*$3$l$O!"%$%s%G%C%/%99=C[;~$K(BMeCab$B$N<-=q$r;2>H$9$k$?$a(B
$B$G$9!#%$%s%G%C%/%99=C[8e$K(BMeCab$B$N<-=q$rJQ99$7$F$b!"%$%s%G%C(B
$B%/%9$K$OH?1G$5$l$^$;$s!#$=$N$?$a!"(BMeCab$B$N<-=q$rJQ99$9$k<j=g(B
$B$O0J2<$N$h$&$K$J$j$^$9!#(B
1. MeCab$B$N<-=q$rJQ99(B
2. MySQL$B$r:F5/F0(B
3. $BA4J88!:wMQ%$%s%G%C%/%9$r:F9=C[(B
$B!J(BALTER TABLE DROP INDEX -> ALTER TABLE ADD FULLTEXT INDEX$B$G$h$$!K(B
4. $B8!:w(B
$B$"$H!"(BMeCab$B$N<-=q$rA*$V$H$-$G$9$,!"0J2<$N$h$&$K8!:w$7$?$$C18l(B
$B$r;vA0$K(Bmecab$B$G=hM}$7$F$_$F!"A4It!V%O%$%M!W$@$1$N$H$-$HF1$8$h(B
$B$&$KJ,3d$5$l$k$+$r3NG'$7$F$/$@$5$$!#(B
% echo $B%O%$%M(B | mecab
% echo $B%O%$%M8&5f(B | mecab
% echo $B%O%$%M;m=8(B | mecab
% echo $B%O%$%M!&2sA[O?(B | mecab
$BNc$($P!"(B
% 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
EOS
$B$H$J$C$F$$$k>l9g$O(B
% 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
$B$O!V%O%$%M!W$G(B1$B%H!<%/%s$N$?$a8!:w$G$-$^$9$,!"(B
% 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
$B$O!V%O%$!W$H!V%M!W$N(B2$B%H!<%/%s$K$J$C$F$$$k$?$a8!:w$G$-$^$;$s!#(B
In <BA67D33B77754F58A5E3680F61A85408 ＠ winxp130>
"[groonga-dev,00915] Re: $B99?7=hM};~$N(Bbinlog$B8m%G!<%?$N5-F~(B" on Fri, 1 Jun 2012 22:57:37 +0900,
"nn2480" <nishi****@webre*****> wrote:
> $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
>>
>