source base
{
	type			= mysql
 
	sql_host		= localhost
	sql_user		= root
	sql_pass		= password
	sql_db			= phpclub
	sql_port		= 3306	# optional, default is 3306
 
	sql_query_pre		= SET NAMES utf8
}
 
source src_posts: base
{
	sql_query		= \
		SELECT post, thread, comment, date, email, name, subject \
		FROM posts
}
 
 
index index_posts
{
	source			= src_posts
	path			= /var/lib/sphinxsearch/data/src_posts
 
	morphology		= stem_ru, stem_en
}
 
 
indexer
{
	mem_limit		= 128M
}
 
 
searchd
{
	listen			= 9312
	listen			= 9306:mysql41
	log			= /var/lib/sphinxsearch/log/searchd.log
	query_log		= /var/lib/sphinxsearch/log/query.log
	read_timeout		= 5
	max_children		= 30
	pid_file		= /var/run/sphinxsearch/searchd.pid
	seamless_rotate		= 1
	preopen_indexes		= 1
	unlink_old		= 1
	workers			= threads # for RT to work
	binlog_path		= /var/lib/sphinxsearch/data
}
 

c291cmNlIGJhc2UKewoJdHlwZQkJCT0gbXlzcWwKCglzcWxfaG9zdAkJPSBsb2NhbGhvc3QKCXNxbF91c2VyCQk9IHJvb3QKCXNxbF9wYXNzCQk9IHBhc3N3b3JkCglzcWxfZGIJCQk9IHBocGNsdWIKCXNxbF9wb3J0CQk9IDMzMDYJIyBvcHRpb25hbCwgZGVmYXVsdCBpcyAzMzA2CgoJc3FsX3F1ZXJ5X3ByZQkJPSBTRVQgTkFNRVMgdXRmOAp9Cgpzb3VyY2Ugc3JjX3Bvc3RzOiBiYXNlCnsKCXNxbF9xdWVyeQkJPSBcCgkJU0VMRUNUIHBvc3QsIHRocmVhZCwgY29tbWVudCwgZGF0ZSwgZW1haWwsIG5hbWUsIHN1YmplY3QgXAoJCUZST00gcG9zdHMKfQoKCmluZGV4IGluZGV4X3Bvc3RzCnsKCXNvdXJjZQkJCT0gc3JjX3Bvc3RzCglwYXRoCQkJPSAvdmFyL2xpYi9zcGhpbnhzZWFyY2gvZGF0YS9zcmNfcG9zdHMKCgltb3JwaG9sb2d5CQk9IHN0ZW1fcnUsIHN0ZW1fZW4KfQoKCmluZGV4ZXIKewoJbWVtX2xpbWl0CQk9IDEyOE0KfQoKCnNlYXJjaGQKewoJbGlzdGVuCQkJPSA5MzEyCglsaXN0ZW4JCQk9IDkzMDY6bXlzcWw0MQoJbG9nCQkJPSAvdmFyL2xpYi9zcGhpbnhzZWFyY2gvbG9nL3NlYXJjaGQubG9nCglxdWVyeV9sb2cJCT0gL3Zhci9saWIvc3BoaW54c2VhcmNoL2xvZy9xdWVyeS5sb2cKCXJlYWRfdGltZW91dAkJPSA1CgltYXhfY2hpbGRyZW4JCT0gMzAKCXBpZF9maWxlCQk9IC92YXIvcnVuL3NwaGlueHNlYXJjaC9zZWFyY2hkLnBpZAoJc2VhbWxlc3Nfcm90YXRlCQk9IDEKCXByZW9wZW5faW5kZXhlcwkJPSAxCgl1bmxpbmtfb2xkCQk9IDEKCXdvcmtlcnMJCQk9IHRocmVhZHMgIyBmb3IgUlQgdG8gd29yawoJYmlubG9nX3BhdGgJCT0gL3Zhci9saWIvc3BoaW54c2VhcmNoL2RhdGEKfQo=