#
# 在windows下的配置sphinx 
#
############主索引源#############
source main
{
type = mysql sql_host = localhost
sql_user = root
sql_pass = 123456
sql_db = test
sql_port = 3306 # optional, default is 3306 sql_query = SELECT id, group_id, UNIX_TIMESTAMP(date_added) AS date_added, title, content \
FROM documents WHERE id<= 6 sql_attr_uint = group_id
sql_attr_timestamp = date_added sql_query_info = SELECT * FROM documents WHERE id=$id
}
############增量索引源############
source desmain : main
{
sql_query = SELECT id, group_id, UNIX_TIMESTAMP(date_added) AS date_added, title, content \
FROM documents WHERE id > 6 sql_attr_uint = group_id
sql_attr_timestamp = date_added sql_query_info = SELECT * FROM documents WHERE id=$id
}
#############主索引###########
index main
{
source = main
path = d:/wamp/www/sphinx/data/test1/
docinfo = extern
charset_type = sbcs
}#########增量索引############
index desmain : main
{
source  = desmain
path  = d:/wamp/www/sphinx/data/destest1/
}indexer
{
mem_limit = 32M
}
###########sphinx守护进程############
searchd
{
listen = 9312
#listen = 9306:mysql41
log = d:/wamp/www/sphinx/log/searchd.log
query_log = d:/wamp/www/sphinx/log/query.log
read_timeout = 5
max_children = 30
pid_file = d:/wamp/www/sphinx/log/searchd.pid
max_matches = 1000
seamless_rotate = 1
preopen_indexes = 0
unlink_old = 1
workers = threads # for RT to work
}###########################困惑点###################################
1.在运行时,能得到主索引数据,但是当再添加数据时,却无法查询到,增量索引的东西
查了很多资料但还是没有出来
2.当我修改主索引数据源的内容,查询修改后的内容,查询不出来,这是为什么?