以下是csft.conf文件的内容,帮忙看看!很急! source main { type = pgsql # strip_html = 0 # index_html_attrs = sql_host = 172.16.3.120 sql_user = ups sql_pass = ups sql_db = postgres sql_port= 5432 # optional, default is 3306 sql_query_pre = SET NAMES 'utf8' sql_query_pre= update skyups.sphinx_counter set max_doc_id =(select max(id) from skyups.tbl_ups_user_info) where counter_id=1
sql_query = SELECT skyid,username,sex,birthday,animals,star,blood,province,city,vocation,nickname,realname,married FROM skyups.tbl_ups_user_info where id <= (select max_doc_id from skyups.sphinx_counter where counter_id=1) #sql_query = SELECT * FROM a.eht_articles
#sql_attr_uint= married #sql_attr_uint= star #sql_attr_uint = sex
#sql_attr_timestamp = createtime
sql_query_post = sql_ranged_throttle= 0 #sql_query_info = SELECT * FROM a.eht_articles WHERE ARTICLESID=$id }
source delta : main { sql_query_pre = sql_query = SELECT skyid,username,sex,birthday,animals,star,blood,province,city,vocation,nickname,realname,married FROM skyups.tbl_ups_user_info where id > (select max_doc_id from skyups.sphinx_counter where counter_id=1) }
index main { source = main path = /sky/sphinx/coreseek/var/data/main docinfo = extern mlock = 0 morphology = none stopwords = min_word_len = 1
charset_type = zh_cn.utf-8 charset_dictpath = /sky/sphinx/coreseek/dict/
min_prefix_len = 0
min_infix_len = 1
ngram_len = 1
#ngram_chars = U+4E00..U+9FBF, U+3400..U+4DBF, U+20000..U+2A6DF, U+F900..U+FAFF,\ #U+2F800..U+2FA1F, U+2E80..U+2EFF, U+2F00..U+2FDF, U+3100..U+312F, U+31A0..U+31BF,\ #U+3040..U+309F, U+30A0..U+30FF, U+31F0..U+31FF, U+AC00..U+D7AF, U+1100..U+11FF,\ #U+3130..U+318F, U+A000..U+A48F, U+A490..U+A4CF }
index delta : main { source = delta path = /sky/sphinx/coreseek/var/data/delta }
indexer { mem_limit = 128M }
searchd { # address = 0.0.0.0 port = 9312 log = /sky/sphinx/coreseek/var/log/searchd.log query_log = /sky/sphinx/coreseek/var/log/query.log read_timeout = 5 max_children = 30 pid_file = /sky/sphinx/coreseek/var/log/searchd.pid max_matches = 1000 seamless_rotate = 1 } |