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.当我修改主索引数据源的内容,查询修改后的内容,查询不出来,这是为什么?
# 在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
相关阅读 更多
热门阅读
-
office 2019专业增强版最新2021版激活秘钥/序列号/激活码推荐 附激活工具
阅读:74
-
如何安装mysql8.0
阅读:31
-
Word快速设置标题样式步骤详解
阅读:28
-
20+道必知必会的Vue面试题(附答案解析)
阅读:37
-
HTML如何制作表单
阅读:22
-
百词斩可以改天数吗?当然可以,4个步骤轻松修改天数!
阅读:31
-
ET文件格式和XLS格式文件之间如何转化?
阅读:24
-
react和vue的区别及优缺点是什么
阅读:121
-
支付宝人脸识别如何关闭?
阅读:21
-
腾讯微云怎么修改照片或视频备份路径?
阅读:28