Sphinx 2.3到Sphinx 3.1的转换

Question

我有一个sphinx的数据源配置文件，其中包含以下代码

source src1_c_march_april_2020
{
        type                    = mysql

        sql_host                = 67.225.224.103
        sql_user                = enspekto_wrdp3
        sql_pass                = xxxxxxx
        sql_db                  = enspekto_wrdp3
        sql_port                = 3306  # optional, default is 33
        sql_query_pre           = SET CHARACTER_SET_RESULTS=utf8
        sql_query_pre           = SET NAMES utf8

        sql_query_range = SELECT MIN(wpf7_readibility_content_index.tw_scrap_data_id)+10921149,MAX(wpf7_readibility_content_index.tw_scrap_data_id)-632561+631300 FROM wpf7_readibility_content_index
        sql_range_step = 100000
        sql_query                =  SELECT wpf7_readibility_content_index.id,wpf7_readibility_content_index.tw_scrap_data_id, wpf7_readibility_content_index.content,TABLE1.id, UNIX_TIMESTAMP( TABLE1.sql_date ) AS added_ts \
        FROM wpf7_readibility_content_index \
        INNER JOIN TABLE1 ON TABLE1.id = wpf7_readibility_content_index.tw_scrap_data_id WHERE wpf7_readibility_content_index.tw_scrap_data_id >=$start AND wpf7_readibility_content_index.tw_scrap_data_id <=$end

        sql_attr_uint           = tw_scrap_data_id
        sql_field_string        = content
        sql_attr_timestamp      = added_ts

}

index test1_march_april_2020
{
        source                  = src1_c_march_april_2020
        path                    = /home2/spindexes/test1_march_april_2020
        html_strip              = 1
        html_remove_elements    = style, script, object, embed, span
        expand_keywords         = 1
        blend_chars             = +,&->:#
        # inplace_enable          = 1
        # charset_type            = utf-8

}


indexer
{
    mem_limit       = 1024M
        max_iosize              = 1048576
        max_iops                = 40
        write_buffer            = 2M

}
searchd
{
        listen                  = 9312
        listen                  = 9306:mysql41
        log                     = /var/log/sphinx/searchd.log
        query_log               = /var/log/sphinx/query.log
        read_timeout            = 5
        max_children            = 30
        pid_file                = /var/run/sphinx/searchd.pid
        seamless_rotate         = 1
        preopen_indexes         = 1
        unlink_old              = 1
        workers                 = threads # for RT to work
        binlog_path             = /home2/spindexes/
}
common
{
        lemmatizer_base         = /usr/local/share/sphinx/dicts/
}

这个配置文件是使用sphinx 2.3规则创建的。我想转换脚本根据sphinx 3.1。此转换需要进行哪些更改？

我访问了http://sphinxsearch.com/docs/sphinx3.html#sphinx-3作为参考，但他们在那里使用了以下示例

index rt
{
    type = rt

    rt_field = title
    rt_field = content

    rt_attr_uint = gid # regular attribute
    rt_attr_float_array = vec1[5] # 5D array of floats
    rt_attr_int8_array = vec2[3] # 3D array of small 8-bit integers
    # ...
}

source test1
{
    type = mysql

    sql_attr_int8_array = vec1[17] # 17D array of small 8-bit integers
    # ...
}

我对在我的文件中用作MySQL的类型和在引用中用作rt的类型感到有点困惑。需要一些转换的帮助。如果我能得到一个完整的指南，我将不胜感激。

Answer 1

最有可能的情况是，您不需要在配置的索引/源部分中进行任何更改。

在我的文件中用作MySQL，在引用中用作rt的

类型

请注意，在您的配置中，type=mysql用于source，而示例type=rt中的用于索引。这是两件不同的事情。type=plain的index (或者不是type，因为这是默认值)可以从source索引，如果您在索引中指定source = ...的话。type=rt的索引是一个实时索引。请阅读手册，了解其中的差异。