install Frontier::Client «
Main
tritonn mysql+senna
http://qwik.jp/tritonn/
すでにmysqlもsennaも入れていましたが、
MySQL-client-5.0.67-tritonn.1.0.12.i386.rpm
MySQL-devel-5.0.67-tritonn.1.0.12.i386.rpm
MySQL-server-5.0.67-tritonn.1.0.12.i386.rpm
MySQL-shared-5.0.67-tritonn.1.0.12.i386.rpm
mecab-ipadic-2.7.0.20070801-tritonn.1.0.12.i386.rpm
senna-1.1.4-tritonn.1.0.12.i386.rpm
mecab-0.97-tritonn.1.0.12.i386.rpm
rpm -Uvh *
ですべて入れてみる。
特に問題なく
/etc/rc.d/init.d/mysql start
で起動
テストdatabaseで確認
http://qwik.jp/tritonn/userguide.html
# mysql -u root test
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.0.67-modified MySQL Community Server (GPL) (portions (c) Tritonn Project)
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> show tables;
Empty set (0.00 sec)
mysql> CREATE TABLE t1 (c1 TEXT, FULLTEXT INDEX ft USING NGRAM (c1)) ENGINE = MyISAM DEFAULT CHARSET utf8;
Query OK, 0 rows affected (0.02 sec)
mysql> SHOW SENNA STATUS\G
*************************** 1. row ***************************
Table: t1
Key_name: ft
Column_name: c1
Encoding: utf8
Index_type: NGRAM
Sectionalize: OFF
Normalize: ON
Split_alpha: OFF
Split_digit: OFF
Split_symbol: OFF
Initial_n_segments: 512
Senna_keys_size: 0
Senna_keys_file_size: 4268032
Senna_lexicon_size: 0
Senna_lexicon_file_size: 4268032
Senna_inv_seg_size: 167936
Senna_inv_chunk_size: 135168
1 row in set (0.01 sec)
mysql> INSERT INTO t1 VALUES ("すもももももももものうち");
Query OK, 1 row affected (0.01 sec)
mysql> INSERT INTO t1 VALUES ("生麦生米生卵");
Query OK, 1 row affected (0.00 sec)
mysql> INSERT INTO t1 VALUES ("東京特許許可局");
Query OK, 1 row affected (0.00 sec)
mysql> SELECT * FROM t1 WHERE MATCH(c1) AGAINST("特許");
+-----------------------+
| c1 |
+-----------------------+
| 東京特許許可局 |
+-----------------------+
1 row in set (0.00 sec)
mysql>
いちを大丈夫そうです。
2009-05-03 22:41:14 - junichi
[pgpool] php (sql) エラーの話。 «
データベース [phpmyadmin]phpMyAdmin-2.11.2.2 «
MySQL