gistfile1.txt

indexer
{
}

searchd
{
  listen = localhost:9312
  listen = localhost:9306:mysql41
  log = /var/www/projects/projectx/releases/92f8fef9a72f0a3d2f1f669c9c94b3c983dd2e53/log/searchd.log
  query_log = /var/www/projects/projectx/releases/92f8fef9a72f0a3d2f1f669c9c94b3c983dd2e53/log/searchd.query.log
  pid_file = /var/www/projects/projectx/releases/92f8fef9a72f0a3d2f1f669c9c94b3c983dd2e53/log/searchd.production.pid
}

source voteled_core_0
{
  type = mysql
  sql_host = votebash-db.c8o8dc5ahkum.us-east-1.rds.amazonaws.com
  sql_user = root
  sql_pass = Rd5my591v07eB45hr007p455
  sql_db = Project_production
  sql_port = 3306
  sql_query_pre = SET NAMES utf8
  sql_query_pre = SET TIME_ZONE = '+0:00'
  sql_query = SELECT SQL_NO_CACHE `voteleds`.`id` * CAST(1 AS SIGNED) + 0 AS `id` , `questions`.`question_text` AS `question_title`, `voteleds`.`author` AS `author`, `voteleds`.`publish_status` AS `publish_status`, `voteleds`.`popularity` AS `popularity`, `voteleds`.`id` AS `sphinx_internal_id`, 0 AS `sphinx_deleted`, 939128741 AS `class_crc`, IFNULL('Voteled', '') AS `sphinx_internal_class`, IFNULL(`voteleds`.`popularity`, '') AS `popularity_sort` FROM `voteleds`    LEFT OUTER JOIN `questions` ON questions.voteled_id = voteleds.id  WHERE `voteleds`.`id` >= $start AND `voteleds`.`id` <= $end GROUP BY `voteleds`.`id`  ORDER BY NULL
  sql_query_range = SELECT IFNULL(MIN(`id`), 1), IFNULL(MAX(`id`), 1) FROM `voteleds`
  sql_attr_uint = sphinx_internal_id
  sql_attr_uint = sphinx_deleted
  sql_attr_uint = class_crc
  sql_attr_string = sphinx_internal_class
  sql_attr_string = popularity_sort
  sql_query_info = SELECT * FROM `voteleds` WHERE `id` = (($id - 0) / 1)
}

index voteled_core
{
  path = /var/www/projects/projectx/releases/92f8fef9a72f0a3d2f1f669c9c94b3c983dd2e53/db/sphinx/production/voteled_core
  charset_type = utf-8
  source = voteled_core_0
}

index voteled
{
  type = distributed
  local = voteled_core
}