sphinx.conf

做搜索的

source src1
{
	type				= mysql
	sql_host			= localhost
	sql_user			= root
	sql_pass			=
	sql_db				= sphinx_test
	sql_port			= 3306	# optional, default is 3306

	sql_query			= SELECT id, name, description, UNIX_TIMESTAMP(created_at) AS created_at, group_id, rating FROM links
	sql_attr_uint		= group_id
	sql_attr_timestamp	= created_at
	sql_attr_float		= rating
	sql_attr_multi		= uint tags from query; SELECT link_id, tag_id FROM links_tags
	sql_query_info		= SELECT * FROM links WHERE id=$id
}

source src2
{
	type				= mysql
	sql_host			= localhost
	sql_user			= root
	sql_pass			=
	sql_db				= sphinx_test
	sql_port			= 3306	# optional, default is 3306

	sql_query			= SELECT id, name, description, UNIX_TIMESTAMP(created_at) AS created_at, group_id FROM links64
	sql_attr_uint		= group_id
	sql_attr_timestamp	= created_at
	sql_query_info		= SELECT * FROM links WHERE id=$id
}

index test1
{
	source				= src1
	path				= e:/work/_sandbox/sphinx/data/test1
	docinfo				= extern
	morphology			= none
	stopwords			=
	charset_type		= utf-8
}

index test2
{
	source				= src2
	path				= e:/work/_sandbox/sphinx/data/test2
	docinfo				= extern
	morphology			= none
	stopwords			=
	charset_type		= utf-8
}

indexer
{
	mem_limit			= 32M
}

searchd
{
	port				= 3312
	log					= e:/work/_sandbox/sphinx/log/searchd.log
	query_log			= e:/work/_sandbox/sphinx/log/query.log
	read_timeout		= 5
	max_children		= 30
	pid_file			= e:/work/_sandbox/sphinx/log/searchd.pid
	max_matches			= 1000
}