API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jul 19th, 2019
89
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 24.89 KB | None | 0 0
raw download clone embed print report
  1. source product_documentation : base_sandbox
  2. {
  3. sql_query = \
  4. SELECT id, name, slug, title, description, product_review_title, published \
  5. FROM product
  6.  
  7. sql_attr_string = slug
  8. sql_field_string = name
  9. sql_field_string = title
  10. sql_field_string = description
  11. sql_field_string = product_review_title
  12. sql_attr_uint = published
  13. }
  14.  
  15. source product_documentation_eng : base_sandbox
  16. {
  17. sql_query = \
  18. SELECT id, name_eng, slug, title_eng, description_eng, product_review_title_eng, published_eng \
  19. FROM product
  20.  
  21. sql_attr_string = slug
  22. sql_field_string = name_eng
  23. sql_field_string = title_eng
  24. sql_field_string = description_eng
  25. sql_field_string = product_review_title_eng
  26. sql_attr_uint = published_eng
  27. }
  28.  
  29. source product_version : base_sandbox
  30. {
  31. sql_query = \
  32. SELECT pv.id as id, p.id as product_id, slug, name, pv.description as version_description, pv.published as published, p.published as product_published \
  33. FROM product_version pv \
  34. LEFT JOIN product p ON pv.id_product = p.id
  35.  
  36. sql_attr_string = slug
  37. sql_attr_uint = product_id
  38. sql_field_string = name
  39. sql_field_string = version_description
  40. sql_attr_uint = published
  41. sql_attr_uint = product_published
  42. }
  43.  
  44. source product_version_eng : base_sandbox
  45. {
  46. sql_query = \
  47. SELECT pv.id as id, p.id as product_id, slug, name_eng, pv.description_eng as version_description_eng, pv.published_eng as published_eng, p.published_eng as product_published_eng \
  48. FROM product_version pv \
  49. LEFT JOIN product p ON pv.id_product = p.id
  50.  
  51. sql_attr_string = slug
  52. sql_attr_uint = product_id
  53. sql_field_string = name_eng
  54. sql_field_string = version_description_eng
  55. sql_attr_uint = published_eng
  56. sql_attr_uint = product_published_eng
  57. }
  58.  
  59. source product_support : base_sandbox
  60. {
  61. sql_query = \
  62. SELECT id, name, slug, support_phone, support_email, support, published \
  63. FROM product
  64.  
  65. sql_attr_string = slug
  66. sql_field_string = name
  67. sql_field_string = support_phone
  68. sql_field_string = support_email
  69. sql_field_string = support
  70. sql_attr_uint = published
  71.  
  72. }
  73.  
  74. source product_support_eng : base_sandbox
  75. {
  76. sql_query = \
  77. SELECT id, name_eng, slug, support_phone_eng, support_email_eng, support_eng, published_eng \
  78. FROM product
  79.  
  80. sql_attr_string = slug
  81. sql_field_string = name_eng
  82. sql_field_string = support_phone_eng
  83. sql_field_string = support_email_eng
  84. sql_field_string = support_eng
  85. sql_attr_uint = published_eng
  86.  
  87. }
  88.  
  89. source method : base_sandbox
  90. {
  91. sql_query = \
  92. SELECT m.id, p.id as product_id, type, address, m.name as name, p.name as product_name, ps.name as section_name, p.slug as product_slug, ps.slug as section_slug, m.slug as slug, m.description as description, method_params, types_table, m.published as published, ps.published as section_published, p.published as product_published, p.current_version_id as current_version_id, ps.version_id as version_id \
  93. FROM method m \
  94. LEFT JOIN product_section ps ON m.id_section = ps.id \
  95. LEFT JOIN product p ON ps.id_product = p.id
  96.  
  97. sql_attr_uint = product_id
  98. sql_attr_uint = current_version_id
  99. sql_attr_uint = version_id
  100. sql_attr_string = slug
  101. sql_attr_string = product_slug
  102. sql_attr_string = section_slug
  103. sql_field_string = product_name
  104. sql_field_string = section_name
  105. sql_field_string = type
  106. sql_field_string = address
  107. sql_field_string = name
  108. sql_field_string = description
  109. sql_field_string = method_params
  110. sql_field_string = types_table
  111. sql_attr_uint = published
  112. sql_attr_uint = section_published
  113. sql_attr_uint = product_published
  114. }
  115.  
  116. source method_eng : base_sandbox
  117. {
  118. sql_query = \
  119. SELECT m.id, p.id as product_id, type, address, m.name_eng as name_eng, p.name_eng as product_name_eng, ps.name_eng as section_name_eng, p.slug as product_slug, ps.slug as section_slug, m.slug as slug, m.description_eng as description_eng, method_params_eng, types_table_eng, m.published_eng as published_eng, ps.published_eng as section_published_eng, p.published_eng as product_published_eng, p.current_version_eng_id as current_version_eng_id, ps.version_id as version_id \
  120. FROM method m \
  121. LEFT JOIN product_section ps ON m.id_section = ps.id \
  122. LEFT JOIN product p ON ps.id_product = p.id
  123.  
  124. sql_attr_uint = product_id
  125. sql_attr_uint = current_version_eng_id
  126. sql_attr_uint = version_id
  127. sql_attr_string = slug
  128. sql_attr_string = product_slug
  129. sql_attr_string = section_slug
  130. sql_field_string = product_name_eng
  131. sql_field_string = section_name_eng
  132. sql_field_string = type
  133. sql_field_string = address
  134. sql_field_string = name_eng
  135. sql_field_string = description_eng
  136. sql_field_string = method_params_eng
  137. sql_field_string = types_table_eng
  138. sql_attr_uint = published_eng
  139. sql_attr_uint = section_published_eng
  140. sql_attr_uint = product_published_eng
  141. }
  142.  
  143.  
  144. #############################################################################
  145. ## index definition
  146. #############################################################################
  147.  
  148. index sandbox_product_documentation_index
  149. {
  150. source = product_documentation
  151. path = /var/lib/sphinx/data/product_documentation_index
  152. docinfo = extern
  153. dict = keywords
  154. mlock = 0
  155.  
  156. morphology = stem_enru
  157. min_stemming_len = 3
  158. charset_table = 0..9, A..Z->a..z, _, a..z, \
  159. U+410..U+42F->U+430..U+44F, U+430..U+44F, U+401->U+0435, U+451->U+0435
  160. min_word_len = 2
  161.  
  162. min_infix_len = 3
  163.  
  164. html_strip = 1
  165. }
  166.  
  167. index sandbox_product_documentation_eng_index
  168. {
  169. source = product_documentation_eng
  170. path = /var/lib/sphinx/data/product_documentation_eng_index
  171. docinfo = extern
  172. dict = keywords
  173. mlock = 0
  174.  
  175. morphology = stem_enru
  176. min_stemming_len = 3
  177. charset_table = 0..9, A..Z->a..z, _, a..z, \
  178. U+410..U+42F->U+430..U+44F, U+430..U+44F, U+401->U+0435, U+451->U+0435
  179. min_word_len = 2
  180.  
  181. min_infix_len = 3
  182.  
  183. html_strip = 1
  184. }
  185.  
  186. index sandbox_product_version_index
  187. {
  188. source = product_version
  189. path = /var/lib/sphinx/data/product_version_index
  190. docinfo = extern
  191. dict = keywords
  192. mlock = 0
  193.  
  194. morphology = stem_enru
  195. min_stemming_len = 3
  196. charset_table = 0..9, A..Z->a..z, _, a..z, \
  197. U+410..U+42F->U+430..U+44F, U+430..U+44F, U+401->U+0435, U+451->U+0435
  198. min_word_len = 2
  199.  
  200. min_infix_len = 3
  201.  
  202. html_strip = 1
  203. }
  204.  
  205. index sandbox_product_version_eng_index
  206. {
  207. source = product_version_eng
  208. path = /var/lib/sphinx/data/product_version_eng_index
  209. docinfo = extern
  210. dict = keywords
  211. mlock = 0
  212.  
  213. morphology = stem_enru
  214. min_stemming_len = 3
  215. charset_table = 0..9, A..Z->a..z, _, a..z, \
  216. U+410..U+42F->U+430..U+44F, U+430..U+44F, U+401->U+0435, U+451->U+0435
  217. min_word_len = 2
  218.  
  219. min_infix_len = 3
  220.  
  221. html_strip = 1
  222. }
  223.  
  224. index sandbox_product_support_index
  225. {
  226. source = product_support
  227. path = /var/lib/sphinx/data/product_support_index
  228. docinfo = extern
  229. dict = keywords
  230. mlock = 0
  231.  
  232. morphology = stem_enru
  233. min_stemming_len = 3
  234. charset_table = 0..9, A..Z->a..z, _, a..z, \
  235. U+410..U+42F->U+430..U+44F, U+430..U+44F, U+401->U+0435, U+451->U+0435
  236. min_word_len = 2
  237.  
  238. min_infix_len = 3
  239.  
  240. html_strip = 1
  241. }
  242.  
  243. index sandbox_product_support_eng_index
  244. {
  245. source = product_support_eng
  246. path = /var/lib/sphinx/data/product_support_eng_index
  247. docinfo = extern
  248. dict = keywords
  249. mlock = 0
  250.  
  251. morphology = stem_enru
  252. min_stemming_len = 3
  253. charset_table = 0..9, A..Z->a..z, _, a..z, \
  254. U+410..U+42F->U+430..U+44F, U+430..U+44F, U+401->U+0435, U+451->U+0435
  255. min_word_len = 2
  256.  
  257. min_infix_len = 3
  258.  
  259. html_strip = 1
  260. }
  261.  
  262. index sandbox_method_index
  263. {
  264. source = method
  265. path = /var/lib/sphinx/data/method_index
  266. docinfo = extern
  267. dict = keywords
  268. mlock = 0
  269.  
  270. morphology = stem_enru
  271. min_stemming_len = 3
  272. charset_table = 0..9, A..Z->a..z, _, a..z, \
  273. U+410..U+42F->U+430..U+44F, U+430..U+44F, U+401->U+0435, U+451->U+0435
  274. min_word_len = 2
  275.  
  276. min_infix_len = 3
  277.  
  278. html_strip = 1
  279. }
  280.  
  281. index sandbox_method_eng_index
  282. {
  283. source = method_eng
  284. path = /var/lib/sphinx/data/method_eng_index
  285. docinfo = extern
  286. dict = keywords
  287. mlock = 0
  288.  
  289. morphology = stem_enru
  290. min_stemming_len = 3
  291. charset_table = 0..9, A..Z->a..z, _, a..z, \
  292. U+410..U+42F->U+430..U+44F, U+430..U+44F, U+401->U+0435, U+451->U+0435
  293. min_word_len = 2
  294.  
  295. min_infix_len = 3
  296.  
  297. html_strip = 1
  298. }
  299.  
  300. index sandbox_product_documentation_rt
  301. {
  302. type = rt
  303. path = /var/lib/sphinx/data/product_documentation_rt
  304. docinfo = extern
  305. dict = keywords
  306. mlock = 0
  307. rt_mem_limit = 512M
  308.  
  309. morphology = stem_enru
  310. min_stemming_len = 3
  311. charset_table = 0..9, A..Z->a..z, _, a..z, \
  312. U+410..U+42F->U+430..U+44F, U+430..U+44F, U+401->U+0435, U+451->U+0435
  313. min_word_len = 2
  314.  
  315. min_infix_len = 3
  316.  
  317. html_strip = 1
  318.  
  319.  
  320. rt_attr_string = slug
  321. rt_field = name
  322. rt_field = title
  323. rt_field = description
  324. rt_field = product_review_title
  325. rt_attr_uint = published
  326. }
  327.  
  328. index sandbox_product_documentation_eng_rt
  329. {
  330. type = rt
  331. path = /var/lib/sphinx/data/product_documentation_eng_rt
  332. docinfo = extern
  333. dict = keywords
  334. mlock = 0
  335. rt_mem_limit = 512M
  336.  
  337. morphology = stem_enru
  338. min_stemming_len = 3
  339. charset_table = 0..9, A..Z->a..z, _, a..z, \
  340. U+410..U+42F->U+430..U+44F, U+430..U+44F, U+401->U+0435, U+451->U+0435
  341. min_word_len = 2
  342.  
  343. min_infix_len = 3
  344.  
  345. html_strip = 1
  346.  
  347.  
  348. rt_attr_string = slug
  349. rt_field = name_eng
  350. rt_field = title_eng
  351. rt_field = description_eng
  352. rt_field = product_review_title_eng
  353. rt_attr_uint = published_eng
  354. }
  355.  
  356. index sandbox_product_version_rt
  357. {
  358. type = rt
  359. path = /var/lib/sphinx/data/product_version_rt
  360. docinfo = extern
  361. dict = keywords
  362. mlock = 0
  363. rt_mem_limit = 512M
  364.  
  365. morphology = stem_enru
  366. min_stemming_len = 3
  367. charset_table = 0..9, A..Z->a..z, _, a..z, \
  368. U+410..U+42F->U+430..U+44F, U+430..U+44F, U+401->U+0435, U+451->U+0435
  369. min_word_len = 2
  370.  
  371. min_infix_len = 3
  372.  
  373. html_strip = 1
  374.  
  375.  
  376. rt_attr_string = slug
  377. rt_attr_uint = product_id
  378. rt_field = name
  379. rt_field = version_description
  380. rt_attr_uint = published
  381. rt_attr_uint = product_published
  382. }
  383.  
  384. index sandbox_product_version_eng_rt
  385. {
  386. type = rt
  387. path = /var/lib/sphinx/data/product_version_eng_rt
  388. docinfo = extern
  389. dict = keywords
  390. mlock = 0
  391. rt_mem_limit = 512M
  392.  
  393. morphology = stem_enru
  394. min_stemming_len = 3
  395. charset_table = 0..9, A..Z->a..z, _, a..z, \
  396. U+410..U+42F->U+430..U+44F, U+430..U+44F, U+401->U+0435, U+451->U+0435
  397. min_word_len = 2
  398.  
  399. min_infix_len = 3
  400.  
  401. html_strip = 1
  402.  
  403.  
  404. rt_attr_string = slug
  405. rt_attr_uint = product_id
  406. rt_field = name_eng
  407. rt_field = version_description_eng
  408. rt_attr_uint = published_eng
  409. rt_attr_uint = product_published_eng
  410. }
  411.  
  412. index sandbox_product_support_rt
  413. {
  414. type = rt
  415. path = /var/lib/sphinx/data/product_support_rt
  416. docinfo = extern
  417. dict = keywords
  418. mlock = 0
  419. rt_mem_limit = 512M
  420.  
  421. morphology = stem_enru
  422. min_stemming_len = 3
  423. charset_table = 0..9, A..Z->a..z, _, a..z, \
  424. U+410..U+42F->U+430..U+44F, U+430..U+44F, U+401->U+0435, U+451->U+0435
  425. min_word_len = 2
  426.  
  427. min_infix_len = 3
  428.  
  429. html_strip = 1
  430.  
  431.  
  432. rt_attr_string = slug
  433. rt_field = name
  434. rt_field = support_phone
  435. rt_field = support_email
  436. rt_field = support
  437. rt_attr_uint = published
  438. }
  439.  
  440. index sandbox_product_support_eng_rt
  441. {
  442. type = rt
  443. path = /var/lib/sphinx/data/product_support_eng_rt
  444. docinfo = extern
  445. dict = keywords
  446. mlock = 0
  447. rt_mem_limit = 512M
  448.  
  449. morphology = stem_enru
  450. min_stemming_len = 3
  451. charset_table = 0..9, A..Z->a..z, _, a..z, \
  452. U+410..U+42F->U+430..U+44F, U+430..U+44F, U+401->U+0435, U+451->U+0435
  453. min_word_len = 2
  454.  
  455. min_infix_len = 3
  456.  
  457. html_strip = 1
  458.  
  459.  
  460. rt_attr_string = slug
  461. rt_field = name_eng
  462. rt_field = support_phone_eng
  463. rt_field = support_email_eng
  464. rt_field = support_eng
  465. rt_attr_uint = published_eng
  466. }
  467.  
  468. index sandbox_method_rt
  469. {
  470. type = rt
  471. path = /var/lib/sphinx/data/method_rt
  472. docinfo = extern
  473. dict = keywords
  474. mlock = 0
  475. rt_mem_limit = 512M
  476.  
  477. morphology = stem_enru
  478. min_stemming_len = 3
  479. charset_table = 0..9, A..Z->a..z, _, a..z, \
  480. U+410..U+42F->U+430..U+44F, U+430..U+44F, U+401->U+0435, U+451->U+0435
  481. min_word_len = 2
  482.  
  483. min_infix_len = 3
  484.  
  485. html_strip = 1
  486.  
  487.  
  488. rt_attr_uint = product_id
  489. rt_attr_uint = current_version_id
  490. rt_attr_uint = version_id
  491. rt_attr_string = slug
  492. rt_attr_string = product_slug
  493. rt_attr_string = section_slug
  494. rt_field = product_name
  495. rt_field = section_name
  496. rt_field = type
  497. rt_field = address
  498. rt_field = name
  499. rt_field = description
  500. rt_field = method_params
  501. rt_field = types_table
  502. rt_attr_uint = published
  503. rt_attr_uint = section_published
  504. rt_attr_uint = product_published
  505. }
  506.  
  507. index sandbox_method_eng_rt
  508. {
  509. type = rt
  510. path = /var/lib/sphinx/data/method_eng_rt
  511. docinfo = extern
  512. dict = keywords
  513. mlock = 0
  514. rt_mem_limit = 512M
  515.  
  516. morphology = stem_enru
  517. min_stemming_len = 3
  518. charset_table = 0..9, A..Z->a..z, _, a..z, \
  519. U+410..U+42F->U+430..U+44F, U+430..U+44F, U+401->U+0435, U+451->U+0435
  520. min_word_len = 2
  521.  
  522. min_infix_len = 3
  523.  
  524. html_strip = 1
  525.  
  526.  
  527. rt_attr_uint = product_id
  528. rt_attr_uint = current_version_eng_id
  529. rt_attr_uint = version_id
  530. rt_attr_string = slug
  531. rt_attr_string = product_slug
  532. rt_attr_string = section_slug
  533. rt_field = product_name_eng
  534. rt_field = section_name_eng
  535. rt_field = type
  536. rt_field = address
  537. rt_field = name_eng
  538. rt_field = description_eng
  539. rt_field = method_params_eng
  540. rt_field = types_table_eng
  541. rt_attr_uint = published_eng
  542. rt_attr_uint = section_published_eng
  543. rt_attr_uint = product_published_eng
  544. }
  545.  
  546.  
  547.  
  548. #############################################################################
  549. ## indexer settings
  550. #############################################################################
  551.  
  552. indexer
  553. {
  554. # memory limit, in bytes, kiloytes (16384K) or megabytes (256M)
  555. # optional, default is 128M, max is 2047M, recommended is 256M to 1024M
  556. mem_limit = 128M
  557.  
  558. # maximum IO calls per second (for I/O throttling)
  559. # optional, default is 0 (unlimited)
  560. #
  561. # max_iops = 40
  562.  
  563.  
  564. # maximum IO call size, bytes (for I/O throttling)
  565. # optional, default is 0 (unlimited)
  566. #
  567. # max_iosize = 1048576
  568.  
  569.  
  570. # maximum xmlpipe2 field length, bytes
  571. # optional, default is 2M
  572. #
  573. # max_xmlpipe2_field = 4M
  574.  
  575.  
  576. # write buffer size, bytes
  577. # several (currently up to 4) buffers will be allocated
  578. # write buffers are allocated in addition to mem_limit
  579. # optional, default is 1M
  580. #
  581. # write_buffer = 1M
  582.  
  583.  
  584. # maximum file field adaptive buffer size
  585. # optional, default is 8M, minimum is 1M
  586. #
  587. # max_file_field_buffer = 32M
  588.  
  589.  
  590. # how to handle IO errors in file fields
  591. # known values are 'ignore_field', 'skip_document', and 'fail_index'
  592. # optional, default is 'ignore_field'
  593. #
  594. # on_file_field_error = skip_document
  595.  
  596.  
  597. # lemmatizer cache size
  598. # improves the indexing time when the lemmatization is enabled
  599. # optional, default is 256K
  600. #
  601. # lemmatizer_cache = 512M
  602. }
  603.  
  604. #############################################################################
  605. ## searchd settings
  606. #############################################################################
  607.  
  608. searchd
  609. {
  610. # [hostname:]port[:protocol], or /unix/socket/path to listen on
  611. # known protocols are 'sphinx' (SphinxAPI) and 'mysql41' (SphinxQL)
  612. #
  613. # multi-value, multiple listen points are allowed
  614. # optional, defaults are 9312:sphinx and 9306:mysql41, as below
  615. #
  616. # listen = 127.0.0.1
  617. # listen = localhost:9312
  618. # listen = 9312
  619. # listen = /var/run/searchd.sock
  620. listen = 9313
  621. listen = 127.0.0.1:9307:mysql41
  622.  
  623. # log file, searchd run info is logged here
  624. # optional, default is 'searchd.log'
  625. log = /var/log/sphinx/searchd.log
  626.  
  627. # query log file, all search queries are logged here
  628. # optional, default is empty (do not log queries)
  629. query_log = /var/log/sphinx/query.log
  630.  
  631. # client read timeout, seconds
  632. # optional, default is 5
  633. read_timeout = 5
  634.  
  635. # request timeout, seconds
  636. # optional, default is 5 minutes
  637. client_timeout = 300
  638.  
  639. # maximum amount of children to fork (concurrent searches to run)
  640. # optional, default is 0 (unlimited)
  641. max_children = 30
  642.  
  643. # maximum amount of persistent connections from this master to each agent host
  644. # optional, but necessary if you use agent_persistent. It is reasonable to set the value
  645. # as max_children, or less on the agent's hosts.
  646. persistent_connections_limit = 30
  647.  
  648. # PID file, searchd process ID file name
  649. # mandatory
  650. pid_file = /var/run/sphinx/searchd.pid
  651.  
  652. # seamless rotate, prevents rotate stalls if precaching huge datasets
  653. # optional, default is 1
  654. seamless_rotate = 1
  655.  
  656. # whether to forcibly preopen all indexes on startup
  657. # optional, default is 1 (preopen everything)
  658. preopen_indexes = 1
  659.  
  660. # whether to unlink .old index copies on succesful rotation.
  661. # optional, default is 1 (do unlink)
  662. unlink_old = 1
  663.  
  664. # attribute updates periodic flush timeout, seconds
  665. # updates will be automatically dumped to disk this frequently
  666. # optional, default is 0 (disable periodic flush)
  667. #
  668. # attr_flush_period = 900
  669.  
  670.  
  671. # MVA updates pool size
  672. # shared between all instances of searchd, disables attr flushes!
  673. # optional, default size is 1M
  674. mva_updates_pool = 1M
  675.  
  676. # max allowed network packet size
  677. # limits both query packets from clients, and responses from agents
  678. # optional, default size is 8M
  679. max_packet_size = 8M
  680.  
  681. # max allowed per-query filter count
  682. # optional, default is 256
  683. max_filters = 256
  684.  
  685. # max allowed per-filter values count
  686. # optional, default is 4096
  687. max_filter_values = 4096
  688.  
  689.  
  690. # socket listen queue length
  691. # optional, default is 5
  692. #
  693. # listen_backlog = 5
  694.  
  695.  
  696. # per-keyword read buffer size
  697. # optional, default is 256K
  698. #
  699. # read_buffer = 256K
  700.  
  701.  
  702. # unhinted read size (currently used when reading hits)
  703. # optional, default is 32K
  704. #
  705. # read_unhinted = 32K
  706.  
  707.  
  708. # max allowed per-batch query count (aka multi-query count)
  709. # optional, default is 32
  710. max_batch_queries = 32
  711.  
  712.  
  713. # max common subtree document cache size, per-query
  714. # optional, default is 0 (disable subtree optimization)
  715. #
  716. # subtree_docs_cache = 4M
  717.  
  718.  
  719. # max common subtree hit cache size, per-query
  720. # optional, default is 0 (disable subtree optimization)
  721. #
  722. # subtree_hits_cache = 8M
  723.  
  724.  
  725. # multi-processing mode (MPM)
  726. # known values are none, fork, prefork, and threads
  727. # threads is required for RT backend to work
  728. # optional, default is threads
  729. workers = threads # for RT to work
  730.  
  731.  
  732. # max threads to create for searching local parts of a distributed index
  733. # optional, default is 0, which means disable multi-threaded searching
  734. # should work with all MPMs (ie. does NOT require workers=threads)
  735. #
  736. # dist_threads = 4
  737.  
  738.  
  739. # binlog files path; use empty string to disable binlog
  740. # optional, default is build-time configured data directory
  741. #
  742. # binlog_path = # disable logging
  743. # binlog_path = /var/lib/sphinx/data # binlog.001 etc will be created there
  744. binlog_path = /var/lib/sphinx/data # binlog.001 etc will be created there
  745.  
  746.  
  747. # binlog flush/sync mode
  748. # 0 means flush and sync every second
  749. # 1 means flush and sync every transaction
  750. # 2 means flush every transaction, sync every second
  751. # optional, default is 2
  752. #
  753. # binlog_flush = 2
  754.  
  755.  
  756. # binlog per-file size limit
  757. # optional, default is 128M, 0 means no limit
  758. #
  759. # binlog_max_log_size = 256M
  760.  
  761.  
  762. # per-thread stack size, only affects workers=threads mode
  763. # optional, default is 64K
  764. #
  765. # thread_stack = 128K
  766.  
  767.  
  768. # per-keyword expansion limit (for dict=keywords prefix searches)
  769. # optional, default is 0 (no limit)
  770. #
  771. # expansion_limit = 1000
  772.  
  773.  
  774. # RT RAM chunks flush period
  775. # optional, default is 0 (no periodic flush)
  776. #
  777. # rt_flush_period = 900
  778.  
  779.  
  780. # query log file format
  781. # optional, known values are plain and sphinxql, default is plain
  782. #
  783. # query_log_format = sphinxql
  784.  
  785.  
  786. # version string returned to MySQL network protocol clients
  787. # optional, default is empty (use Sphinx version)
  788. #
  789. # mysql_version_string = 5.0.37
  790.  
  791.  
  792. # default server-wide collation
  793. # optional, default is libc_ci
  794. #
  795. # collation_server = utf8_general_ci
  796.  
  797.  
  798. # server-wide locale for libc based collations
  799. # optional, default is C
  800. #
  801. # collation_libc_locale = ru_RU.UTF-8
  802.  
  803.  
  804. # threaded server watchdog (only used in workers=threads mode)
  805. # optional, values are 0 and 1, default is 1 (watchdog on)
  806. #
  807. # watchdog = 1
  808.  
  809.  
  810. # costs for max_predicted_time model, in (imaginary) nanoseconds
  811. # optional, default is "doc=64, hit=48, skip=2048, match=64"
  812. #
  813. # predicted_time_costs = doc=64, hit=48, skip=2048, match=64
  814.  
  815.  
  816. # current SphinxQL state (uservars etc) serialization path
  817. # optional, default is none (do not serialize SphinxQL state)
  818. #
  819. # sphinxql_state = sphinxvars.sql
  820.  
  821.  
  822. # maximum RT merge thread IO calls per second, and per-call IO size
  823. # useful for throttling (the background) OPTIMIZE INDEX impact
  824. # optional, default is 0 (unlimited)
  825. #
  826. # rt_merge_iops = 40
  827. # rt_merge_maxiosize = 1M
  828.  
  829.  
  830. # interval between agent mirror pings, in milliseconds
  831. # 0 means disable pings
  832. # optional, default is 1000
  833. #
  834. # ha_ping_interval = 0
  835.  
  836.  
  837. # agent mirror statistics window size, in seconds
  838. # stats older than the window size (karma) are retired
  839. # that is, they will not affect master choice of agents in any way
  840. # optional, default is 60 seconds
  841. #
  842. # ha_period_karma = 60
  843.  
  844.  
  845. # delay between preforked children restarts on rotation, in milliseconds
  846. # optional, default is 0 (no delay)
  847. #
  848. # prefork_rotation_throttle = 100
  849.  
  850.  
  851. # a prefix to prepend to the local file names when creating snippets
  852. # with load_files and/or load_files_scatter options
  853. # optional, default is empty
  854. #
  855. # snippets_file_prefix = /mnt/common/server1/
  856. }
  857.  
  858. #############################################################################
  859. ## common settings
  860. #############################################################################
  861.  
  862. common
  863. {
  864.  
  865. # lemmatizer dictionaries base path
  866. # optional, defaut is /usr/local/share (see ./configure --datadir)
  867. #
  868. # lemmatizer_base = /usr/local/share/sphinx/dicts
  869.  
  870.  
  871. # how to handle syntax errors in JSON attributes
  872. # known values are 'ignore_attr' and 'fail_index'
  873. # optional, default is 'ignore_attr'
  874. #
  875. # on_json_attr_error = fail_index
  876.  
  877.  
  878. # whether to auto-convert numeric values from strings in JSON attributes
  879. # with auto-conversion, string value with actually numeric data
  880. # (as in {"key":"12345"}) gets stored as a number, rather than string
  881. # optional, allowed values are 0 and 1, default is 0 (do not convert)
  882. #
  883. # json_autoconv_numbers = 1
  884.  
  885.  
  886. # whether and how to auto-convert key names in JSON attributes
  887. # known value is 'lowercase'
  888. # optional, default is unspecified (do nothing)
  889. #
  890. # json_autoconv_keynames = lowercase
  891.  
  892.  
  893. # path to RLP root directory
  894. # optional, defaut is /usr/local/share (see ./configure --datadir)
  895. #
  896. # rlp_root = /usr/local/share/sphinx/rlp
  897.  
  898.  
  899. # path to RLP environment file
  900. # optional, defaut is /usr/local/share/rlp-environment.xml (see ./configure --datadir)
  901. #
  902. # rlp_environment = /usr/local/share/sphinx/rlp/rlp/etc/rlp-environment.xml
  903.  
  904.  
  905. # maximum total size of documents batched before processing them by the RLP
  906. # optional, default is 51200
  907. #
  908. # rlp_max_batch_size = 100k
  909.  
  910.  
  911. # maximum number of documents batched before processing them by the RLP
  912. # optional, default is 50
  913. #
  914. # rlp_max_batch_docs = 100
  915.  
  916.  
  917. # trusted plugin directory
  918. # optional, default is empty (disable UDFs)
  919. #
  920. # plugin_dir = /usr/local/sphinx/lib
  921.  
  922. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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!