Everything is on the same server. Bases mySql and indexes Sphinx on different disks, both SSD. If you need any more data I will provide.
I use these settings:
source src1
{
type = mysql
sql_host = localhost
sql_user =
sql_pass =
sql_db =
sql_port = 3306 # optional, default is 3306
# Установим кодировку для работы с БД
sql_query_pre = SET NAMES utf8
sql_query_pre = SET CHARACTER SET utf8
sql_query = \
SELECT prod_search_index.id, prod_search_index.shop, prod_search_index.category, prod_search_index.prise, prod_search_index.brand,prod_search_index.name_ru,prod_search_index.active,prod_search_index.moto, \
IF(`prod_search_index`.`shop`!=1,1 , 0) AS `belbd`\
FROM prod_search_index \
sql_attr_uint = shop
sql_attr_uint = category
sql_attr_uint = prise
sql_attr_uint = brand
sql_attr_uint = active
sql_attr_uint = moto
sql_attr_uint = belbd
sql_attr_multi = uint folder from ranged-query; \
SELECT `prod`, `folder` \
FROM `in_folders` \
WHERE `id`>=$start AND `id`<$end; \
SELECT MIN(`id`), MAX(`id`) FROM `in_folders`
#sql_ranged_throttle = 200
}
index izap_prod_search_index
{
source = src1
path = /var/www/siriusit/data/sphinxdata/indexes/izap_prod_search_index
mlock = 0
morphology = stem_ru
min_word_len = 1
}
index izap_prod_search_index_rt
{
type = rt
rt_mem_limit = 128M
path = /var/www/siriusit/data/sphinxdata/indexes/izap_prod_search_index_rt
rt_field = name_ru
rt_attr_uint = shop
rt_attr_uint = category
rt_attr_uint = prise
rt_attr_uint = brand
rt_attr_uint = active
rt_attr_uint = moto
rt_attr_uint = belbd
}
index izap_prod_search
{
type = distributed
local = izap_prod_search_index
local = izap_prod_search_index_rt
}
indexer
{
mem_limit = 128M
}
searchd
{
listen = 9312
listen = 9306:mysql41
log = /var/www/siriusit/data/sphinxdata/logs/searchd.log
query_log = /var/www/siriusit/data/sphinxdata/logs/query.log
read_timeout = 5
max_children = 30
pid_file = /var/www/siriusit/data/sphinxdata/searchd.pid
seamless_rotate = 1
preopen_indexes = 1
unlink_old = 1
workers = threads # for RT to work
binlog_path = /var/www/siriusit/data/sphinxdata/binlogs
}