wakis****@gmail*****
wakis****@gmail*****
2014年 8月 14日 (木) 11:28:13 JST
宮脇です。
ありがとうございます！
MariadbにMroongaが導入され、正常に動いていることを確認できました。
下記に動作結果を記載します。
MariaDB [test]> SHOW ENGINES;
+--------------------+---------+----------------------------------------------------------------------------+--------------+------+------------+
| Engine | Support | Comment | Transactions | XA | Savepoints |
+--------------------+---------+----------------------------------------------------------------------------+--------------+------+------------+
| InnoDB | DEFAULT | Percona-XtraDB, Supports transactions, row-level locking, and foreign keys | YES | YES | YES |
| CSV | YES | CSV storage engine | NO | NO | NO |
| MRG_MYISAM | YES | Collection of identical MyISAM tables | NO | NO | NO |
| BLACKHOLE | YES | /dev/null storage engine (anything you write to it disappears) | NO | NO | NO |
| MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO |
| PERFORMANCE_SCHEMA | YES | Performance Schema | NO | NO | NO |
| mroonga | YES | CJK-ready fulltext search, column store | NO | NO | NO |
| MyISAM | YES | MyISAM storage engine | NO | NO | NO |
| FEDERATED | YES | FederatedX pluggable storage engine | YES | NO | YES |
| Aria | YES | Crash-safe tables with MyISAM heritage | NO | NO | NO |
| ARCHIVE | YES | Archive storage engine | NO | NO | NO |
+--------------------+---------+----------------------------------------------------------------------------+--------------+------+------------+
11 rows in set (0.00 sec)
MariaDB [test]> CREATE TABLE diaries (
-> id INT PRIMARY KEY AUTO_INCREMENT,
-> content VARCHAR(255),
-> FULLTEXT INDEX (content)
-> ) ENGINE = Mroonga DEFAULT CHARSET utf8;
Query OK, 0 rows affected (0.05 sec)
MariaDB [test]>
MariaDB [test]> INSERT INTO diaries (content) VALUES ("It'll be fine tomorrow.");
Query OK, 1 row affected (0.00 sec)
MariaDB [test]> INSERT INTO diaries (content) VALUES ("It'll rain tomorrow");
Query OK, 1 row affected (0.00 sec)
MariaDB [test]> SELECT * FROM diaries WHERE MATCH(content) AGAINST("fine");
+----+-------------------------+
| id | content |
+----+-------------------------+
| 1 | It'll be fine tomorrow. |
+----+-------------------------+
1 row in set (0.00 sec)
MariaDB [test]> SELECT *, MATCH (content) AGAINST ("fine") FROM diaries WHERE MATCH (content) AGAINST ("fine") ORDER BY MATCH (content) AGAINST ("fine") DESC;
+----+-------------------------+----------------------------------+
| id | content | MATCH (content) AGAINST ("fine") |
+----+-------------------------+----------------------------------+
| 1 | It'll be fine tomorrow. | 1048577 |
+----+-------------------------+----------------------------------+
1 row in set (0.00 sec)
MariaDB [test]> INSERT INTO diaries (content) VALUES ("It's fine today. It'll be fine tomorrow as well.");
Query OK, 1 row affected (0.00 sec)
MariaDB [test]> INSERT INTO diaries (content) VALUES ("It's fine today. But it'll rain tomorrow.");
Query OK, 1 row affected (0.00 sec)
MariaDB [test]> SELECT *, MATCH (content) AGAINST ("fine") FROM diaries WHERE MATCH (content) AGAINST ("fine") ORDER BY MATCH (content) AGAINST ("fine") DESC;
+----+--------------------------------------------------+----------------------------------+
| id | content | MATCH (content) AGAINST ("fine") |
+----+--------------------------------------------------+----------------------------------+
| 3 | It's fine today. It'll be fine tomorrow as well. | 233018 |
| 1 | It'll be fine tomorrow. | 116509 |
| 4 | It's fine today. But it'll rain tomorrow. | 116509 |
+----+--------------------------------------------------+----------------------------------+
3 rows in set (0.00 sec)
差出人: Kouhei Sutou
送信日時: 2014年8月14日 木曜日 11:03
宛先: 全文検索エンジンGroonga開発メーリングリスト
須藤です。
In <1f084****@gmail*****>
"[groonga-dev,02623] Re: Re: お願い: CentOS 7用Mroongaパッケージのテスト" on Thu, 14 Aug 2014 00:37:17 +0000,
<wakis****@gmail*****> wrote:
> yumから無事にインストールできました！
おぉ！一歩進みましたね！
> が、、、mariadbにはha_mroonga.soのプラグインインストールに失敗しています。
> MariaDB [test]> INSTALL PLUGIN mroonga SONAME 'ha_mroonga.so';
> ERROR 1126 (HY000): Can't open shared library '/usr/lib64/mysql/plugin/ha_mroonga.so' (errno: 2, undefined symbol: thd_kill_statement_service)
あぁ、libmysqlservices.a問題ですね。
これに対応したRPM（4.04-4）をアップロードしました！
これでいけるはず…！
--
須藤 功平 <kou****@clear*****>
株式会社クリアコード <http://www.clear-code.com/>
Groongaベースの全文検索システムを総合サポート:
http://groonga.org/ja/support/
パッチ採用 - プログラミングが楽しい人向けの採用プロセス:
http://www.clear-code.com/recruitment/
コードリーダー育成支援 - 自然とリーダブルコードを書くチームへ:
http://www.clear-code.com/services/code-reader/
_______________________________________________
groonga-dev mailing list
groon****@lists*****
http://lists.sourceforge.jp/mailman/listinfo/groonga-dev