development.sphinx.conf

indexer
{
}

searchd
{
  listen = 127.0.0.1:9306:mysql41
  log = /var/www/tutorial/log/development.searchd.log
  query_log = /var/www/v/log/development.searchd.query.log
  pid_file = /var/www/tutorial/log/development.sphinx.pid
  workers = threads
  binlog_path = /var/www/tutorial/tmp/binlog/development
}

source realty_core_0
{
  type = mysql
  sql_host = localhost
  sql_user = user
  sql_pass = password
  sql_db = tutorial_dev
  sql_sock = /var/run/mysqld/mysqld.sock
  sql_query_pre = SET TIME_ZONE = '+0:00'
  sql_query_pre = SET NAMES utf8
  sql_query = /here goes incredible large query/
  sql_query_range = SELECT IFNULL(MIN(`objects`.`id`), 1), IFNULL(MAX(`objects`.`id`), 1) FROM `objects`
  sql_attr_uint = sphinx_internal_id
  sql_attr_uint = sphinx_deleted
  sql_attr_timestamp = created_at
  sql_attr_timestamp = updated_at
  sql_attr_string = sphinx_internal_class
  sql_field_string = adv_type
  sql_field_string = object_type
  sql_field_string = rooms_num
  sql_field_string = price
  sql_field_string = language
  sql_field_string = country
  sql_field_string = city
  sql_field_string = district
  sql_field_string = street
  sql_field_string = house
  sql_field_string = house_part
  sql_field_string = it_is_new
  sql_field_string = it_is_brick
  sql_field_string = full_size
  sql_field_string = living_size
  sql_field_string = citchen_size
  sql_field_string = floor
  sql_field_string = has_balcony
  sql_field_string = description
  sql_query_info = SELECT `objects`.* FROM `objects`  WHERE (`objects`.`id` = ($id - 0) / 2)
}

index realty_core
{
  type = plain
  path = /var/www/tutorial/db/sphinx/development/realty_core
  docinfo = extern
  mlock = 0
  min_stemming_len = 2
  min_word_len = 2
  min_infix_len = 1
  enable_star = 1
  source = realty_core_0
}

index realty
{
  type = distributed
  local = realty_core
}