alevel_project/sphinx-3.0.2/copy/etc/sphinx-min.conf.dist

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

source connection
{
	type			= mysql

	sql_host		= localhost
	sql_user		= root
	sql_pass		=
	sql_db			= awlex
	sql_port		= 3306	# optional, default is 3306
    #sql_query_pre   = utf8
}


source items : connection {
	sql_query		= \
        SELECT id, caption, description FROM items

	sql_attr_uint       = id
	sql_field_string    = caption
	sql_field_string    = description
}


index items_index {
	source			= items
	path			= storage/sphinx/data/items

	morphology      = lemmatize_ru_all
	ignore_chars    = U+AD
	blend_chars     = +, &, U+23
	blend_mode      = trim_tail, skip_pure
	charset_table   = 0..9, A..Z->a..z, _, a..z, U+410..U+42F->U+430..U+44F, U+401->U+0435, U+451->U+0435
	min_infix_len   = 2
}

common {
    lemmatizer_base = sphinx-3.0.2/dict
}

indexer
{
	mem_limit		    = 128M
	lemmatizer_cache    = 256M # cache it all
}

searchd
{
	#listen			= 127.0.0.1:9312
	listen			= 127.0.0.1:9306:mysql41
	log			    = storage\\sphinx\\log\\searchd.log
	query_log		= storage\\sphinx\\log\\query.log
	binlog_path		= storage\\sphinx\\log
	pid_file		= storage\\sphinx\\log\\searchd.pid
	seamless_rotate	= 1
	preopen_indexes	= 1
	unlink_old		= 1
	read_timeout	= 5
    max_children	= 10
	workers			= threads # for RT to work
	#client_timeout  = 3600
}