土井健司
bambi****@gmail*****
2012年 5月 28日 (月) 10:25:30 JST
nn2480$BMM(B $BEZ0f$G$9!#(B $B$*@$OC$K$J$C$F$*$j$^$9!#(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$3$A$i!"5.=E$J>pJs$"$j$,$H$&$4$6$$$^$9!#(B $BD:$$$?>\:Y$J9=@.$K$h$k>pJs$b2CL#$7$F!"(B $B?7$7$$9=@.$K$F8!>Z$r?J$a$?$$$H9M$($F$*$j$^$9!#(B $B?JE8$,$4$6$$$^$7$?$i!"(B $B2~$a$F$4O"Mm$$$?$7$^$9!#(B $B0J>e!"$h$m$7$/$*4j$$$7$^$9!#(B 2012$BG/(B5$B7n(B26$BF|(B 0:12 nn2480 <nishi****@webre*****>: > 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(B in 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 > > > > > _______________________________________________ > groonga-dev mailing list > groon****@lists***** > http://lists.sourceforge.jp/mailman/listinfo/groonga-dev > >
