(五) MYSQL性能优化之 Coreseek 的配置文件

#MySQL数据源配置，详情请查看：http://www.coreseek.cn/products-install/mysql/

#源定义 源的名字可以随便定义

source mysql

{

type = mysql

sql_host = localhost

sql_user = root

sql_pass = 123456

sql_db = test

sql_port = 3306

sql_query_pre = SET NAMES utf8

#sql_query第一列id需为整数。comname, comaddress作为字符串/文本字段，被全文索引

sql_query = SELECT id, comname, comaddress FROM address

}

#增量源定义

source mysql_zl

{

type = mysql

sql_host = localhost

sql_user = root

sql_pass = 123456

sql_db = test

sql_port = 3306

sql_query_pre = SET NAMES utf8

#sql_query第一列id需为整数。comname, comaddress作为字符串/文本字段，被全文索引

sql_query = SELECT id, comname, comaddress FROM address WHERE id > (select max from address_zl)

sql_query_post = update address_zl set max=(select max(id) from address)

}

#index定义

index mysql

{

source = mysql #对应的source名称

#请修改为实际使用的绝对路径

path = /working/sphinx/var/data/mysql

docinfo = extern #文件信息存储模式

mlock = 0 #锁定内存

morphology = none #词形处理器

min_word_len = 1 #索引最小长度

html_strip = 0 #是否去除HTML标签

#中文分词配置，详情请查看：http://www.coreseek.cn/products-install/coreseek_mmseg/

charset_dictpath = /working/mmseg/etc/

charset_type = zh_cn.utf-8

}

#index定义

index mysql_zl

{

source = mysql_zl #对应的source名称

#请修改为实际使用的绝对路径

path = /working/sphinx/var/data/mysql_zl

docinfo = extern #文件信息存储模式

mlock = 0 #锁定内存

morphology = none #词形处理器

min_word_len = 1 #索引最小长度

html_strip = 0 #是否去除HTML标签

#中文分词配置，详情请查看：http://www.coreseek.cn/products-install/coreseek_mmseg/

charset_dictpath = /working/mmseg/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 = /working/sphinx/var/log/searchd_mysql.pid

log = /working/sphinx/var/log/searchd_mysql.log

query_log = /working/sphinx/var/log/query_mysql.log

}