#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/... }