source source_content
{
type = mysql
sql_host = 192.168.20.140
sql_user = root
sql_pass = 123456
sql_db = test
sql_port = 3306 # optional, default is 3306
sql_query_pre = SET NAMES utf8
sql_query_pre = REPLACE INTO cmstop_search_counter SELECT 1, MAX(contentid) FROM cmstop_content
sql_query = SELECT f.contentid, f.content, s.catid, s.modelid, s.title, s.published, s.weight, s.url, s.comments, s.pv, IS_MOBILE(v.video, 0) as ismobile, 0 AS isdeleted \
FROM cmstop_search f \
LEFT JOIN cmstop_content s \
ON f.contentid=s.contentid \
LEFT JOIN cmstop_video v \
ON v.contentid=s.contentid \
WHERE s.status=6 AND s.contentid<=(SELECT max_doc_id FROM cmstop_search_counter WHERE counter_id=1 )\
#AND f.contentid >$start AND f.contentid <= $end
sql_attr_uint = catid
sql_attr_uint = modelid
sql_attr_uint = isdeleted
sql_attr_uint = weight
sql_attr_uint = ismobile
sql_attr_uint = comments
sql_attr_uint = pv
sql_attr_timestamp = published
sql_query_info = SELECT * FROM cmstop_content WHERE contentid=$id
}
index content
{
source = source_content
path = /usr/local/server/coreseek/var/data/content
docinfo = extern
min_word_len = 2
html_strip = 1
charset_type = zh_cn.utf-8
charset_dictpath = /usr/local/server/mmseg/etc/
#charset_table = 0..9, A..Z->a..z, _, a..z, U+410..U+42F->U+430..U+44F, U+430..U+44F
}
source source_addcontent : source_content
{
sql_query_pre = SET NAMES utf8
sql_query = SELECT f.contentid, f.content, s.catid, s.modelid, s.title, s.published, s.weight, s.url, s.comments, s.pv, IS_MOBILE(v.video, 0) as ismobile, 0 AS isdeleted \
FROM cmstop_search f \
LEFT JOIN cmstop_content s \
ON f.contentid=s.contentid \
LEFT JOIN cmstop_video v \
ON v.contentid=s.contentid \
WHERE s.status=6 AND s.contentid > (SELECT max_doc_id FROM cmstop_search_counter WHERE counter_id=1 )\
#AND f.contentid >$start AND f.contentid <= $end
}
index addcontent : content
{
source = source_addcontent
path = /usr/local/server/coreseek/var/data/addcontent
}
indexer
{
mem_limit = 512M
}
searchd
{
listen = 3312
log = /usr/local/server/coreseek/var/log/searchd.log
query_log = /usr/local/server/coreseek/var/log/query.log
read_timeout = 5
max_children = 30
pid_file = /usr/local/server/coreseek/var/searchd.pid
max_matches = 1000
seamless_rotate = 1
preopen_indexes = 0
unlink_old = 1
}
启动:
/usr/local/server/coreseek/bin/searchd
Coreseek Fulltext 3.2 [ Sphinx 0.9.9-release (r2117)]
Copyright (c) 2007-2011,
Beijing Choice Software Technologies Inc (http://www.coreseek.com)
using config file '/usr/local/server/coreseek/etc/csft.conf'...
listening on all interfaces, port=3312
rotating index 'addcontent': success
索引:
[root@SLTV-CMS-01 server]# /usr/local/server/coreseek/bin/indexer --all --rotate
Coreseek Fulltext 3.2 [ Sphinx 0.9.9-release (r2117)]
Copyright (c) 2007-2011,
Beijing Choice Software Technologies Inc (http://www.coreseek.com)
using config file '/usr/local/server/coreseek/etc/csft.conf'...
indexing index 'content'...
collected 59 docs, 0.1 MB
sorted 0.0 Mhits, 100.0% done
total 59 docs, 78514 bytes
total 0.060 sec, 1290351 bytes/sec, 969.64 docs/sec
indexing index 'addcontent'...
collected 0 docs, 0.0 MB
total 0 docs, 0 bytes
total 0.003 sec, 0 bytes/sec, 0.00 docs/sec
total 2 reads, 0.000 sec, 26.4 kb/call avg, 0.0 msec/call avg
total 11 writes, 0.000 sec, 12.6 kb/call avg, 0.0 msec/call avg
rotating indices: succesfully sent SIGHUP to searchd (pid=34216).
给mysql帐号权限:
mysql> grant all privileges on *.* to 'root'@'%' identified by 'sltv_2014@Sobey' with grant option;
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
http://219.232.239.243/uploads/pdf/sphinx_doc_zhcn_0.9.pdf
http://blog.chinaunix.net/uid-20639775-id-3261834.html
http://blog.csdn.net/bushizhuanjia/article/details/7626522
http://www.sphinxsearch.org/sphinx-tutorial