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


source catalog
{
	type			= mysql

	sql_host		= localhost
	sql_user		= ***
	sql_pass		= ***
	sql_db			= ***
	sql_port		= 3306	# optional, default is 3306
	sql_query_pre = SET NAMES utf8
	sql_query		= \
		SELECT `p`.`id` AS id, `pv`.`value` AS `title`, `pv1`.`value` AS `article` FROM `products` AS `p` \
		LEFT JOIN `properties_values` AS `pv` ON pv.product_id = p.id \
		LEFT JOIN `properties_values` AS `pv1` ON pv1.product_id = p.id WHERE (pv.property_id = '00000000-0000-0000-0000-000000000001') \
		AND (pv1.property_id = '00000000-0000-0000-0000-000000000002') AND (p.deleted = 0) AND (p.active = 1) GROUP BY `p`.`id`


	#sql_attr_uint		= group_id
	#sql_attr_timestamp	= date_added
	sql_field_string = title
	#sql_field_string = article

	#sql_query_info		= SELECT * FROM documents WHERE id=$id
}


index catalog_index {
	source = catalog
	path = /etc/sphinx/data/catalog
	morphology = stem_ru
	min_word_len = 3
	charset_type = utf-8
}


indexer
{
	mem_limit		= 256M
}


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		=

    # какой порт и какой протокол "слушает" служба
    listen            = 9312

    # файл с логами
    log            = /var/log/sphinx/searchd.log

    # файл с логами поисковых запросов
    query_log        = /var/log/sphinx/query.log

    # PID file, searchd process ID file name
    # mandatory
    pid_file        = /var/run/sphinx/searchd.pid
}