Coreseek 基於 Sphinx + MMSEG 中文分詞,提供 MySQL 協議介面 (Port 9306)。本文完整記錄:RT 索引建立、資料寫入、從 MySQL 表同步建立普通索引的完整配置與操作流程。
SHOW TABLES 顯示的是索引而非真實表INSERT/REPLACE/DELETE,無需重建indexer --rotate 重建index tank_test
{
type = rt
path = /usr/local/sphinx/var/data/rt
charset_dictpath = /usr/local/mmseg3/etc/
charset_type = zh_cn.utf-8
ngram_len = 0
rt_field = name
rt_field = title
rt_field = sub_title
rt_attr_uint = user_id
rt_attr_uint = uid
}
rt_field = 全文檢索欄位;rt_attr_uint = 回傳/過濾屬性欄位
pkill -9 searchd
/usr/local/sphinx/bin/indexer --config /usr/local/sphinx/etc/sphinx.conf --all
/usr/local/sphinx/bin/searchd --config /usr/local/sphinx/etc/sphinx.conf
mysql -h 127.0.0.1 -P 9306
DESC tank_test;
INSERT INTO tank_test VALUES (3,'坦克','tank is 坦克','技術總監',1311895260,33);
SELECT * FROM tank_test WHERE MATCH('坦克');
SHOW META;
CREATE TABLE orders (...);
INSERT INTO orders ...;
source order
{
type = mysql
sql_host = localhost
sql_user = root
sql_pass =
sql_db = test
sql_query_pre = SET NAMES utf8
sql_query = SELECT id, user_id, username, UNIX_TIMESTAMP(create_time) AS create_time, product_name, summary FROM orders
sql_attr_uint = user_id
sql_attr_timestamp = create_time
sql_ranged_throttle = 0
sql_query_info = SELECT * FROM orders WHERE id=$id
}
index myorder
{
source = order
path = /usr/local/sphinx/var/data/myorder
docinfo = extern
mlock = 0
morphology = none
min_word_len = 1
charset_dictpath = /usr/local/mmseg3/etc/
charset_type = zh_cn.utf-8
ngram_len = 0
html_strip = 0
}
pkill -9 searchd
/usr/local/sphinx/bin/indexer --config /usr/local/sphinx/etc/sphinx.conf --all
/usr/local/sphinx/bin/searchd --config /usr/local/sphinx/etc/sphinx.conf
mysql -h 127.0.0.1 -P 9306
SELECT * FROM myorder WHERE MATCH('坦克');
charset_dictpath 必須正確,否則中文分詞失效