sphinx使用篇

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