nn2480
nishi****@webre*****
2012年 5月 26日 (土) 00:12:24 JST
mroonga$B$NMxMQ$K4X$7$F!"(B $BBgJQ$*$;$o$K$J$C$F$*$j$^$9!#(B $B#57n#2F|$h$j!"(Bmroonga2.0.2$B$rMxMQ$5$;$FD:$$$F(B $B$$$^$9$N$G!"$=$N$4Js9p$H!"(B $B8!:wO3$l$NLdBj$K$+$s$7$F!"$4B8CN$NJ}$,$*$i$l$^$7$?$i!"(B $B$*65$(D:$-$?$/!"Ej9F$5$;$FD:$-$^$7$?!#(B $B59$7$/$*4j$$$7$^$9!#(B $B#1!K(Bmroonga$B$N>u67Js9p(B $B%l%W%j%1!<%7%g%s$N9=@.$O!((B master(innodb)$B!(=q$-9~$_ ＠ lMQ(B -submaster(innodb)$B!((Bhot standby -slave(innodb+mroonga wrapper mode)*2$B!(8!:w ＠ lMQ(B -slave(innodb):$B4IM}MQ%5!<%P!<(B $B$G$9!#(B $B$=$l0J30$N9=@.$O!"(B > centos5,mysql5.5,php5.3,binlog_format=mixed,semi-sync$B$OL$;HMQ!"(B >$B>&IJ$N%j%"%k99?7$OLs#1#0#0#07o(B/$BF|!"Lk4V%P%C%A$G$N99?7$O!"Ls(B20000$B7o(B/$BF|!"(B $B$G$9!#$3$N1?MQ$G!"$[$\(B1$B%17n7P2a$7$^$7$?$,!"(Bmroonga$B$KLdBj$, ＠ 8$8$?$3$H$O$"$j$^$;$s!#(B $BEZ0fMM$N%1!<%9$H$O;HMQ4D6-$,$A$,$$$^$9$,!">e5-9=@.$G$O0BDj$7$F1?MQ$G$-$F$*$j$^$9!#(B $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 $B!!%o%$%k%I%+!<%I!J!v!K$r%-!<%o!<%I$N8e$m$K$D$1$F8!:w$7$?>l9g$K$O!"(B $B%O%$%M$HF~$l$F!"%O%$%M8&5f$b8!:w$G$-$?$N$G$9$,!"(B $B:#EY$O!"5U$K!":#$^$G8!:w$G$-$F$$$?9`L\$,8!:w$G$-$J$$8=>]$r ＠ 8$8$?$?$a!"(B $B$3$N%o%$%k%I%+!<%I!J!v!K$NMxMQ$O$H$j$d$a$F$$$^$9!"!"(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 $B0J>e-!-"$NLdBj$K4X$7$F$4B8CN$G$7$?$i!"$*65$(D:$-$?$/59$7$/$*4j$$$7$^$9!#(B 2012/5/25 $B@>;3(B ----- Original Message ----- From: "$BEZ0f7r;J(B" <bambi****@gmail*****> To: <groon****@lists*****> Sent: Friday, May 25, 2012 3:18 PM Subject: [groonga-dev,00902]$B99?7=hM};~$N(Bbinlog$B8m%G!<%?$N5-F~(B > $B$*@$OC$K$J$C$F$*$j$^$9!#(B > > $B=i$a$^$7$F!"EZ0f$H?=$7$^$9!#(B > $B%5!<%P%5%$%I$N%(%s%8%K%"$r%a%$%s$H$7$F!"(B > $B%_%I%k%&%'%"$NF3F~!"@_DjEy$NHO0O$G%$%s%U%i$K$b7H$o$C$F$*$j$^$9!#(B > > $B:#2s!"A4J88!:w%(%s%8%s$H$7$F(Bmroonga$B$r:NMQ$5$;$FD:$-$^$7$?$,!"(B > $B7GBj$N7o$G%9%l!<%V$N%l%W%j%1!<%7%g%s$, ＠ 5$7$/9T$o$l$J$$;vBV$KAx6x$7$F$*$j$^$9!#(B > > $B%l%W%j%1!<%7%g%s$N>c32$K$D$$$F2<5-$NJs9p$rGR8+$7$F$*$j$^$9$,!"(B > $B%/%i%C%7%e$G$O$J$/(Bbinlog$B$N8m$j$H$=$l$KH<$&8m99?7!"Dd;_$H$$$&E@$G!"(B > $B:90[$r46$8$F$*$j$^$9$?$a!"Js9p$5$;$F$$$?$@$$$F$*$j$^$9!#(B > http://redmine.groonga.org/issues/1361 > > $B"#GD0.$7$F$$$k>I>u(B > $B!&(Bgeneral_log$B$N(BSQL$B$OH/9T$7$?(BSQL$B$NDL$j$G$"$k!#(B > $B!&(Bbin_log$B$NCM$O3JG<$5$l$F$$$kCM$H0[$J$kCM$r;2>H$7$FH/9T$5$l$F$$$k(B > $B!&(Brelay_log$B$G$OM?$($i$l$?(Bbin_log$B$N8m$C$?CM$r$=$N$^$^;2>H$7$F$$$k(B > $B!&%^%9%?!<B&$G$O ＠ 5$7$/=hM}$5$l$F$*$j!"%9%l!<%VB&$G$O(Bbin_log$B$K5-$5$l$?DL$j$N8m$C$?CM$,H?1G$5$l$k(B > $B!&(Bmroonga$B$N%(%s%8%s$r:NMQ$7$F$$$kA4#3%F!<%V%k$NA499?7=hM}$K$F:F8=$r3NG'$7$F$*$j$^$9(B > > $B"#BP:v$NJ}?K(B > $BEv:B$O%^%9%?!<B&$r(Binnodb$B%(%s%8%s$H$7!"(B > $B%9%l!<%VB&$N$_(Bmroonga$B$H$9$k$3$H$GBP1~$r8!F$$7$F$*$j$^$9!#(B > > $B>\:Y$r2<5-$KNs5s$$$?$7$^$9!#(B > > $B"#(B $B%5%s%W%k(BSQL > UPDATE trn_post SET comment_count = comment_count + 1 ,update_timestamp > = '2012-05-24 18:21:48' WHERE id = '13' > > $B"#(B $B%F!<%V%kDj5A(B > ======================================================= > CREATE TABLE trn_post > ( > id int unsigned NOT NULL AUTO_INCREMENT, > fk_user_id int unsigned NOT NULL, > body text, > has_image tinyint unsigned, > has_link tinyint unsigned NOT NULL, > black_flag tinyint unsigned DEFAULT 0 NOT NULL, > draft_flag tinyint unsigned DEFAULT 0 NOT NULL, > comment_count int unsigned DEFAULT 0 NOT NULL, > push_count int unsigned DEFAULT 0 NOT NULL, > status_code tinyint unsigned DEFAULT 0 NOT NULL, > create_datetime datetime NOT NULL, > update_timestamp timestamp DEFAULT CURRENT_TIMESTAMP NOT NULL ON UPDATE > CURRENT_TIMESTAMP, > PRIMARY KEY (id) > ) ENGINE = mroonga DEFAULT CHARACTER SET utf8; > /* Create FulltextIndexes */ > SET GLOBAL mroonga_default_parser = TokenMecab; > CREATE FULLTEXT INDEX ix_full_trn_post_01 ON trn_post(body); > ======================================================= > > $B"#(Bmy.cnf > ======================================================= > [mysqld] > datadir=/var/lib/mysql > socket=/var/lib/mysql/mysql.sock > user=mysql > # Disabling symbolic-links is recommended to prevent assorted security risks > symbolic-links=0 > innodb-flush-log-at-trx-commit=2 > innodb_buffer_pool_size=256M > innodb_log_buffer_size=16M > innodb_log_file_size=64M > sort_buffer_size=2M > read_rnd_buffer_size=1M > join_buffer_size=256K > innodb_additional_mem_pool_size=20M > innodb_thread_concurrency=16 > innodb_commit_concurrency=8 > innodb_flush_method=O_DIRECT > innodb_file_per_table > innodb_data_file_path=ibdata1:1G > character-set-server=utf8 > collation-server=utf8_general_ci > skip-character-set-client-handshake > expire_logs_days=1 > > max_connection=1024 > thread_concurrency=300 > log_bin=mysql-bin > #binlog_format=STATEMENT > #binlog_format=MIXED > binlog_format=ROW > server_id=1 > slow_query_log=ON > slow_query_log_file=mysql-slow.log > max_binlog_size=512M > log_output=FILE > long_query_time=0.5 > default-storage-engine=innodb > lower_case_table_names=1 > thread_cache_size = 300 > > port=33306 > server-id=1 > log-bin=/var/lib/mysql/blog/blog > > [mysqld_safe] > log-error=/var/log/mysqld.log > pid-file=/var/run/mysql/mysqld.pid > syslog > port=33306 > socket=/var/lib/mysql/mysql.sock > > [client] > port=33306 > socket=/var/lib/mysql/mysql.sock > ======================================================= > > $B8=>]$N$*?4Ev$?$j$K4X$7$^$7$F!"(B > $B%"%I%P%$%9$$$?$@$1$^$9$H9,$$$G$9!#(B > > $B$=$NB>!"I,MW$J>pJs$,$"$j$^$7$?$i!"(B > $B$4O"Mm$/$@$5$$!#(B > > $B0J>e!"$h$m$7$/$*4j$$$7$^$9!#(B > _______________________________________________ > groonga-dev mailing list > groon****@lists***** > http://lists.sourceforge.jp/mailman/listinfo/groonga-dev >
