indexer
{
}

searchd
{
  listen = 127.0.0.1:9312
  log = /home/vlad/ruby/humorial/log/searchd.log
  query_log = /home/vlad/ruby/humorial/log/searchd.query.log
  pid_file = /home/vlad/ruby/humorial/log/searchd.development.pid
}

source blog_core_0
{
  type = mysql
  sql_host = localhost
  sql_user = root
  sql_pass =
  sql_db = humorial_development
  sql_query_pre = SET NAMES utf8
  sql_query_pre = SET TIME_ZONE = '+0:00'
  sql_query = SELECT SQL_NO_CACHE `blogs`.`id` * CAST(3 AS SIGNED) + 0 AS `id` , `blogs`.`html_text` AS `html_text`, `blogs`.`short_descr` AS `short_descr`, `blogs`.`caption` AS `caption`, `blogs`.`id` AS `sphinx_internal_id`, 0 AS `sphinx_deleted`, 1613233789 AS `class_crc` FROM `blogs` WHERE (`blogs`.`id` >= $start AND `blogs`.`id` <= $end) GROUP BY `blogs`.`id`, `blogs`.`html_text`, `blogs`.`short_descr`, `blogs`.`caption`, `blogs`.`id` ORDER BY NULL
  sql_query_range = SELECT IFNULL(MIN(`id`), 1), IFNULL(MAX(`id`), 1) FROM `blogs`
  sql_attr_uint = sphinx_internal_id
  sql_attr_uint = sphinx_deleted
  sql_attr_uint = class_crc
  sql_query_info = SELECT * FROM `blogs` WHERE `id` = (($id - 0) / 3)
}

index blog_core
{
  source = blog_core_0
  path = /home/vlad/ruby/humorial/db/sphinx/development/blog_core
  charset_type = utf-8
}

index blog
{
  type = distributed
  local = blog_core
}

source blog_comment_core_0
{
  type = mysql
  sql_host = localhost
  sql_user = root
  sql_pass =
  sql_db = humorial_development
  sql_query_pre = SET NAMES utf8
  sql_query_pre = SET TIME_ZONE = '+0:00'
  sql_query = SELECT SQL_NO_CACHE `blog_comments`.`id` * CAST(3 AS SIGNED) + 1 AS `id` , `blog_comments`.`caption` AS `caption`, `blog_comments`.`text` AS `text`, `blog_comments`.`id` AS `sphinx_internal_id`, 0 AS `sphinx_deleted`, 2972296805 AS `class_crc` FROM `blog_comments` WHERE (`blog_comments`.`id` >= $start AND `blog_comments`.`id` <= $end) GROUP BY `blog_comments`.`id`, `blog_comments`.`caption`, `blog_comments`.`text`, `blog_comments`.`id` ORDER BY NULL
  sql_query_range = SELECT IFNULL(MIN(`id`), 1), IFNULL(MAX(`id`), 1) FROM `blog_comments`
  sql_attr_uint = sphinx_internal_id
  sql_attr_uint = sphinx_deleted
  sql_attr_uint = class_crc
  sql_query_info = SELECT * FROM `blog_comments` WHERE `id` = (($id - 1) / 3)
}

index blog_comment_core
{
  source = blog_comment_core_0
  path = /home/vlad/ruby/humorial/db/sphinx/development/blog_comment_core
  charset_type = utf-8
}

index blog_comment
{
  type = distributed
  local = blog_comment_core
}

source matherial_core_0
{
  type = mysql
  sql_host = localhost
  sql_user = root
  sql_pass =
  sql_db = humorial_development
  sql_query_pre = SET NAMES utf8
  sql_query_pre = SET TIME_ZONE = '+0:00'
  sql_query = SELECT SQL_NO_CACHE `matherials`.`id` * CAST(3 AS SIGNED) + 2 AS `id` , `matherials`.`body` AS `body`, `matherials`.`phrase` AS `phrase`, `matherials`.`id` AS `sphinx_internal_id`, 0 AS `sphinx_deleted`, 3323281092 AS `class_crc` FROM `matherials` WHERE (`matherials`.`id` >= $start AND `matherials`.`id` <= $end) GROUP BY `matherials`.`id`, `matherials`.`body`, `matherials`.`phrase`, `matherials`.`id` ORDER BY NULL
  sql_query_range = SELECT IFNULL(MIN(`id`), 1), IFNULL(MAX(`id`), 1) FROM `matherials`
  sql_attr_uint = sphinx_internal_id
  sql_attr_uint = sphinx_deleted
  sql_attr_uint = class_crc
  sql_query_info = SELECT * FROM `matherials` WHERE `id` = (($id - 2) / 3)
}

index matherial_core
{
  source = matherial_core_0
  path = /home/vlad/ruby/humorial/db/sphinx/development/matherial_core
  charset_type = utf-8
}

index matherial
{
  type = distributed
  local = matherial_core
}