sphinx conf 文件模板

#goods源定义
source goods
{
    type                    = mysql

    sql_host                = localhost
    sql_user                = root
    sql_pass                = root
    sql_db                    = test
    sql_port                = 3306
    sql_query_pre            = SET NAMES utf8

    sql_query        = SELECT * FROM aa #sql_query第一列id需为整数
    sql_query_post = update  goods_new set id = (select max(id) from aa)
}
#goods_new源定义
source goods_new
{
    type                    = mysql

    sql_host                = localhost
    sql_user                = root
    sql_pass                = root
    sql_db                    = test
    sql_port                = 3306
    sql_query_pre            = SET NAMES utf8

    sql_query        = SELECT * FROM aa where id>(select id from goods_new) #sql_query第一列id需为整数
    sql_query_post = update  goods_new set id = (select max(id) from aa)
}

#goods index定义
index goods
{
    source     = goods             #对应的source名称
    path   = D:\myWork\menchuangWork\coreseek-3.2.14-win32/var/data/mysql/aa #请修改为实际使用的绝对路径，例如：/usr/
    docinfo            = extern
    mlock            = 0
    morphology        = none
    min_word_len        = 1
    html_strip        = 0

    
    charset_dictpath = D:\myWork\menchuangWork\coreseek-3.2.14-win32\etc/          #Windows环境下设置，/符号结尾，最好给出绝对路径，例如：C:/usr/local/coreseek/etc/...
    charset_type    = zh_cn.utf-8
}
#goods_new index定义
index goods_new
{
    source     = goods_new             #对应的source名称
    path   = D:\myWork\menchuangWork\coreseek-3.2.14-win32/var/data/mysql/aa_new #请修改为实际使用的绝对路径，例如：/usr/
    docinfo          = extern
    mlock            = 0
    morphology        = none
    min_word_len      = 1
    html_strip        = 0
    
    charset_dictpath = D:\myWork\menchuangWork\coreseek-3.2.14-win32\etc/          #Windows环境下设置，/符号结尾，最好给出绝对路径，例如：C:/usr/local/coreseek/etc/...
    charset_type    = zh_cn.utf-8
}

#全局index定义
indexer
{
    mem_limit            = 128M
}

#searchd服务定义
searchd
{
    listen                  =   9312
    read_timeout        = 5
    max_children        = 30
    max_matches            = 1000
    seamless_rotate        = 0
    preopen_indexes        = 0
    unlink_old            = 1
    pid_file = D:\myWork\menchuangWork\coreseek-3.2.14-win32/var/log/searchd_mysql.pid  #请修改为实际使用的绝对路径，例如：/usr/local/coreseek/var/...
    log = D:\myWork\menchuangWork\coreseek-3.2.14-win32/var/log/searchd_mysql.log        #请修改为实际使用的绝对路径，例如：/usr/local/coreseek/var/...
    query_log = D:\myWork\menchuangWork\coreseek-3.2.14-win32/var/log/query_mysql.log #请修改为实际使用的绝对路径，例如：/usr/local/coreseek/var/...
}