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

indexer
{
	mem_limit		= 32M
}

searchd
{
	listen			= 9312
	listen			= 9306:mysql41
	log				= {$SERVER_APP}/index/searchd.log
	query_log		= {$SERVER_APP}/index/query.log
	read_timeout	= 5
	max_children	= 0
	pid_file		= {$SERVER_APP}/index/searchd.pid
	seamless_rotate	= 1
	preopen_indexes	= 1
	unlink_old		= 1
	#workers		= threads # for RT to work
	binlog_path		= {$SERVER_APP}/binlog
}

source sp_video
{
	type			= mysql

	sql_host		= 127.0.0.1
	sql_user		= video_spider
	sql_pass		= video_spider
	sql_db			= video_spider
	sql_port		= 3306	# optional, default is 3306

	sql_query_range = SELECT min(id), max(id) FROM sp_video
    sql_range_step = 1000

	sql_query_pre       = SET NAMES utf8
	sql_query		= SELECT id, name, UNIX_TIMESTAMP(create_time) AS create_time, UNIX_TIMESTAMP(update_time) AS update_time \
		FROM sp_video where id >= $start AND id <= $end
 
	sql_attr_bigint		= length
	sql_attr_timestamp	= create_time
	sql_attr_timestamp	= update_time
	sql_attr_uint   = category

}


index sp_video
{
	source			= sp_video
	path			= {$SERVER_APP}/index/db/sp_video/index

    ngram_len = 1
    ngram_chars = U+3000..U+2FA1F
}