sphinx rt ,实时索引,sphinx.conf配置事例

index resource_rt
{
    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('开心');