gistfile1.txt

indexer
{
}

searchd
{
  address = 127.0.0.1
  port = 3312
  log = /var/www/staging/project/releases/20090806051452/log/searchd.log
  query_log = /var/www/staging/project/releases/20090806051452/log/searchd.query.log
  pid_file = /var/www/staging/project/releases/20090806051452/log/searchd.staging.pid
}

source part_description_core_0
{
  type = mysql
  sql_host = localhost
  sql_user = ***
  sql_pass = ***
  sql_db = staging
  sql_sock = /var/run/mysqld/mysqld.sock
  sql_query_pre = SET NAMES utf8
  sql_query = SELECT `part_descriptions`.`id` * 1 + 0 AS `id` , CAST(`part_descriptions`.`name` AS CHAR) AS `name`, `part_descriptions`.`id` AS `sphinx_internal_id`, 897811667 AS `class_crc`, '897811667' AS `subclass_crcs`, 0 AS `sphinx_deleted` FROM `part_descriptions`    WHERE `part_descriptions`.`id` >= $start AND `part_descriptions`.`id` <= $end GROUP BY `part_descriptions`.`id`  ORDER BY NULL
  sql_query_range = SELECT IFNULL(MIN(`id`), 1), IFNULL(MAX(`id`), 1) FROM `part_descriptions` 
  sql_attr_uint = sphinx_internal_id
  sql_attr_uint = class_crc
  sql_attr_uint = sphinx_deleted
  sql_attr_multi = uint subclass_crcs from field
  sql_query_info = SELECT * FROM `part_descriptions` WHERE `id` = (($id - 0) / 1)
}

index part_description_core
{
  source = part_description_core_0
  path = /var/www/staging/project/shared/db/sphinx/staging/part_description_core
  charset_type = utf-8
}

index part_description
{
  type = distributed
  local = part_description_core
}