coreseek在windows下的配置、运行与实时更新(sphinx)

素颜马尾好姑娘i 2022-05-27 06:44 198阅读 0赞

官方文档有很多疏漏，故此多方尝试，将正确的贴出来：

1、bin/csft\_mysql.conf：

> \#源定义  
> source mysql  
> \{  
> type = mysql
> 
> sql\_host = localhost  
> sql\_user = root  
> sql\_pass = merry05  
> sql\_db = test  
> sql\_port = 3306  
> sql\_query\_pre = SET NAMES utf8  
> sql\_query = SELECT id, group\_id, UNIX\_TIMESTAMP(date\_added) AS date\_added, title,content FROM documents  
> \#sql\_query第一列id需为整数  
> \#title、content作为字符串/文本字段，被全文索引  
> sql\_attr\_uint = group\_id \#从SQL读取到的值必须为整数  
> sql\_attr\_timestamp = date\_added \#从SQL读取到的值必须为整数，作为时间属性
> 
> sql\_query\_info = SELECT \* FROM documents WHERE id=$id \#命令行查询时，从数据库读取原始数据信息  
> sql\_query\_post\_index = REPLACE INTO counter (uid,maxid) VALUES (1,$maxid)  
> \}
> 
> \#index定义  
> index mysql  
> \{  
> source = mysql \#对应的source名称  
> path = var/data/mysql  
> docinfo = extern  
> mlock = 0  
> morphology = none  
> min\_word\_len = 1  
> html\_strip = 0  
> charset\_dictpath = etc/ \#Windows环境下设置，/符号结尾  
> charset\_type = zh\_cn.utf-8  
> \#charset\_table=……  
> ngram\_len=0  
> \}
> 
> source delta:mysql  
> \{  
> sql\_query\_pre = SET NAMES utf8  
> sql\_query = SELECT id, group\_id, UNIX\_TIMESTAMP(date\_added) AS date\_added, title,content FROM documents WHERE id>(SELECT maxid FROM counter WHERE uid=1)  
> \}  
> \#增量索引  
> index delta:mysql  
> \{  
> source = delta \#对应的source名称  
> path = var/data/mysql\_delta \#这里的path要与mysql不一样，不然会运行时错误，进程强制退出  
> \}
> 
> \#全局index定义  
> indexer  
> \{  
> mem\_limit = 128M  
> \}
> 
> \#searchd服务定义  
> searchd  
> \{  
> listen = 9312  
> read\_timeout = 5  
> max\_children = 30  
> max\_matches = 1000  
> seamless\_rotate = 0  
> preopen\_indexes = 0  
> unlink\_old = 1  
> pid\_file = var/log/searchd\_mysql.pid  
> log = var/log/searchd\_mysql.log  
> query\_log = var/log/query\_mysql.log  
> \}

注解：mysql为主索引，delta为增量索引

2、进行索引

> bin/indexer -–config etccsft\_mysql.conf mysql

3、启动searchd进程

> bin/searchd --config etccsft\_mysql.conf –-pidfile

注解：–pidfile这个选项一定要添加，强制生成pid，不然在合并索引时会报pid文件无法打开错误（这项非常重要）

4、生成增量索引

> bin/indexer –-config etccsft\_mysql.conf delta -–rotate

5、主索引和增量索引合并

> bin/indexer –-config etccsft\_mysql.conf -–merge mysql delta -–rotate

在searchd进程运行时–-rotate选项一定要添加，详见文档

如果要在合并，将某些文档移出索引时，需要：