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