一个可用的coreseek以及sphinx的csft.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 * FROM documents WHERE uptime<=(SELECT max_time FROM sph_counter WHERE counter_id=1)
     18
     19         #sql_attr_timestamp     = date_added
     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 * FROM documents WHERE uptime>( SELECT max_time FROM sph_counter WHERE counter_id=1 )
     36
     37 sql_query_post = REPLACE INTO sph_counter SELECT 1,unix_timestamp() FROM documents  #更新统计表
     38
     39 sql_query_info_pre      = SET NAMES utf8                                        #命令行查询时，设置正确的字符集
     40
     41 sql_query_info          = SELECT * FROM documents WHERE id=$id
     42
     43 }
     44
     45
     46 #定义索引
     47 index test1
     48 {
     49         #索引数据源
     50         source                  = src1
     51         #数据地址
     52         path                    = /usr/local/csft4/var/data/test1
     53         docinfo                 = extern
     54         charset_type            = zh_cn.utf-8
     55         #中文分词配置
     56         #BSD、Linux环境下设置，/符号结尾
     57         charset_dictpath = /usr/local/mmseg4/etc/
     58 }
     59
     60
     61 # 增量索引
     62 index delta : test1
     63 {
     64     source = delta
     65     path = /usr/local/csft4/var/data/delta
     66     docinfo            = extern
     67     mlock            = 0
     68     morphology        = none
     69     min_word_len        = 1
     70     html_strip                = 0
     71
     72     charset_dictpath = /usr/local/mmseg4/etc/ #BSD、Linux环境下设置，/符号结尾
     73     charset_type        = zh_cn.utf-8
     74 }
     75
     76 indexer
     77 {
     78         mem_limit               =64M
     79 }
     80
     81
     82 searchd
     83 {
     84         listen                  = 9312
     85         listen                  = 9306:mysql41
     86         log                     = /usr/local/csft4/logs/searchd.log
     87         query_log               = /usr/local/csft4/logs/query.log
     88         read_timeout            = 5
     89         max_children            = 30
     90         pid_file                = /usr/local/csft4/pids/searchd.pid
     91         max_matches             = 1000
     92         seamless_rotate         = 1
     93         preopen_indexes         = 1
     94         unlink_old              = 1
     95         workers                 = threads # for RT to work
     96 }