Advertisement
Guest User

Thinking Sphinx generated configuration file

a guest
Oct 5th, 2011
361
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. indexer
  2. {
  3. }
  4.  
  5. searchd
  6. {
  7.   listen = 127.0.0.1:9312
  8.   log = /home/zequez/projects/ruby/1/log/searchd.log
  9.   query_log = /home/zequez/projects/ruby/1/log/searchd.query.log
  10.   pid_file = /home/zequez/projects/ruby/1/log/searchd.development.pid
  11. }
  12.  
  13. source cimg_core_0
  14. {
  15.   type = mysql
  16.   sql_host = localhost
  17.   sql_user = root
  18.   sql_pass =
  19.   sql_db = p1_development
  20.   sql_sock = /var/run/mysqld/mysqld.sock
  21.   sql_query_pre = UPDATE `cimgs` SET `delta` = 0 WHERE `delta` = 1
  22.   sql_query_pre = SET NAMES utf8
  23.   sql_query_pre = SET TIME_ZONE = '+0:00'
  24.   sql_query = SELECT SQL_NO_CACHE `cimgs`.`id` * CAST(1 AS SIGNED) + 0 AS `id` , `cimgs`.`search_cache` AS `search_cache`, `cimgs`.`id` AS `sphinx_internal_id`, 0 AS `sphinx_deleted`, 3966122353 AS `class_crc`, `cimgs`.`approved` AS `approved` FROM `cimgs`  WHERE (`cimgs`.`id` >= $start AND `cimgs`.`id` <= $end AND `cimgs`.`delta` = 0) GROUP BY `cimgs`.`id` ORDER BY NULL
  25.   sql_query_range = SELECT IFNULL(MIN(`id`), 1), IFNULL(MAX(`id`), 1) FROM `cimgs` WHERE `cimgs`.`delta` = 0
  26.   sql_attr_uint = sphinx_internal_id
  27.   sql_attr_uint = sphinx_deleted
  28.   sql_attr_uint = class_crc
  29.   sql_attr_bool = approved
  30.   sql_query_info = SELECT * FROM `cimgs` WHERE `id` = (($id - 0) / 1)
  31. }
  32.  
  33. index cimg_core
  34. {
  35.   source = cimg_core_0
  36.   path = /home/zequez/projects/ruby/1/db/sphinx/development/cimg_core
  37.   charset_type = utf-8
  38. }
  39.  
  40. source cimg_delta_0 : cimg_core_0
  41. {
  42.   type = mysql
  43.   sql_host = localhost
  44.   sql_user = root
  45.   sql_pass =
  46.   sql_db = p1_development
  47.   sql_sock = /var/run/mysqld/mysqld.sock
  48.   sql_query_pre =
  49.   sql_query_pre = SET NAMES utf8
  50.   sql_query_pre = SET TIME_ZONE = '+0:00'
  51.   sql_query = SELECT SQL_NO_CACHE `cimgs`.`id` * CAST(1 AS SIGNED) + 0 AS `id` , `cimgs`.`search_cache` AS `search_cache`, `cimgs`.`id` AS `sphinx_internal_id`, 0 AS `sphinx_deleted`, 3966122353 AS `class_crc`, `cimgs`.`approved` AS `approved` FROM `cimgs`  WHERE (`cimgs`.`id` >= $start AND `cimgs`.`id` <= $end AND `cimgs`.`delta` = 1) GROUP BY `cimgs`.`id` ORDER BY NULL
  52.   sql_query_range = SELECT IFNULL(MIN(`id`), 1), IFNULL(MAX(`id`), 1) FROM `cimgs` WHERE `cimgs`.`delta` = 1
  53.   sql_attr_uint = sphinx_internal_id
  54.   sql_attr_uint = sphinx_deleted
  55.   sql_attr_uint = class_crc
  56.   sql_attr_bool = approved
  57.   sql_query_info = SELECT * FROM `cimgs` WHERE `id` = (($id - 0) / 1)
  58. }
  59.  
  60. index cimg_delta : cimg_core
  61. {
  62.   source = cimg_delta_0
  63.   path = /home/zequez/projects/ruby/1/db/sphinx/development/cimg_delta
  64. }
  65.  
  66. index cimg
  67. {
  68.   type = distributed
  69.   local = cimg_delta
  70.   local = cimg_core
  71. }
  72.  
  73.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement