sphinx.conf

#
# Minimal Sphinx configuration sample (clean, simple, functional)
#

source yii2_test_article_src
{
	type			= mysql

	sql_host		= localhost
	sql_user		=
	sql_pass		=
	sql_db			= yii2test
	sql_port		= 3306	# optional, default is 3306

	sql_query		= \
		SELECT *, UNIX_TIMESTAMP(create_date) AS add_date \
		FROM yii2_test_article

	sql_attr_uint		= id
	sql_attr_uint		= author_id
	sql_attr_timestamp	= add_date

	sql_query_info		= SELECT * FROM yii2_test_article WHERE id=$id
}


source yii2_test_item_src
{
	type			= mysql

	sql_host		= localhost
	sql_user		=
	sql_pass		=
	sql_db			= yii2test
	sql_port		= 3306	# optional, default is 3306

	sql_query		= \
		SELECT *, CURRENT_TIMESTAMP() AS add_date \
		FROM yii2_test_item

	sql_attr_uint		= id
	sql_attr_uint		= category_id
	sql_attr_float		= price
	sql_attr_timestamp	= add_date

	sql_query_info		= SELECT * FROM yii2_test_item WHERE id=$id
}


index yii2_test_article_index
{
	source			= yii2_test_article_src
	path			= /var/lib/sphinx/yii2_test_article_src
	docinfo			= extern
	charset_type	= sbcs
}


index yii2_test_item_index
{
	source			= yii2_test_item_src
	path			= /var/lib/sphinx/yii2_test_item_src
	docinfo			= extern
	charset_type	= sbcs
}


indexer
{
	mem_limit		= 32M
}


searchd
{
	listen			= 127.0.0.1:9312
	listen			= 9306:mysql41
	log				= /var/log/sphinx/searchd.log
	query_log		= /var/log/sphinx/query.log
	read_timeout	= 5
	max_children	= 30
	pid_file		= /var/run/sphinx/searchd.pid
	max_matches		= 1000
	seamless_rotate	= 1
	preopen_indexes	= 1
	unlink_old		= 1
	workers			= threads # for RT to work
	binlog_path		= /var/lib/sphinx
}