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>

いちを大丈夫そうです。


[pgpool] php (sql) エラーの話。 « データベース
[phpmyadmin]phpMyAdmin-2.11.2.2 « MySQL