config sphinx

source src1
{
	type			= mysql

	sql_host		= localhost
	sql_user		= wp_niam_co_id
	sql_pass		= nAHdpi3MjyzegrB
	sql_db			= wp_niam_co_id
	sql_port		= 3306	# optional, default is 3306
	sql_sock		= /var/run/mysqld/mysqld.sock
	sql_query		= SELECT * FROM produk

	#sql_attr_uint		= group_id
	#sql_attr_timestamp	= date_added
}


index test1
{
	source			= src1
	path			= /var/lib/sphinxsearch/data/test1
	docinfo			= none
}

indexer
{
	mem_limit		= 512M
}


searchd
{
	listen			= 9312
	listen			= 9306:mysql41
	log			    = /var/log/sphinxsearch/searchd.log
	query_log		= /var/log/sphinxsearch/query.log
	read_timeout	= 5
	max_children	= 30
	pid_file		= /var/run/sphinxsearch/searchd.pid
	max_matches		= 1000
	seamless_rotate	= 1
	preopen_indexes	= 1
	unlink_old		= 1
	workers			= threads # for RT to work
	binlog_path		= /usr/local/var/data
	compat_sphinxql_magics = 0
}


/etc/default/sphinxsearch


/var/run/sphinxsearch/

killall -9 searchd

ps ax