#MySQL数据源配置,详情请查看:http://www.coreseek.cn/products-install/mysql/
2 #请先将var/test/documents.sql导入数据库,并配置好以下的MySQL用户密码数据库
3
4 #源定义
5
6 source news_news
7 {
8 type = mysql
9 sql_host = 127.0.0.1
10 sql_user = ecun
11 sql_pass = ecun001
12 sql_db = ymtnews
13 sql_port = 3306
14 sql_sock = /tmp/mysql.sock
15 sql_query_pre = SET NAMES utf8
16 sql_query_pre = REPLACE INTO sph_counter SELECT 'news_news', MAX(id) FROM news_news
17 sql_query = SELECT id, inputtime AS date_added, title,description,catid FROM news_new s WHERE status=99 AND id <= (SELECT max_do c_id FROM sph_counter WHERE counter_name = 'news_news' )
18
19 sql_attr_uint = catid
20 sql_attr_timestamp = date_added
21 sql_query_info_pre = SET NAMES utf8
22 sql_query_info = SELECT * FROM news_news WHERE id=$id
23 }
24
25 source news_news_delta:news_news
26 {
27 sql_query_pre = SET NAMES utf8
28 sql_query = SELECT id, inputtime AS date_added, title,description,catid FROM news_news WHERE status=99 AND id > (SELECT max_doc_id FRO M sph_counter WHERE counter_name = 'news_news' )
29 }
30 #index定义
31
32 index news_news
33 {
34 source = news_news
35 path = /data/logs/coreseek/data/news_news
36 docinfo = extern
37 mlock = 0
38 morphology = none
39 min_word_len = 1
40 html_strip = 1
41 charset_dictpath = /usr/local/mmseg3/etc/
42 charset_type = zh_cn.utf-8
43 stopwords = /usr/local/coreseek/etc/stopwords.txt
44 }
45
46 index news_news_delta:news_news
47 {
48 source = news_news_delta
49 path = /data/logs/coreseek/data/news_news_delta
50 }
51
52 #全局index定义
53 indexer
54 {
55 mem_limit = 128M
56 }
57
58 #searchd服务定义
59 searchd
60 {
61 listen = 9312
62 read_timeout = 5
63
64 max_children = 0
65
66 max_matches = 100000
67 seamless_rotate = 0
68 preopen_indexes = 0
69 unlink_old = 1
70 pid_file = /data/logs/coreseek/coreseek.pid #请修改为实际使用的绝对路径,例如:/usr/local/coresee k/var/...
71 log = /data/logs/coreseek/coreseek.log #请修改为实际使用的绝对路径,例如:/usr/local/corese ek/var/...
72 }
2 #请先将var/test/documents.sql导入数据库,并配置好以下的MySQL用户密码数据库
3
4 #源定义
5
6 source news_news
7 {
8 type = mysql
9 sql_host = 127.0.0.1
10 sql_user = ecun
11 sql_pass = ecun001
12 sql_db = ymtnews
13 sql_port = 3306
14 sql_sock = /tmp/mysql.sock
15 sql_query_pre = SET NAMES utf8
16 sql_query_pre = REPLACE INTO sph_counter SELECT 'news_news', MAX(id) FROM news_news
17 sql_query = SELECT id, inputtime AS date_added, title,description,catid FROM news_new s WHERE status=99 AND id <= (SELECT max_do c_id FROM sph_counter WHERE counter_name = 'news_news' )
18
19 sql_attr_uint = catid
20 sql_attr_timestamp = date_added
21 sql_query_info_pre = SET NAMES utf8
22 sql_query_info = SELECT * FROM news_news WHERE id=$id
23 }
24
25 source news_news_delta:news_news
26 {
27 sql_query_pre = SET NAMES utf8
28 sql_query = SELECT id, inputtime AS date_added, title,description,catid FROM news_news WHERE status=99 AND id > (SELECT max_doc_id FRO M sph_counter WHERE counter_name = 'news_news' )
29 }
30 #index定义
31
32 index news_news
33 {
34 source = news_news
35 path = /data/logs/coreseek/data/news_news
36 docinfo = extern
37 mlock = 0
38 morphology = none
39 min_word_len = 1
40 html_strip = 1
41 charset_dictpath = /usr/local/mmseg3/etc/
42 charset_type = zh_cn.utf-8
43 stopwords = /usr/local/coreseek/etc/stopwords.txt
44 }
45
46 index news_news_delta:news_news
47 {
48 source = news_news_delta
49 path = /data/logs/coreseek/data/news_news_delta
50 }
51
52 #全局index定义
53 indexer
54 {
55 mem_limit = 128M
56 }
57
58 #searchd服务定义
59 searchd
60 {
61 listen = 9312
62 read_timeout = 5
63
64 max_children = 0
65
66 max_matches = 100000
67 seamless_rotate = 0
68 preopen_indexes = 0
69 unlink_old = 1
70 pid_file = /data/logs/coreseek/coreseek.pid #请修改为实际使用的绝对路径,例如:/usr/local/coresee k/var/...
71 log = /data/logs/coreseek/coreseek.log #请修改为实际使用的绝对路径,例如:/usr/local/corese ek/var/...
72 }