coreseek及sphinx的.conf典型简单配置

1 #
      2 # Minimal Sphinx configuration sample (clean, simple, functional)
      3 #
      4 #定义数据源
      5 source src1
      6 {
      7         type                    = mysql
      8         sql_host                = localhost
      9         sql_user                = root
     10         sql_pass                =
     11         sql_db                  = test_sph
     12         sql_port                = 3306  # optional, default is 3306
     13         sql_query_pre           = REPLACE INTO sph_counter SELECT 1, unix_timestamp() FROM documents
     14         sql_query_pre           = SET NAMES utf8
     15         sql_sock                =/usr/local/mysql/mysql.sock
     16
     17         sql_query = SELECT id,delid,title,content,uptime,intime FROM documents WHERE uptime<=(SELECT max_time FROM sph_counter WHERE counter_id=1)

     18         sql_attr_uint = delid  --定义属性为无符号int型，作为过滤字段使用

sphinx的属性类型有：    (

sql_attr_uint
sql_attr_bool
sql_attr_bigint
sql_attr_timestamp
sql_attr_str2ordinal
sql_attr_float
sql_attr_multi

)

     19         sql_attr_uint = uptime -------虽然在数据库中其为字符串类型但属性不收其影响可定义为uint --定义属性为无符号int型，作为过滤字段使用
     20         sql_query_info_pre      =SET NAMES utf8
     21         sql_query_info          = SELECT * FROM documents WHERE id=$id
     22 }
     23
     24
     25
     26 #增量数据源
     27 source delta : src1
     28
     29 {
     30
     31 sql_query_pre = SET NAMES utf8
     32
     33 #sql_query_pre = SET SESSION query_cache_type=OFF
     34
     35 sql_query = SELECT id,delid,title,content,uptime,intime FROM documents WHERE uptime>( SELECT max_time FROM sph_counter WHERE counter_id=1 )
     36
     37 sql_query_post_index = REPLACE INTO sph_counter SELECT 1,unix_timestamp() FROM documents  #更新统计表
     38
     39 sql_attr_uint             =delid
     40 sql_query_info_pre      = SET NAMES utf8                                        #命令行查询时，设置正确的字符集
     41
     42 sql_query_info          = SELECT * FROM documents WHERE id=$id
     43
     44 }
     45
     46
     47 #定义索引
     48 index test1
     49 {
     50         #索引数据源
     51         source                  = src1
     52         #数据地址
     53         path                    = /usr/local/csft4/var/data/test1
     54         docinfo                 = extern
     55         charset_type            = zh_cn.utf-8
     56         #中文分词配置
     57         #BSD、Linux环境下设置，/符号结尾
     58         charset_dictpath = /usr/local/mmseg4/etc/
     59 }
     60
     61
     62 # 增量索引
     63 index delta : test1
     64 {
     65     source = delta
     66     path = /usr/local/csft4/var/data/delta
     67     docinfo            = extern
     68     mlock            = 0
     69     morphology        = none
     70     min_word_len        = 1
     71     html_strip                = 0
     72
     73     charset_dictpath = /usr/local/mmseg4/etc/ #BSD、Linux环境下设置，/符号结尾
     74     charset_type        = zh_cn.utf-8
     75 }
     76
     77 indexer
     78 {
     79         mem_limit               =64M
     80 }
     81
     82
     83 searchd
     84 {
     85         listen                  = 9312
     86         listen                  = 9306:mysql41
     87         log                     = /usr/local/csft4/logs/searchd.log
     88         query_log               = /usr/local/csft4/logs/query.log
     89         read_timeout            = 5
     90         max_children            = 30
     91         pid_file                = /usr/local/csft4/pids/searchd.pid
     92         max_matches             = 1000
     93         seamless_rotate         = 1
     94         preopen_indexes         = 1
     95         unlink_old              = 1
     96         attr_flush_period       = 10  --把属性写回硬盘中，秒为单位
     97         workers                 = threads # for RT to work
     98 }