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

indexer
{
	mem_limit		= 128M
}

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}/index/binlog
}

source search_hash
{
	type			= mysql

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

	sql_query_pre   = UPDATE sph_counter SET max_doc_id=(SELECT MAX(id) FROM search_hash) where counter_id=1

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

	sql_query_pre   = SET NAMES utf8
	sql_query		= SELECT * from ( SELECT s1.id id, s1.name name, s1.category category, s1.length length, UNIX_TIMESTAMP(s1.create_time) as create_time, UNIX_TIMESTAMP(s1.last_seen) as last_seen, s2.file_list file_list, s1.info_hash info_hash FROM search_hash s1 left join search_filelist s2 on s1.info_hash=s2.info_hash where s1.is_has=1 and s1.id >= $start AND s1.id <= $end  ) as s WHERE s.file_list is not null
 
	sql_attr_bigint		= length
	sql_attr_timestamp	= create_time
	sql_attr_timestamp	= last_seen
	sql_attr_uint   = category
}

source search_hash_delta : search_hash
{
	sql_query_range = SELECT (SELECT max_doc_id FROM `sph_counter` where counter_id=1) as min, (SELECT max(id) FROM search_hash) as max
    sql_query_pre = SET NAMES utf8
    sql_query = SELECT * from ( SELECT s1.id id, s1.name name, s1.category category, s1.length length, UNIX_TIMESTAMP(s1.create_time) as create_time, UNIX_TIMESTAMP(s1.last_seen) as last_seen, s2.file_list file_list, s1.info_hash info_hash FROM search_hash s1 left join search_filelist s2 on s1.info_hash=s2.info_hash where s1.is_has=1 and s1.id >= $start AND s1.id <= $end  ) as s WHERE s.file_list is not null
    sql_attr_bigint		= length
	sql_attr_timestamp	= create_time
	sql_attr_timestamp	= last_seen
	sql_attr_uint   = category
	sql_query_post = UPDATE sph_counter SET max_doc_id=(SELECT MAX(id) FROM search_hash) where counter_id=1
}


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

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

index search_hash_delta : search_hash
{
	source			= search_hash_delta
	path			= {$SERVER_APP}/index/db/search_hash_delta/index

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