{
type = rt
path = /data0/sphinx/var/data/resource_rt
charset_type = utf-8
chinese_dictionary = /data0/sphinx/etc/xdict_1.1
rt_field = name
rt_field = search_name
rt_attr_uint = resource_id
rt_attr_uint = source
rt_attr_uint = class_id
rt_attr_uint = star
rt_attr_multi = tags
rt_attr_uint = channel_id
rt_attr_uint = downs
rt_attr_uint = week_downs
rt_attr_uint = month_downs
rt_attr_uint = virtual_downs
rt_attr_uint = total_downs
rt_attr_uint = weight
rt_attr_uint = lewan_best_weight
rt_attr_uint = latest_weight
rt_attr_uint = week_weight
rt_attr_uint = month_weight
rt_attr_uint = top_weight
rt_attr_uint = is_exists_full_package
rt_attr_uint = is_silent_install
rt_attr_uint = zq_status
rt_attr_uint = is_trailer
rt_attr_uint = status
rt_attr_timestamp = update_date_timestamp
rt_attr_timestamp = add_date_timestamp
rt_attr_timestamp = update_timestamp
rt_attr_timestamp = add_timestamp
}
searchd
{
listen = 212
listen = 206:mysql41
log = /data0/sphinx/var/log/rt.log
query_log = /data0/sphinx/var/log/rt-query.log
read_timeout = 5
max_children = 300
pid_file = /data0/sphinx/var/data/rt.pid
max_matches = 1000
seamless_rotate = 1
preopen_indexes = 1
unlink_old = 1
workers = threads # for RT to work
binlog_path = /data0/sphinx/var/log/binlog
}
测试
连接 mysql -h 127.0.0.1 -P 206
insert into resource_rt (id,name,search_name) values(1,'abc', '天天向上开心');
select * from resource_rt where match('开心');