Mroongaã®ãƒ©ãƒƒãƒ‘ーモードã§InnoDBを使ã†è½ã¨ã—ç©´Mroonga(ストレージモード)ã¯ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³éžå¯¾å¿œã ã‹ã‚‰ã€ãƒ©ãƒƒãƒ‘ーモードã§InnoDBã«ã—ã¦ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³â€¦ã¨ã‹è€ƒãˆã¦ã„ã‚‹ã¨ãƒãƒžã‚‹(ã‹ã‚‚ã—ã‚Œãªã„)è½ã¨ã—穴。 Mroongaã®ãƒ©ãƒƒãƒ‘ーモードã¯ã€Œãƒ‡ãƒ¼ã‚¿ã¯ä»»æ„ã®ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã«ã€ã€Œè»¢ç½®ç´¢å¼•ã¯Groonga上ã«ã€ä½œã‚‹ãƒ¢ãƒ¼ãƒ‰ã§ã‚ã£ã¦ã€é£½ãã¾ã§Groonga上ã§ã¯ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã¯åˆ©ãã¾ã›ã‚“。ã¤ã¾ã‚Šã€ã“ã†ã„ã†ã“ã¨ãŒèµ·ã“る。 mysql56> CREATE TABLE t1 (num int, val varchar(32), primary key(num), fulltext key(val)) Engine= Mroonga COMMENT= 'engine "innodb"'; Query OK, 0 rows affected (0.09 sec) mysql56> INSERT INTO t1 VALUES (1, 'yoku
Mroongaã®ãƒãƒƒã‚¯ãŒçªã刺ã•ã‚‹ã¨ã©ã†ãªã‚‹ã‹
groongaã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ダンプ・リストアã™ã‚‹æ–¹æ³• - Qiita
Bug #1841: mroongaラッパーモードã«ãŠã‘る行数カウント高速化ã¨order by limit 高速化ã«ã¤ã„㦠- Mroonga - Groonga issues!
http://createfield.com/Mroonga%25E3%2581%25AB%25E3%2582%2588%25E3%2582%258AMySQL%25E3%2581%25A7%25E8%25A4%2587%25E6%2595%25B0%25E3%2582%25A4%25E3%2583%25B3%25E3%2583%2587%25E3%2583%2583%25E3%2582%25AF%25E3%2582%25B9%25E3%2582%2592%25E6%259C%2589%25E5%258A
MySQL-5.6.4ã‹ã‚‰ã®æ–°æ©Ÿèƒ½ã€ŒInnoDB FullText Searchã€ã‚’用ã„ãŸå…¨æ–‡æ¤œç´¢ã‚¨ãƒ³ã‚¸ãƒ³ã®ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯LTã‚’ã—ã¾ã—ãŸã€‚#mysqlcasual - Y-Ken Studio
{{#tags}}- {{label}}
{{/tags}}