[B! mroonga] kana321ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

kana321 id:kana321

mroongaã«é–¢ã™ã‚‹kana321ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (4)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

ç¬¬6å›žã€€[å®ŸéŒ²] MySQLå‘ã‘å…¨æ–‡æ¤œç´¢ã‚¨ãƒ³ã‚¸ãƒ³ã€ŒTritonnã€ã‹ã‚‰ã€Œmroongaã€ã¸ã®ç§»è¡Œã‚¬ã‚¤ãƒ‰ï¼ˆ1ï¼‰ | gihyo.jp
mroongaã®N-gramã«ã¤ã„ã¦ã¯ã€bigramã ã‘ã§ãªãã€uni-gramã‚„tri-gramã®ä»–ã€å¤šæ•°ã®æ´¾ç”ŸN-gramã§ã®ãƒˆãƒ¼ã‚¯ãƒŠã‚¤ã‚¶ã«å¯¾å¿œã—ã¦ã„ã¾ã™ã€‚ã•ã‚‰ã«2013å¹´5æœˆæœ«ãƒªãƒªãƒ¼ã‚¹ã®mysql-mroonga-3.04ã«ã¦ã€å¾…æœ›ã®Wãƒ—ãƒ©ã‚°ãƒžã«å¯¾å¿œã—ã¾ã—ãŸã€‚ã“ã‚Œã«ã‚ˆã‚Šã€Tritonnã‹ã‚‰mroongaã¸ç§»è¡Œã™ã‚‹éš›ã®éšœå£ã¯Eãƒ—ãƒ©ã‚°ãƒžã®ã¿ã«ãªã£ãŸã¨è¨€ãˆã¾ã™ã€‚ Tritonnã‹ã‚‰ä¹—ã‚Šæ›ãˆã‚‹ãªã‚‰ã°ã€mroongaã®1æŠžã§ã™ãã€‚ Tritonnã‹ã‚‰mroongaã¸ç§»è¡Œã™ã‚‹7ã¤ã®ãƒ¡ãƒªãƒƒãƒˆ ãã‚Œã§ã¯æ—©é€Ÿã€Tritonnã‹ã‚‰mroongaãƒ˜ç§»è¡Œã™ã‚‹ãƒ¡ãƒªãƒƒãƒˆã‚’è¦‹ã¦ã¿ã¾ã—ã‚‡ã†ã€‚ MySQL 5.6å¯¾å¿œã§ã‚ã‚‹ã“ã¨ ã‚‚ã¯ã‚„ãƒ¬ã‚¬ã‚·ãƒ¼ã¨ãªã£ãŸMySQL 5.0ã¨ã„ã†ç¸›ã‚ŠãŒãªããªã‚‹ã“ã¨ã§ã€MySQL 5.1ä»¥é™ã®å…ˆé€²çš„ãªæ©Ÿèƒ½ã‚’å–ã‚Šå…¥ã‚Œã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ç‰¹ã«MySQL 5.6ã§ã¯ãã®é€²åŒ–ãŒç”šã ã—ãã€æ¬¡ã®ç‚¹ã‚’å§‹ã‚ã¨
kana321 2015/02/13
MySQLå‘ã‘å…¨æ–‡æ¤œç´¢ã‚¨ãƒ³ã‚¸ãƒ³ã€ŒTritonnã€ã‹ã‚‰ã€Œmroongaã€ã¸ã®ç§»è¡Œã‚¬ã‚¤ãƒ‰

performance

MySQL

mysql

è² è·

groonga

å…¨æ–‡æ¤œç´¢

tritonn

db

mroonga

æ¤œç´¢
ãƒªãƒ³ã‚¯
ç¬¬3å›žã€€ã™ã¹ã¦ã®MySQLãƒ¦ãƒ¼ã‚¶ã«é«˜é€Ÿãªå…¨æ–‡æ¤œç´¢æ©Ÿèƒ½ã‚’ï¼ - mroongaã®ç´¹ä»‹ | gihyo.jp
å‰å›žã®åœ°ä¾¡ãƒžãƒƒãƒ—ã§ã®äº‹ä¾‹ç´¹ä»‹ã§ã¯ã€Ruby on Railsã‹ã‚‰groongaã¨mroongaã‚’ä½¿ã£ã¦ä½ç½®æƒ…å ±æ¤œç´¢ã‚’ã—ãŸäº‹ä¾‹ã‚’ç´¹ä»‹ã—ã¾ã—ãŸã€‚Active Recordã‚’æ‹¡å¼µã—ã¦ä½ç½®æƒ…å ±æ¤œç´¢ã‚’ã™ã‚‹ãŸã‚ã®gemã¨ãã®ä½¿ã„æ–¹ã‚‚ç´¹ä»‹ã—ã¦ã„ãŸã®ã§ã€Ruby on Railsãƒ¦ãƒ¼ã‚¶ã«ã¨ã£ã¦å®Ÿç”¨çš„ãªå†…å®¹ã ã£ãŸã®ã§ã¯ãªã„ã§ã—ã‚‡ã†ã‹ã€‚ ä»Šå›žã¯ã€å‰å›žä½¿ã„æ–¹ã‚’ç´¹ä»‹ã—ãŸmroongaã«ã¤ã„ã¦ã€ã•ã‚‰ã«ç´¹ä»‹ã—ã¾ã™ã€‚å‰å›žã¯mroongaã®ä½¿ã„æ–¹ãŒã§ã¦ãã¾ã—ãŸãŒã€ä»Šå›žã¯ä½¿ã„æ–¹ã®ç´¹ä»‹ã¯ã—ã¾ã›ã‚“ã€‚ãã®ä»£ã‚ã‚Šã€mroongaè‡ªèº«ã®ã“ã¨ã«ã¤ã„ã¦ç´¹ä»‹ã—ã¾ã™ã€‚mroongaã®æ´å²ã€å¤§äº‹ã«ã—ã¦ã„ã‚‹ã“ã¨ã€ã•ã‚‰ã«ã©ã®ã‚ˆã†ãªã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã«ãªã£ã¦ã„ã‚‹ã‹ã«ã¤ã„ã¦èª¬æ˜Žã—ã¾ã™ã€‚ è‡ªåˆ†ã®ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã§åˆ©ç”¨ã™ã‚‹ãƒ—ãƒãƒ€ã‚¯ãƒˆã‚’æ¤œè¨Žã™ã‚‹ã¨ãã«ã€ãƒ—ãƒãƒ€ã‚¯ãƒˆãŒã©ã®ã‚ˆã†ãªæ–¹å‘ã§ä½œã‚‰ã‚Œã¦ã„ã‚‹ã‹ã‚’è€ƒæ…®ã—ã¦ã„ã¾ã™ã‹ï¼Ÿ è‡ªåˆ†ã®ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãŒå¤§äº‹ã«ã—ãŸã„ã“ã¨ã‚’ãã®
kana321 2014/10/11
ã™ã¹ã¦ã®MySQLãƒ¦ãƒ¼ã‚¶ã«é«˜é€Ÿãªå…¨æ–‡æ¤œç´¢æ©Ÿèƒ½ã‚’ï¼ - mroongaã®ç´¹ä»‹

fulltextsearch

MySQL

mysql

B!

å…¨æ–‡æ¤œç´¢

mroonga

groonga

search

rails

ã‚ã¨ã§èªã‚€
ãƒªãƒ³ã‚¯
ã€åˆå…¬é–‹ã€‘ãƒãƒ£ãƒƒãƒˆãƒ¯ãƒ¼ã‚¯æ¤œç´¢æ©Ÿèƒ½ã‚’æ”¯ãˆã‚‹æŠ€è¡“
9. Mroonga 3.xã®èª²é¡Œ â€¢ IOãƒãƒƒã‚¯ã®ç™ºç”Ÿ â€¢ 1åƒä¸‡ä»¶ç¨‹åº¦ã®ãƒ¡ãƒƒã‚»ãƒ¼ ã‚¸è¦æ¨¡ã§ã¯ã€é †èª¿ã«ç¨¼åƒ â€¢ æ•°åƒä¸‡ä»¶ãƒ¬ãƒ™ãƒ«ã«ãªã‚‹ã¨ã€ mysqldãŒãƒ€ã‚¦ãƒ³ã™ã‚‹ã‚ˆ ã†ã«ã€‚ã€‚ã€‚ Thread pointer: 0x2f19350 Attempting backtrace.You can use the following information to ï¬nd out where mysqld died. If you see no messages after this, something went terribly wrong... stack_bottom = 7f5da7047e68 thread_stack 0x40000 /usr/local/mysql/bin/mysqld(my_print_stacktrace+0x29)[0x750bd9] /usr/local/mys
kana321 2014/07/19
ãƒãƒ£ãƒƒãƒˆãƒ¯ãƒ¼ã‚¯æ¤œç´¢æ©Ÿèƒ½ã‚’æ”¯ãˆã‚‹æŠ€è¡“

Presentation

chatwork

cloudsearch

mroonga

æ¤œç´¢

aws

elasticsearch

é–‹ç™º

webã‚µãƒ¼ãƒ“ã‚¹

search
ãƒªãƒ³ã‚¯
Mroongaã‚’ä½¿ã£ã¦å…¨æ–‡æ¤œç´¢Webã‚µãƒ¼ãƒ“ã‚¹ã‚’ä½œã£ãŸã¨ãã«ã¯ã¾ã£ãŸã“ã¨(ç¬¬1å›ž) - CreateField Blog
å‰å›žã®ã‚¨ãƒ³ãƒˆãƒªã«æ›¸ã„ãŸã‚ˆã†ã«ã€ï¼‘å¹´åŠã»ã©ã‚’ã‹ã‘ã¦ã€ç‹¬å¦ã§ç‰¹è¨±ã®å…¨æ–‡æ¤œç´¢ã‚µãƒ¼ãƒ“ã‚¹ã‚’é–‹ç™ºã—ã¾ã—ãŸã€‚ PatentField | ç„¡æ–™ç‰¹è¨±æ¤œç´¢ æœ€åˆã¯ã€MySQLã‚’ä½¿ã£ãŸã“ã¨ã‚‚ãªã„çŠ¶æ…‹ã ã£ãŸã“ã¨ã‚‚ã‚ã‚Šã€ã‹ãªã‚Šç´†ä½™æ›²æŠ˜ã—ã¾ã—ãŸã€‚Groongaé–‹ç™ºãƒãƒ¼ãƒ ã®æ‡‡åˆ‡ãªå¯¾å¿œã‚‚ã‚ã£ã¦ã€å°‚ç”¨ã‚µãƒ¼ãƒ1å°ã§æœ€å¤§ã§1åƒä¸‡ãƒ¬ã‚³ãƒ¼ãƒ‰è¶…ã€400GiBä»¥ä¸Šã®ã‚µã‚¤ã‚ºã®ãƒ†ã‚ã‚¹ãƒˆãƒ‡ãƒ¼ã‚¿ã‚’é«˜é€Ÿã«æ¤œç´¢ã§ãã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã—ãŸã€‚ ä»Šå¾Œã€ä½•å›žã‹ã«ã‚ã‘ã¦ã€Mroonga(Groonga)ã‚’ä½¿ã£ã¦å…¨æ–‡æ¤œç´¢Webã‚µãƒ¼ãƒ“ã‚¹ã‚’ä½œã£ãŸã¨ãã«ã¯ã¾ã£ãŸã“ã¨ã€å¦ã‚“ã ã“ã¨ã‚’å…¨ã¦æ›¸ãå‡ºã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ å…¨æ–‡æ¤œç´¢ã‚¨ãƒ³ã‚¸ãƒ³Mroongaã¨ã¯ï¼Ÿ Mroongaã¯å…¨æ–‡æ¤œç´¢ã‚¨ãƒ³ã‚¸ãƒ³ã§ã‚ã‚‹Groongaã‚’ãƒ™ãƒ¼ã‚¹ã¨ã—ãŸMySQLç”¨ã®ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã§ã™ã€‚Mroongaã¯ã€MySQLãŒä½¿ãˆã‚‹äººã§ã‚ã‚Œã°ã€ç°¡å˜ã«é«˜é€Ÿãªå…¨æ–‡æ¤œç´¢æ©Ÿèƒ½ãŒä½¿ãˆã¾ã™ã€‚MariaDB10.0ç³»ã«ã‚‚ãƒãƒ³ãƒ‰ãƒ«
kana321 2014/04/15
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

groonga

development

mroonga

å…¨æ–‡æ¤œç´¢

search engine

db

mysql

programming

SearchEngine
ãƒªãƒ³ã‚¯
1