+ -
当前位置:首页 → 问答吧 → php + sphinx 配置不出来增量索引

php + sphinx 配置不出来增量索引

时间:2011-04-21

来源:互联网

#
# 在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.当我修改主索引数据源的内容,查询修改后的内容,查询不出来,这是为什么?

作者: s_c1987   发布时间: 2011-04-21

想及时得到更新的数据的ID 你需要从新reindex

作者: andyxl   发布时间: 2011-04-21

热门下载

更多