mysql sphfiks_【实战】sphinx的配置文件

最新推荐文章于 2021-02-05 05:28:57 发布

weixin_39814369

最新推荐文章于 2021-02-05 05:28:57 发布

阅读量118

点赞数

文章标签： mysql sphfiks

本文链接：https://blog.csdn.net/weixin_39814369/article/details/113434797

版权

#源定义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

}

#######源

#tblpnr

source 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 #无时间间隔,单位是秒

}

#tblticketno

source 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

}

#tblpassengername

source 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

}

#tblorderno

source 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

}

#tblpnr

source src2throttled : src2

{

sql_ranged_throttle= 100

}

#tblticketno

source src3throttled : src3

{

sql_ranged_throttle= 100

}

#tblpassengername

source src4throttled : src4

{

sql_ranged_throttle= 100

}

#tblorderno

source src5throttled : src5

{

sql_ranged_throttle= 100

}

########增量源

#tblpnr

source 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)

}

#tblticketno

source 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)

}

#tblpassengername

source 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)

}

#tblorderno

source 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)

}

######索引

#tblpnr

index 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

}

#tblticketno

index 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

}

#tblpassengername

index 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

}

#tblorderno

index 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

}

######增量索引

#tblprn

index 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

}

#tblticketno

index 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

}

#tblpassengername

index 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

}

#tblorderno

index 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

}

#########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

#########分布式搜索

#tblpnr

index dist2

{

type = distributed

local = src2

local = src2_delta

}

#tblticketno

index dist3

{

type = distributed

local = src3

local = src3_delta

}

#tblpassengername

index 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

{

}

本文原创发布php中文网，转载请注明出处，感谢您的尊重！

weixin_39814369

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
mysql sphfiks_【实战】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 s...
复制链接

扫一扫