sphinx配置文件(rs_mysql.conf)

来源:转载

#MySQL数据源配置,详情请查看:http://www.coreseek.cn/products-install/mysql/ #请先将var/test/documents.sql导入数据库,并配置好以下的MySQL用户密码数据库


#源定义 source rs { type = mysql


sql_host = localhost sql_user = sphinxdbuser sql_pass = sphinx07test sql_db= recruitment_system sql_port = 3306 sql_query_pre= SET NAMES utf8


sql_query = SELECT id, user_name, identity_card,telephone,age,birthday,sex,marry_status,job_years,email,/ request_job,request_company,job_city,expect_job_property,expect_job,expect_job_type,expect_job_area,expect_money,/ current_money,current_status,self_evaluation,last_work_company,current_job_position,work_experience,project_experience,/ education_experience,certificate,language_experience,training_experience,professional_skills,other_info,all_info,/ UNIX_TIMESTAMP(create_time) AS date_create FROM user_info#sql_query第一列id需为整数#列出字段建全文索引 sql_attr_uint= id#从SQL读取到的值必须为整数 sql_attr_timestamp = date_create #从SQL读取到的值必须为整数,作为时间属性


sql_query_info_pre = SET NAMES utf8#命令行查询时,设置正确的字符集 #sql_query_info = SELECT * FROM user_info WHERE id=$id #命令行查询时,从数据库读取原始数据信息 }


#index定义 index rs1 { source= rs#对应的source名称 path= /opt/soft_install/coreseek/csft/var/data/rs #请修改为实际使用的绝对路径,例如:/usr/local/coreseek/var/... docinfo= extern mlock= 0 morphology= none min_word_len = 1 html_strip= 0


#中文分词配置,详情请查看:http://www.coreseek.cn/products-install/coreseek_mmseg/ charset_dictpath = /opt/soft_install/coreseek/mmseg/etc/ #BSD、Linux环境下设置,/符号结尾 #charset_dictpath = /usr/local/mmseg3/etc/ #BSD、Linux环境下设置,/符号结尾 #charset_dictpath = etc/ #Windows环境下设置,/符号结尾,最好给出绝对路径,例如:C:/usr/local/coreseek/etc/... charset_type= zh_cn.utf-8 }


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


#searchd服务定义 searchd { listen= 9312 read_timeout= 5 max_children= 30 max_matches = 1000000 seamless_rotate = 0 preopen_indexes = 0 unlink_old = 1 pid_file = /opt/soft_install/coreseek/csft/var/log/searchd_mysql.pid #请修改为实际使用的绝对路径,例如:/usr/local/coreseek/var/... log = /opt/soft_install/coreseek/csft/var/log/searchd_mysql.log#请修改为实际使用的绝对路径,例如:/usr/local/coreseek/var/... query_log = /opt/soft_install/coreseek/csft/var/log/query_mysql.log #请修改为实际使用的绝对路径,例如:/usr/local/coreseek/var/... binlog_path =#关闭binlog日志 }

分享给朋友:
您可能感兴趣的文章:
随机阅读: