Sphinx配置文件设立

Sphinx配置文件设置

其实是添加中文分词后进行中文搜索coreseek中的sphinx.conf文件配置

source src2{type = mysqlsql_host = 127.0.0.1    // 数据库地址 sql_user = admin                    //用户名 sql_pass = admin        //密码 sql_db = mydb sql_port = 3306 # optional, default is 3306sql_sock = /tmp/mysql.sock    //数据库在linux服务器需开启sql_query_pre = SET NAMES utf8         //字符编码 sql_query_pre = SET SESSION query_cache_type=OFFsql_query = \ SELECT id, gid, addtime AS date_added, realname \ FROM order_adminsql_attr_uint = gidsql_attr_timestamp = date_addedsql_ranged_throttle = 0sql_query_info = SELECT * FROM order_admin WHERE id=$id}source src2throttled : src2    //为增量索引设置{ sql_ranged_throttle = 100 sql_query = \ SELECT id, gid, addtime AS date_added, realname \ FROM order_admin}index test2{source = src2 path = /usr/local/webserver/coreseek/var/data/test2docinfo = externmlock = 0morphology = nonemin_word_len = 1 charset_type = zh_cn.utf-8 charset_dictpath =/usr/local/mmseg/etc/# 'utf-8' default value is # charset_table = 0..9, A..Z->a..z, _, a..z, U+410..U+42F->U+430..U+44F, U+430..U+44Fhtml_strip = 0}//indexer 和searchd 可以默认 如果有需要监听的数据库ip可以在searchd设置 index test2stemmed : test2  //增量索引设置{ source = src2throttled path = /usr/local/webserver/coreseek/var/data/test2stemmed morphology = stem_en}

/usr/local/webserver/coreseek/bin/indexer –rotate –config /usr/local/webserver/coreseek/etc/sphinx.conf –all 在不停止sphinx服务情况下

更新增量索引

/usr/local/webserver/coreseek/bin/indexer –rotate –config /usr/local/webserver/coreseek/etc/sphinx.conf test2stemmed

使用时使用增量索引来搜索，增量索引需要计划任务执行（数据有变化以后需更新索引才可以）