#goods源定義 source goods {type = mysqlsql_host = localhostsql_user = rootsql_pass = rootsql_db = testsql_port = 3306sql_query_pre = SET NAMES utf8sql_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 = mysqlsql_host = localhostsql_user = rootsql_pass = rootsql_db = testsql_port = 3306sql_query_pre = SET NAMES utf8sql_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 = externmlock = 0morphology = nonemin_word_len = 1html_strip = 0charset_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 = externmlock = 0morphology = nonemin_word_len = 1html_strip = 0charset_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 = 9312read_timeout = 5max_children = 30max_matches = 1000seamless_rotate = 0preopen_indexes = 0unlink_old = 1pid_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/... }

?

轉載于:https://www.cnblogs.com/shenaishiren/p/7757718.html

總結

以上是生活随笔為你收集整理的sphinx conf 文件模板的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。