#源定义source src1{ type = mysql sql_host = localhost sql_user = root sql_pass =password sql_db = test sql_sock = /usr/local/mysql/mysql.sock sql_query_pre = set names utf8 sql_query_pre = replace into sph_counter select 1, max(id) from do
#源定义source src1{ type = mysql sql_host = localhost sql_user = root sql_pass =password sql_db = test sql_sock = /usr/local/mysql/mysql.sock sql_query_pre = set names utf8 sql_query_pre = replace into sph_counter select 1, max(id) from documents sql_query = \ select id, group_id, unix_timestamp(date_added) as date_added, title, content \ from documents where id<=(select max_doc_id from sph_counter where counter_id=1) sql_attr_uint = group_id sql_attr_timestamp = date_added sql_ranged_throttle = 0}#######源#tblpnrsource src2{ type = mysql sql_host = localhost sql_user = root sql_pass =password sql_db = jinripnr sql_sock = /usr/local/mysql/mysql.sock sql_query_pre = set names utf8 sql_query_pre = replace into jinri.sph_counter select 2, max(id),max(update_time) from tblpnr sql_query = \ select id,orderno,pnr,ordertime from tblpnr where \ update_time=$start and id<=$end sql_ranged_throttle = 0 #无时间间隔,单位是秒}#tblticketnosource src3{ type = mysql sql_host = localhost sql_user = root sql_pass =password sql_db = jinritickno sql_sock = /usr/local/mysql/mysql.sock sql_query_pre = set names utf8 sql_query_pre = replace into jinri.sph_counter select 3, max(id), \ max(update_time) from tblticketno sql_query = \ select id,orderno, ticketno,ordertime \ from tblticketno where update_time=$start and id(select last_time \ from jinri.sph_counter where counter_id=4)}#tblordernosource src5_delta:src5{ sql_query_pre = set names utf8 sql_query_pre = sql_query = \ select id,orderno,ordertime \ from tblorderno where update_time>(select last_time \ from jinri.sph_counter where counter_id=5)}######索引#tblpnrindex src2{ source = src2 path = /usr/local/sphinx/var/data/src2 docinfo = extern dict = keywords mlock = 0 morphology = none min_word_len = 1 html_strip = 0 min_prefix_len = 0 #最小前缀 min_infix_len = 0 #最小中缀 ngram_len = 1 # 对于非字母型数据的长度切割,支持中文需要设置为1 ngram_chars = u+4e00..u+9fbf, u+3400..u+4dbf, u+20000..u+2a6df, u+f900..u+faff,u+2f800..u+2fa1f, u+2e80..u+2eff, u+2f00..u+2fdf, u+3100..u+312f, u+31a0..u+31bf,u+3040..u+309f, u+30a0..u+30ff, u+31f0..u+31ff, u+ac00..u+d7af, u+1100..u+11ff,u+3130..u+318f, u+a000..u+a48f, u+a490..u+a4cf}#tblticketnoindex src3{ source = src3 path = /usr/local/sphinx/var/data/src3 docinfo = extern dict = keywords mlock = 0 morphology = none min_word_len = 1 html_strip = 0 min_prefix_len = 0 #最小前缀 min_infix_len = 0 #最小中缀 ngram_len = 1 # 对于非字母型数据的长度切割,支持中文需要设置为1 ngram_chars = u+4e00..u+9fbf, u+3400..u+4dbf, u+20000..u+2a6df, u+f900..u+faff,u+2f800..u+2fa1f, u+2e80..u+2eff, u+2f00..u+2fdf, u+3100..u+312f, u+31a0..u+31bf,u+3040..u+309f, u+30a0..u+30ff, u+31f0..u+31ff, u+ac00..u+d7af, u+1100..u+11ff,u+3130..u+318f, u+a000..u+a48f, u+a490..u+a4cf}#tblpassengernameindex src4{ source = src4 path = /usr/local/sphinx/var/data/src4 docinfo = extern dict = keywords mlock = 0 morphology = none min_word_len = 1 html_strip = 0 min_prefix_len = 0 #最小前缀 min_infix_len = 0 #最小中缀 ngram_len = 1 # 对于非字母型数据的长度切割,支持中文需要设置为1 ngram_chars = u+3000..u+2fa1f,u+4e00..u+9fbf, u+3400..u+4dbf, u+20000..u+2a6df, u+f900..u+faff,u+2f800..u+2fa1f, u+2e80..u+2eff, u+2f00..u+2fdf, u+3100..u+312f, u+31a0..u+31bf,u+3040..u+309f, u+30a0..u+30ff, u+31f0..u+31ff, u+ac00..u+d7af, u+1100..u+11ff,u+3130..u+318f, u+a000..u+a48f, u+a490..u+a4cf}#tblordernoindex src5{ source = src5 path = /usr/local/sphinx/var/data/src5 docinfo = extern dict = keywords mlock = 0 morphology = none min_word_len = 1 html_strip = 0 min_prefix_len = 0 #最小前缀 min_infix_len = 1 #最小中缀,支持模糊查询 ngram_len = 1 # 对于非字母型数据的长度切割,支持中文需要设置为1 ngram_chars = u+3000..u+2fa1f,u+4e00..u+9fbf, u+3400..u+4dbf, u+20000..u+2a6df, u+f900..u+faff,u+2f800..u+2fa1f, u+2e80..u+2eff, u+2f00..u+2fdf, u+3100..u+312f, u+31a0..u+31bf,u+3040..u+309f, u+30a0..u+30ff, u+31f0..u+31ff, u+ac00..u+d7af, u+1100..u+11ff,u+3130..u+318f, u+a000..u+a48f, u+a490..u+a4cf}######增量索引#tblprnindex src2_delta{ source = src2_delta path = /usr/local/sphinx/var/data/src2_delta docinfo = extern dict = keywords mlock = 0 morphology = none min_word_len = 1 html_strip = 0 min_prefix_len = 0 #最小前缀 min_infix_len = 0 #最小中缀 ngram_len = 1 # 对于非字母型数据的长度切割,支持中文需要设置为1 ngram_chars = u+4e00..u+9fbf, u+3400..u+4dbf, u+20000..u+2a6df, u+f900..u+faff,u+2f800..u+2fa1f, u+2e80..u+2eff, u+2f00..u+2fdf, u+3100..u+312f, u+31a0..u+31bf,u+3040..u+309f, u+30a0..u+30ff, u+31f0..u+31ff, u+ac00..u+d7af, u+1100..u+11ff,u+3130..u+318f, u+a000..u+a48f, u+a490..u+a4cf}#tblticketnoindex src3_delta{ source = src3_delta path = /usr/local/sphinx/var/data/src3_delta docinfo = extern dict = keywords mlock = 0 morphology = none min_word_len = 1 html_strip = 0 min_prefix_len = 0 #最小前缀 min_infix_len = 0 #最小中缀 ngram_len = 1 # 对于非字母型数据的长度切割,支持中文需要设置为1 ngram_chars = u+4e00..u+9fbf, u+3400..u+4dbf, u+20000..u+2a6df, u+f900..u+faff,u+2f800..u+2fa1f, u+2e80..u+2eff, u+2f00..u+2fdf, u+3100..u+312f, u+31a0..u+31bf,u+3040..u+309f, u+30a0..u+30ff, u+31f0..u+31ff, u+ac00..u+d7af, u+1100..u+11ff,u+3130..u+318f, u+a000..u+a48f, u+a490..u+a4cf}#tblpassengernameindex src4_delta{ source = src4_delta path = /usr/local/sphinx/var/data/src4_delta docinfo = extern dict = keywords mlock = 0 morphology = none min_word_len = 1 html_strip = 0 min_prefix_len = 0 #最小前缀 min_infix_len = 0 #最小中缀 ngram_len = 1 # 对于非字母型数据的长度切割,支持中文需要设置为1 ngram_chars = u+4e00..u+9fbf, u+3400..u+4dbf, u+20000..u+2a6df, u+f900..u+faff,u+2f800..u+2fa1f, u+2e80..u+2eff, u+2f00..u+2fdf, u+3100..u+312f, u+31a0..u+31bf,u+3040..u+309f, u+30a0..u+30ff, u+31f0..u+31ff, u+ac00..u+d7af, u+1100..u+11ff,u+3130..u+318f, u+a000..u+a48f, u+a490..u+a4cf}#tblordernoindex src5_delta{ source = src5_delta path = /usr/local/sphinx/var/data/src5_delta docinfo = extern dict = keywords mlock = 0 morphology = none min_word_len = 1 html_strip = 0 min_prefix_len = 0 #最小前缀 min_infix_len = 1 #最小中缀,支持模糊查询 ngram_len = 1 # 对于非字母型数据的长度切割,支持中文需要设置为1 ngram_chars = u+4e00..u+9fbf, u+3400..u+4dbf, u+20000..u+2a6df, u+f900..u+faff,u+2f800..u+2fa1f, u+2e80..u+2eff, u+2f00..u+2fdf, u+3100..u+312f, u+31a0..u+31bf,u+3040..u+309f, u+30a0..u+30ff, u+31f0..u+31ff, u+ac00..u+d7af, u+1100..u+11ff,u+3130..u+318f, u+a000..u+a48f, u+a490..u+a4cf}#########inherited index ：索引继承 #tblpnr#index src2stemmed : src2#{# path = /usr/local/sphinx/var/data/src2stemmed# morphology = stem_en#}#tblticketno#index src3stemmed : src3#{# path = /usr/local/sphinx/var/data/src3stemmed# morphology = stem_en#}#tblpassengername#index src4stemmed : src4#{# path = /usr/local/sphinx/var/data/src4stemmed# morphology = stem_en#}#########分布式搜索#tblpnrindex dist2{ type = distributed local = src2 local = src2_delta}#tblticketnoindex dist3{ type = distributed local = src3 local = src3_delta}#tblpassengernameindex dist4{ type = distributed local = src4 local = src4_delta}#orderno:intpu value include *,not support dist query#index dist5#{# type = distributed# local = src5# local = src5_delta#}index rt{ type = rt path = /usr/local/sphinx/var/data/rt rt_field = title rt_field = content rt_attr_uint = gid}indexer{ mem_limit = 1024m}searchd{# listen = /var/run/searchd.sock listen = 127.0.0.1:9312:sphinx listen = 9306:mysql41 listen = 192.168.0.128:9312:sphinx log = /usr/local/sphinx/var/log/searchd.log query_log = /usr/local/sphinx/var/log/query.log read_timeout = 5 client_timeout = 300 max_children = 30 persistent_connections_limit = 30 pid_file = /usr/local/sphinx/var/log/searchd.pid seamless_rotate = 1 ### 是否支持无缝切换，做增量索引时通常需要 preopen_indexes = 1 unlink_old = 1 mva_updates_pool = 1m max_packet_size = 8m max_filters = 256 max_filter_values = 4096 max_batch_queries = 32 dist_threads = 2}common{}