结合网上资料,总结一些
1.直接在http://www.sphinxsearch.com/downloads.html 找到最新的windows版本,我这里下载的是根绝网上资料的Win32 release binaries with MySQL support ,下载后解压在D:sphinx目录下;
2.在D:\sphinx下新建一个data目录用来存放索引文件,一个log目录方日志文件,复制D:\sphinx\sphinx.conf.in到D:\sphinx\bin\sphinx.conf(注意修改文件名);
3.修改D:\sphinx\bin\sphinx.conf,我这里列出需要修改的几个:
type = mysql # 数据源,我这里是mysql sql_host = localhost # 数据库服务器 sql_user = root # 数据库用户名 sql_pass = '' # 数据库密码 sql_db = test # 数据库 sql_port = 3306 # 数据库端口
sql_query_pre = SET NAMES utf8 # 去掉此行前面的注释,如果你的数据库是uft8编码的
index test1 { # 放索引的目录 path = D:/sphinx/data/ # 编码 charset_type = utf-8 # 指定utf-8的编码表 charset_table = 0..9, A..Z->a..z, _, a..z, U+410..U+42F->U+430..U+44F, U+430..U+44F # 简单分词,只支持0和1,如果要搜索中文,请指定为1 ngram_len = 1 # 需要分词的字符,如果要搜索中文,去掉前面的注释 ngram_chars = U+3000..U+2FA1F }
这里注释掉
# index test1stemmed : test1 # { # path = @CONFDIR@/data/test1stemmed # morphology = stem_en # } # 如果没有分布式索引,注释掉下面的内容 # index dist1 # { # 'distributed' index type MUST be specified # type = distributed
# local index to be searched # there can be many local indexes configured # local = test1 # local = test1stemmed
# remote agent # multiple remote agents may be specified # syntax is 'hostname:port:index1,[index2[,...]] # agent = localhost:3313:remote1 # agent = localhost:3314:remote2,remote3
# remote agent connection timeout, milliseconds # optional, default is 1000 ms, ie. 1 sec # agent_connect_timeout = 1000
# remote agent query timeout, milliseconds # optional, default is 3000 ms, ie. 3 sec # agent_query_timeout = 3000 # }
# 搜索服务需要修改的部分 searchd { # 日志 log = D:/sphinx/log/searchd.log
# PID file, searchd process ID file name pid_file = D:/sphinx/log/searchd.pid
# windows下启动searchd服务一定要注释掉这个 # seamless_rotate = 1 }
开启searchd服务
d:\sphinx\bin\searchd -c d:\sphinx\bin\sphinx.conf
生成索引文件到d:\shpinx\data目录,进入d:\sphinx\bin执行
indexer.exe -c d:\sphinx\sphinx.conf --all
搜索测试
D:sphinxbin>search.exe test