#源定义source src1{ typ本文来源gao.dai.ma.com搞@代*码(网$e = 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<=$end sql_ranged_throttle = 0}#tblpassengernamesource src4{ type = mysql sql_host = localhost sql_user = root sql_pass =password sql_db = jinripname sql_sock = /usr/local/mysql/mysql.sock sql_query_pre = SET NAMES utf8 sql_query_pre = REPLACE INTO jinri.sph_counter SELECT 4, MAX(id), \ max(update_time) FROM tblpassengername sql_query = \ SELECT id,orderno, passengername,ordertime \ FROM tblpassengername where update_time<=(SELECT last_time FROM jinri.sph_counter \ WHERE counter_id=4) #字符串属性设置、需要过滤、排序的时候用到 #sql_attr_uint = sql_attr_timestamp = ordertime sql_attr_string = orderno #只检索orderno sql_field_string = passengername #sql_field_string 用于全文即保存索引,sql_attr_string只用于检索即不保存索引 sql_ranged_throttle = 0}#tblordernosource src5{ type = mysql sql_host = localhost sql_user = root sql_pass =password sql_db = jinriorderno sql_sock = /usr/local/mysql/mysql.sock sql_query_pre = SET NAMES utf8 sql_query_pre = REPLACE INTO jinri.sph_counter SELECT 5, MAX(id), \ max(update_time) FROM tblorderno sql_query = \ SELECT id,orderno,ordertime \ FROM tblorderno where update_time(SELECT last_time \ FROM jinri.sph_counter WHERE counter_id=2)}#tblticketnosource src3_delta:src3{ sql_query_pre = SET NAMES utf8 sql_query_pre = sql_query = \ SELECT id,orderno, ticketno,ordertime \ FROM tblticketno where update_time>(SELECT last_time \ FROM jinri.sph_counter WHERE counter_id=3)}#tblpassengernamesource src4_delta:src4{ sql_query_pre = SET NAMES utf8 sql_query_pre = sql_query = \ SELECT id,orderno,passengername,ordertime \ FROM tblpassengername where update_time>(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{}
搞代码网（gaodaima.com）提供的所有资源部分来自互联网，如果有侵犯您的版权或其他权益，请说明详细缘由并提供版权或权益证明然后发送到邮箱[email protected]，我们会在看到邮件的第一时间内为您处理，或直接联系QQ：872152909。本网站采用BY-NC-SA协议进行授权
转载请注明原文链接：【实战】sphinx的配置文件
转载请注明原文链接：【实战】sphinx的配置文件
