首页 > 代码库 > 【实战】sphinx的配置文件
【实战】sphinx的配置文件
#源定义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<=(SELECT last_time FROM jinri.sph_counter WHERE counter_id=2) #字符串属性设置、需要过滤、排序的时候用到 #sql_attr_uint = sql_attr_timestamp = ordertime sql_attr_string = orderno #只检索orderno sql_field_string = pnr #sql_field_string 用于全文即保存索引,sql_attr_string只用于检索即不保存索引 #分区查询设置 #sql_query_range = SELECT MIN(id),MAX(id) FROM tblpnr #sql_range_step = 500000 #sql_query = SELECT * FROM tblpnr WHERE id>=$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<=(SELECT last_time FROM jinri.sph_counter WHERE counter_id=3) #字符串属性设置、需要过滤、排序的时候用到 #sql_attr_uint = sql_attr_timestamp = ordertime sql_attr_string = orderno #只检索orderno sql_field_string = ticketno #sql_field_string 用于全文即保存索引,sql_attr_string只用于检索即不保存索引 #分区查询设置 #sql_query_range = SELECT MIN(id),MAX(id) FROM tblticketno #sql_range_step = 1000000 #sql_query = SELECT * FROM tblticketno WHERE id>=$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=5) #字符串属性设置、需要过滤、排序的时候用到 #sql_attr_uint = sql_attr_timestamp = ordertime sql_field_string = orderno #sql_field_string 用于全文即保存索引,sql_attr_string只用于检索即不保存索引 sql_ranged_throttle = 0}#tblpnrsource src2throttled : src2{ sql_ranged_throttle = 100}#tblticketnosource src3throttled : src3{ sql_ranged_throttle = 100}#tblpassengernamesource src4throttled : src4{ sql_ranged_throttle = 100}#tblordernosource src5throttled : src5{ sql_ranged_throttle = 100}########增量源#tblpnrsource src2_delta:src2{ sql_query_pre = SET NAMES utf8 sql_query_pre = sql_query = SELECT id,orderno, pnr,ordertime FROM tblpnr 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{}
【实战】sphinx的配置文件
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。