API tools faq
paste
Guest User

Untitled

a guest
Mar 12th, 2018
97
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 11.03 KB | None | 0 0
raw download clone embed print report
  1. indexer
  2. {
  3. }
  4.  
  5. searchd
  6. {
  7. address = 127.0.0.1
  8. port = 3312
  9. log = /Users/flip/ics/koko/log/searchd.log
  10. query_log = /Users/flip/ics/koko/log/searchd.query.log
  11. pid_file = /Users/flip/ics/koko/log/searchd.development.pid
  12. }
  13.  
  14. source category_core_0
  15. {
  16. type = mysql
  17. sql_host = localhost
  18. sql_user = imw
  19. sql_pass = local_pass_14_312
  20. sql_db = imw_koko_dev
  21. sql_port = 9696
  22. sql_query_pre = UPDATE `categories` SET `delta` = 0 WHERE `delta` = 1
  23. sql_query_pre = SET NAMES utf8
  24. sql_query = SELECT `categories`.`id` * 7 + 0 AS `id` , CAST(`categories`.`title` AS CHAR) AS `title`, `categories`.`id` AS `sphinx_internal_id`, 4282022807 AS `class_crc`, '4282022807' AS `subclass_crcs`, 0 AS `sphinx_deleted`, IFNULL(`categories`.`title`, '') AS `title_sort`, UNIX_TIMESTAMP(`categories`.`created_at`) AS `created_at`, UNIX_TIMESTAMP(`categories`.`updated_at`) AS `updated_at`, `categories`.`datasets_count` AS `datasets_count` FROM `categories` WHERE `categories`.`id` >= $start AND `categories`.`id` <= $end AND `categories`.`delta` = 0 GROUP BY `categories`.`id` ORDER BY NULL
  25. sql_query_range = SELECT IFNULL(MIN(`id`), 1), IFNULL(MAX(`id`), 1) FROM `categories` WHERE `categories`.`delta` = 0
  26. sql_attr_uint = sphinx_internal_id
  27. sql_attr_uint = class_crc
  28. sql_attr_uint = sphinx_deleted
  29. sql_attr_uint = datasets_count
  30. sql_attr_timestamp = created_at
  31. sql_attr_timestamp = updated_at
  32. sql_attr_str2ordinal = title_sort
  33. sql_attr_multi = uint subclass_crcs from field
  34. sql_query_info = SELECT * FROM `categories` WHERE `id` = (($id - 0) / 7)
  35. }
  36.  
  37. index category_core
  38. {
  39. source = category_core_0
  40. path = /Users/flip/ics/koko/db/sphinx/development/category_core
  41. morphology = stem_en
  42. charset_type = utf-8
  43. min_infix_len = 3
  44. enable_star = 1
  45. }
  46.  
  47. source category_delta_0 : category_core_0
  48. {
  49. type = mysql
  50. sql_host = localhost
  51. sql_user = imw
  52. sql_pass = local_pass_14_312
  53. sql_db = imw_koko_dev
  54. sql_port = 9696
  55. sql_query_pre =
  56. sql_query_pre = SET NAMES utf8
  57. sql_query = SELECT `categories`.`id` * 7 + 0 AS `id` , CAST(`categories`.`title` AS CHAR) AS `title`, `categories`.`id` AS `sphinx_internal_id`, 4282022807 AS `class_crc`, '4282022807' AS `subclass_crcs`, 0 AS `sphinx_deleted`, IFNULL(`categories`.`title`, '') AS `title_sort`, UNIX_TIMESTAMP(`categories`.`created_at`) AS `created_at`, UNIX_TIMESTAMP(`categories`.`updated_at`) AS `updated_at`, `categories`.`datasets_count` AS `datasets_count` FROM `categories` WHERE `categories`.`id` >= $start AND `categories`.`id` <= $end AND `categories`.`delta` = 1 GROUP BY `categories`.`id` ORDER BY NULL
  58. sql_query_range = SELECT IFNULL(MIN(`id`), 1), IFNULL(MAX(`id`), 1) FROM `categories` WHERE `categories`.`delta` = 1
  59. sql_attr_uint = sphinx_internal_id
  60. sql_attr_uint = class_crc
  61. sql_attr_uint = sphinx_deleted
  62. sql_attr_uint = datasets_count
  63. sql_attr_timestamp = created_at
  64. sql_attr_timestamp = updated_at
  65. sql_attr_str2ordinal = title_sort
  66. sql_attr_multi = uint subclass_crcs from field
  67. sql_query_info = SELECT * FROM `categories` WHERE `id` = (($id - 0) / 7)
  68. }
  69.  
  70. index category_delta : category_core
  71. {
  72. source = category_delta_0
  73. path = /Users/flip/ics/koko/db/sphinx/development/category_delta
  74. }
  75.  
  76. index category
  77. {
  78. type = distributed
  79. local = category_delta
  80. local = category_core
  81. }
  82.  
  83. source note_core_0
  84. {
  85. type = mysql
  86. sql_host = localhost
  87. sql_user = imw
  88. sql_pass = local_pass_14_312
  89. sql_db = imw_koko_dev
  90. sql_port = 9696
  91. sql_query_pre = SET NAMES utf8
  92. sql_query = SELECT `notes`.`id` * 7 + 1 AS `id` , CAST(`notes`.`title` AS CHAR) AS `title`, CAST(`notes`.`body` AS CHAR) AS `body`, `notes`.`id` AS `sphinx_internal_id`, 1871664426 AS `class_crc`, '1871664426' AS `subclass_crcs`, 0 AS `sphinx_deleted`, IFNULL(`notes`.`title`, '') AS `title_sort`, UNIX_TIMESTAMP(`notes`.`created_at`) AS `created_at`, UNIX_TIMESTAMP(`notes`.`updated_at`) AS `updated_at` FROM `notes` WHERE `notes`.`id` >= $start AND `notes`.`id` <= $end GROUP BY `notes`.`id` ORDER BY NULL
  93. sql_query_range = SELECT IFNULL(MIN(`id`), 1), IFNULL(MAX(`id`), 1) FROM `notes`
  94. sql_attr_uint = sphinx_internal_id
  95. sql_attr_uint = class_crc
  96. sql_attr_uint = sphinx_deleted
  97. sql_attr_timestamp = created_at
  98. sql_attr_timestamp = updated_at
  99. sql_attr_str2ordinal = title_sort
  100. sql_attr_multi = uint subclass_crcs from field
  101. sql_query_info = SELECT * FROM `notes` WHERE `id` = (($id - 1) / 7)
  102. }
  103.  
  104. index note_core
  105. {
  106. source = note_core_0
  107. path = /Users/flip/ics/koko/db/sphinx/development/note_core
  108. morphology = stem_en
  109. charset_type = utf-8
  110. min_infix_len = 3
  111. enable_star = 1
  112. }
  113.  
  114. index note
  115. {
  116. type = distributed
  117. local = note_core
  118. }
  119.  
  120. source collection_core_0
  121. {
  122. type = mysql
  123. sql_host = localhost
  124. sql_user = imw
  125. sql_pass = local_pass_14_312
  126. sql_db = imw_koko_dev
  127. sql_port = 9696
  128. sql_query_pre = UPDATE `collections` SET `delta` = 0 WHERE `delta` = 1
  129. sql_query_pre = SET NAMES utf8
  130. sql_query = SELECT `collections`.`id` * 7 + 2 AS `id` , CAST(`collections`.`title` AS CHAR) AS `title`, CAST(GROUP_CONCAT(DISTINCT `slugs`.`name` SEPARATOR ' ') AS CHAR) AS `name`, CAST(GROUP_CONCAT(DISTINCT `notes`.`body` SEPARATOR ' ') AS CHAR) AS `body`, `collections`.`id` AS `sphinx_internal_id`, 3004196578 AS `class_crc`, '3004196578' AS `subclass_crcs`, 0 AS `sphinx_deleted`, IFNULL(`collections`.`title`, '') AS `title_sort`, UNIX_TIMESTAMP(`collections`.`created_at`) AS `created_at`, UNIX_TIMESTAMP(`collections`.`updated_at`) AS `updated_at` FROM `collections` LEFT OUTER JOIN `slugs` ON `slugs`.sluggable_id = `collections`.id AND `slugs`.sluggable_type = 'Collection' LEFT OUTER JOIN `notes` ON `notes`.item_id = `collections`.id AND `notes`.item_type = 'Collection' WHERE `collections`.`id` >= $start AND `collections`.`id` <= $end AND `collections`.`delta` = 0 GROUP BY `collections`.`id` ORDER BY NULL
  131. sql_query_range = SELECT IFNULL(MIN(`id`), 1), IFNULL(MAX(`id`), 1) FROM `collections` WHERE `collections`.`delta` = 0
  132. sql_attr_uint = sphinx_internal_id
  133. sql_attr_uint = class_crc
  134. sql_attr_uint = sphinx_deleted
  135. sql_attr_timestamp = created_at
  136. sql_attr_timestamp = updated_at
  137. sql_attr_str2ordinal = title_sort
  138. sql_attr_multi = uint subclass_crcs from field
  139. sql_query_info = SELECT * FROM `collections` WHERE `id` = (($id - 2) / 7)
  140. }
  141.  
  142. index collection_core
  143. {
  144. source = collection_core_0
  145. path = /Users/flip/ics/koko/db/sphinx/development/collection_core
  146. morphology = stem_en
  147. charset_type = utf-8
  148. min_infix_len = 3
  149. enable_star = 1
  150. }
  151.  
  152. source collection_delta_0 : collection_core_0
  153. {
  154. type = mysql
  155. sql_host = localhost
  156. sql_user = imw
  157. sql_pass = local_pass_14_312
  158. sql_db = imw_koko_dev
  159. sql_port = 9696
  160. sql_query_pre =
  161. sql_query_pre = SET NAMES utf8
  162. sql_query = SELECT `collections`.`id` * 7 + 2 AS `id` , CAST(`collections`.`title` AS CHAR) AS `title`, CAST(GROUP_CONCAT(DISTINCT `slugs`.`name` SEPARATOR ' ') AS CHAR) AS `name`, CAST(GROUP_CONCAT(DISTINCT `notes`.`body` SEPARATOR ' ') AS CHAR) AS `body`, `collections`.`id` AS `sphinx_internal_id`, 3004196578 AS `class_crc`, '3004196578' AS `subclass_crcs`, 0 AS `sphinx_deleted`, IFNULL(`collections`.`title`, '') AS `title_sort`, UNIX_TIMESTAMP(`collections`.`created_at`) AS `created_at`, UNIX_TIMESTAMP(`collections`.`updated_at`) AS `updated_at` FROM `collections` LEFT OUTER JOIN `slugs` ON `slugs`.sluggable_id = `collections`.id AND `slugs`.sluggable_type = 'Collection' LEFT OUTER JOIN `notes` ON `notes`.item_id = `collections`.id AND `notes`.item_type = 'Collection' WHERE `collections`.`id` >= $start AND `collections`.`id` <= $end AND `collections`.`delta` = 1 GROUP BY `collections`.`id` ORDER BY NULL
  163. sql_query_range = SELECT IFNULL(MIN(`id`), 1), IFNULL(MAX(`id`), 1) FROM `collections` WHERE `collections`.`delta` = 1
  164. sql_attr_uint = sphinx_internal_id
  165. sql_attr_uint = class_crc
  166. sql_attr_uint = sphinx_deleted
  167. sql_attr_timestamp = created_at
  168. sql_attr_timestamp = updated_at
  169. sql_attr_str2ordinal = title_sort
  170. sql_attr_multi = uint subclass_crcs from field
  171. sql_query_info = SELECT * FROM `collections` WHERE `id` = (($id - 2) / 7)
  172. }
  173.  
  174. index collection_delta : collection_core
  175. {
  176. source = collection_delta_0
  177. path = /Users/flip/ics/koko/db/sphinx/development/collection_delta
  178. }
  179.  
  180. index collection
  181. {
  182. type = distributed
  183. local = collection_delta
  184. local = collection_core
  185. }
  186.  
  187. source source_core_0
  188. {
  189. type = mysql
  190. sql_host = localhost
  191. sql_user = imw
  192. sql_pass = local_pass_14_312
  193. sql_db = imw_koko_dev
  194. sql_port = 9696
  195. sql_query_pre = UPDATE `sources` SET `delta` = 0 WHERE `delta` = 1
  196. sql_query_pre = SET NAMES utf8
  197. sql_query = SELECT `sources`.`id` * 7 + 3 AS `id` , CAST(`sources`.`title` AS CHAR) AS `title`, CAST(GROUP_CONCAT(DISTINCT `slugs`.`name` SEPARATOR ' ') AS CHAR) AS `name`, CAST(GROUP_CONCAT(DISTINCT `notes`.`body` SEPARATOR ' ') AS CHAR) AS `body`, CAST(`sources`.`main_link` AS CHAR) AS `main_link`, `sources`.`id` AS `sphinx_internal_id`, 1478916677 AS `class_crc`, '1478916677' AS `subclass_crcs`, 0 AS `sphinx_deleted`, IFNULL(`sources`.`title`, '') AS `title_sort`, UNIX_TIMESTAMP(`sources`.`created_at`) AS `created_at`, UNIX_TIMESTAMP(`sources`.`updated_at`) AS `updated_at` FROM `sources` LEFT OUTER JOIN `slugs` ON `slugs`.sluggable_id = `sources`.id AND `slugs`.sluggable_type = 'Source' LEFT OUTER JOIN `notes` ON `notes`.item_id = `sources`.id AND `notes`.item_type = 'Source' WHERE `sources`.`id` >= $start AND `sources`.`id` <= $end AND `sources`.`delta` = 0 GROUP BY `sources`.`id` ORDER BY NULL
  198. sql_query_range = SELECT IFNULL(MIN(`id`), 1), IFNULL(MAX(`id`), 1) FROM `sources` WHERE `sources`.`delta` = 0
  199. sql_attr_uint = sphinx_internal_id
  200. sql_attr_uint = class_crc
  201. sql_attr_uint = sphinx_deleted
  202. sql_attr_timestamp = created_at
  203. sql_attr_timestamp = updated_at
  204. sql_attr_str2ordinal = title_sort
  205. sql_attr_multi = uint subclass_crcs from field
  206. sql_query_info = SELECT * FROM `sources` WHERE `id` = (($id - 3) / 7)
  207. }
  208.  
  209. index source_core
  210. {
  211. source = source_core_0
  212. path = /Users/flip/ics/koko/db/sphinx/development/source_core
  213. morphology = stem_en
  214. charset_type = utf-8
  215. min_infix_len = 3
  216. enable_star = 1
  217. }
  218.  
  219. source source_delta_0 : source_core_0
  220. {
  221. type = mysql
  222. sql_host = localhost
  223. sql_user = imw
  224. sql_pass = local_pass_14_312
  225. sql_db = imw_koko_dev
  226. sql_port = 9696
  227. sql_query_pre =
  228. sql_query_pre = SET NAMES utf8
  229. sql_query = SELECT `sources`.`id` * 7 + 3 AS `id` , CAST(`sources`.`title` AS CHAR) AS `title`, CAST(GROUP_CONCAT(DISTINCT `slugs`.`name` SEPARATOR ' ') AS CHAR) AS `name`, CAST(GROUP_CONCAT(DISTINCT `notes`.`body` SEPARATOR ' ') AS CHAR) AS `body`, CAST(`sources`.`main_link` AS CHAR) AS `main_link`, `sources`.`id` AS `sphinx_internal_id`, 1478916677 AS `class_crc`, '1478916677' AS `subclass_crcs`, 0 AS `sphinx_deleted`, IFNULL(`sources`.`title`, '') AS `title_sort`, UNIX_TIMESTAMP(`sources`.`created_at`) AS `created_at`, UNIX_TIMESTAMP(`sources`.`updated_at`) AS `updated_at` FROM `sources` LEFT OUTER JOIN `slugs` ON `slugs`.sluggable_id = `sources`.id AND `slugs`.sluggable_type = 'Source' LEFT OUTER JOIN `notes` ON `notes`.item_id = `sources`.id AND `notes`.item_type = 'Source' WHERE `sources`.`id` >= $start AND `sources`.`id` <= $end AND `sources`.`delta` = 1 GROUP BY `sources%6
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!