indexer
{
	mem_limit		= 1024M
}

searchd
{
	#listen		= 9312
	listen		= 9306:mysql41
	log         = /usr/local/var/log/searchd.log
    #query_log       = /usr/local/var/log/query.log
	read_timeout	= 5
	max_children	= 50
	pid_file		= /usr/local/var/log/searchd.pid
	seamless_rotate	= 1
	#preopen_indexes	= 1
	unlink_old		= 1
	binlog_path		= /usr/local/var/data
}


# Для того чтобы добавить в сфинкс БД делаем следующее:
# Для каждой БД под обрезок добавляем следующую запись в файл /etc/sphinx/sphinx.conf (добавляем в самое начало)
# меняем значения которые записаны так  :value например sql_host = :value меняем на sql_host = localhost
> sudo mcedit /etc/sphinx/sphinx.conf

source DBConf
{
	type = mysql
	sql_host = localhost
	sql_user = lazy
	sql_pass = lolkek
	sql_db = huidb
	sql_query_pre   = SET NAMES utf8
}

source Vids : DBConf
{
	sql_query = \
	SELECT id, title, thumbnail, duration, categories, tags, original_thumbnail_url, views, UNIX_TIMESTAMP(created) as created \
	FROM vids
	sql_field_string = title
	sql_attr_string = thumbnail
	sql_attr_uint = duration
	sql_field_string = categories
	sql_attr_string = tags
	sql_attr_string = original_thumbnail_url
	sql_attr_uint = views
	sql_attr_timestamp = created
}

index VidsIndex
{
	type = plain
	source = Vids
	path = /usr/local/var/data/VidsIndexes
	#preopen = 1
	ondisk_attrs = 1
	morphology = stem_en
	docinfo	= extern
	min_word_len = 3
}

source Keys : DBConf
{
	sql_query = \
	SELECT id, title \
	FROM searches
	sql_field_string = title
}

index KeysIndex
{
	type = plain
	source = Keys
	path = /usr/local/var/data/KeysIndexes
	#preopen = 1
	ondisk_attrs = 1
	morphology = stem_en
	docinfo	= extern
	min_word_len = 3
}