coreseek/sphinx review

数据库创建 http://blog.sina.com.cn/s/blog_998c49430101aif2.html

启动和停止 http://blog.163.com/effeee@126/blog/static/11462939820135553926307/

增量索引 http://blog.csdn.net/bushizhuanjia/article/details/7626522 http://banu.blog.163.com/blog/static/2314648201092911412539/

 

source goods
{
        type                                    = mysql


        sql_host                                = localhost
        sql_user                                = root
        sql_pass                                = root
        sql_db                                  = sphinx
        sql_port                                = 3306  


       sql_query =SELECT goods_id,goods_name,goods_color,goods_id as goods_new_id ,goods_name AS goods_name_search,goods_color AS goods_color_search  From goods_test  WHERE goods_id>=$start and goods_id <=$end and  goods_id<=( SELECT max_doc_id FROM sph_counter WHERE counter_id=1 )  ;
         sql_attr_uint = goods_new_id
sql_attr_str2ordinal = goods_name
            sql_attr_str2ordinal = goods_color 


                sql_query_info = SELECT * FROM goods_test Where goods_id = $id; 
        sql_query_pre = set names utf8
      sql_query_pre       = replace into sph_counter select 1,max(goods_id) from goods_test
    sql_query_range     = select 1,max(goods_id) from goods_test  
}






index goods
{
        source                                  = goods
        path                                    = /usr/local/coreseek/var/data/goods
        docinfo                                 = extern
charset_dictpath = /usr/local/mmseg3/etc/
charset_type = zh_cn.utf-8
mlock = 0
morphology = none
min_word_len = 1
ngram_len                    = 1
min_infix_len = 1
}




source delta : goods
{
    sql_query_pre = SET NAMES utf8
    sql_query = SELECT goods_id, goods_name, goods_color, goods_id as goods_new_id  ,goods_name AS goods_name_search,goods_color AS goods_color_search  FROM goods_test  WHERE goods_id>=$start and goods_id <=$end and  goods_id>( SELECT max_doc_id FROM sph_counter WHERE counter_id=1 )





       sql_query_post_index    = replace into sph_counter select 1,max(goods_id) from goods_test
}


index delta:goods
{
       source = delta
      path   = /usr/local/coreseek/var/data/goodsdelta


    docinfo            = extern
    charset_type        = zh_cn.utf-8
    charset_dictpath     = /usr/local/mmseg3/etc/
    ngram_len                 = 0
    mlock            = 0
    min_word_len        = 1


}




indexer
{
        mem_limit                               = 128M
}




searchd
{
        port                                    = 9312
        log                                             = /usr/local/coreseek/var/log/searchd_new.log
        query_log                               = /usr/local/coreseek/var/log/query_new.log
        pid_file                                = /usr/local/coreseek/var/log/searchd.pid
        max_matches                             = 1000
        seamless_rotate                 = 1
        preopen_indexes                 = 0
        unlink_old                              = 1
read_timeout = 5
max_children = 30

}