API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jul 31st, 2015
338
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 12.64 KB | None | 0 0
raw download clone embed print report
  1. source dk_main_posts
  2. {
  3. type = mysql
  4. sql_host = localhost
  5. sql_user = ------------
  6. sql_pass = -----------
  7. sql_db = ------------
  8. sql_sock = /var/lib/mysql/mysql.sock
  9. sql_port = 3306 # optional, default is 3306
  10. sql_query_pre = SET NAMES utf8
  11. sql_query_pre = REPLACE INTO dk_sph_counter SELECT 1, IF(0 < MAX(id), MAX(id), 1) FROM dk_posts
  12. sql_query_range = SELECT IF(0 < MIN(id), MIN(id), 1),( SELECT max_doc_id FROM dk_sph_counter WHERE counter_id=1 ) FROM dk_posts
  13. sql_range_step = 1000
  14.  
  15. sql_query = select \
  16. p.ID*2+1 as ID, \
  17. 0 as comment_ID,\
  18. p.ID as post_ID,\
  19. p.post_title as title, \
  20. p.post_content as body, \
  21. t.name as category, \
  22. IF(p.post_type = 'post', 1, 0) as isPost, \
  23. 0 as isComment, \
  24. IF(p.post_type = 'page', 1, 0) as isPage, \
  25. IF(p.post_type = 'post', 0, IF(p.post_type = 'page', 1, 2)) as post_type, \
  26. UNIX_TIMESTAMP(post_date) AS date_added, \
  27. GROUP_CONCAT(DISTINCT tag_t.name) as tags \
  28. from \
  29. dk_posts as p \
  30. left join \
  31. dk_term_relationships tr on (p.ID = tr.object_id) \
  32. left join \
  33. dk_term_taxonomy tt on (tt.term_taxonomy_id = tr.term_taxonomy_id and tt.taxonomy = 'category') \
  34. left join \
  35. dk_terms t on (tt.term_id = t.term_id) \
  36. left join \
  37. dk_term_relationships tag_tr on (p.ID = tag_tr.object_id) \
  38. left join \
  39. dk_term_taxonomy tag_tt on (tag_tt.term_taxonomy_id = tag_tr.term_taxonomy_id and tag_tt.taxonomy = 'post_tag') \
  40. left join \
  41. dk_terms tag_t on (tag_tt.term_id = tag_t.term_id) \
  42. where \
  43. p.id>=$start AND p.id<=$end and \
  44. p.post_status = 'publish' \
  45. group by p.ID
  46.  
  47. sql_attr_uint = comment_ID
  48. sql_attr_uint = post_ID
  49. sql_attr_uint = isPost
  50. sql_attr_uint = isPage
  51. sql_attr_uint = isComment
  52. sql_attr_uint = post_type
  53. sql_attr_timestamp = date_added
  54. }
  55.  
  56. source dk_main_comments
  57. {
  58. type = mysql
  59. sql_host = localhost
  60. sql_user = ----------------
  61. sql_pass = -----------------
  62. sql_db = ----------------
  63. sql_sock = /var/lib/mysql/mysql.sock
  64. sql_port = 3306 # optional, default is 3306
  65. sql_query_pre = SET NAMES utf8
  66. sql_query_pre = REPLACE INTO dk_sph_counter SELECT 2, IF(0 < MAX(comment_id), MAX(comment_id), 1) FROM dk_comments
  67. sql_query_range = SELECT IF(0 < MIN(comment_id), MIN(comment_id), 1),( SELECT max_doc_id FROM dk_sph_counter WHERE counter_id=2 ) FROM dk_comments
  68. sql_range_step = 1000
  69.  
  70. sql_query = select \
  71. c.comment_ID*2 as ID, \
  72. c.comment_ID as comment_ID,\
  73. c.comment_post_ID as post_ID,\
  74. '' as title, \
  75. c.comment_content as body, \
  76. '' as category, \
  77. 0 as isPost, \
  78. 1 as isComment, \
  79. 0 as isPage, \
  80. 2 as post_type, \
  81. UNIX_TIMESTAMP(comment_date) AS date_added, \
  82. '' as tags \
  83. from \
  84. dk_comments as c \
  85. where \
  86. c.comment_id>=$start AND c.comment_id<=$end and \
  87. c.comment_approved = '1';
  88.  
  89. sql_attr_uint = comment_ID
  90. sql_attr_uint = post_ID
  91. sql_attr_uint = isPost
  92. sql_attr_uint = isPage
  93. sql_attr_uint = isComment
  94. sql_attr_uint = post_type
  95. sql_attr_timestamp = date_added
  96. }
  97.  
  98. source dk_delta_posts : dk_main_posts
  99. {
  100. sql_query_range = SELECT ( SELECT max_doc_id FROM dk_sph_counter where counter_id = 1 ), IF ( 0 < MAX(id), MAX(id), 1) FROM dk_posts
  101. sql_range_step = 1000
  102. sql_query_pre = SET NAMES utf8
  103.  
  104. sql_query = select \
  105. p.ID*2+1 as ID, \
  106. 0 as comment_ID,\
  107. p.ID as post_ID,\
  108. p.post_title as title, \
  109. p.post_content as body, \
  110. t.name as category, \
  111. IF(p.post_type = 'post', 1, 0) as isPost, \
  112. 0 as isComment, \
  113. IF(p.post_type = 'page', 1, 0) as isPage, \
  114. IF(p.post_type = 'post', 0, IF(p.post_type = 'page', 1, 2)) as post_type, \
  115. UNIX_TIMESTAMP(post_date) AS date_added, \
  116. GROUP_CONCAT(DISTINCT tag_t.name) as tags \
  117. from \
  118. dk_posts as p \
  119. left join \
  120. dk_term_relationships tr on (p.ID = tr.object_id) \
  121. left join \
  122. dk_term_taxonomy tt on (tt.term_taxonomy_id = tr.term_taxonomy_id and tt.taxonomy = 'category') \
  123. left join \
  124. dk_terms t on (tt.term_id = t.term_id) \
  125. left join \
  126. dk_term_relationships tag_tr on (p.ID = tag_tr.object_id) \
  127. left join \
  128. dk_term_taxonomy tag_tt on (tag_tt.term_taxonomy_id = tag_tr.term_taxonomy_id and tag_tt.taxonomy = 'post_tag') \
  129. left join \
  130. dk_terms tag_t on (tag_tt.term_id = tag_t.term_id) \
  131. where \
  132. p.id>$start AND p.id<=$end and \
  133. p.post_status = 'publish' \
  134. group by p.ID ;
  135. }
  136.  
  137. source dk_delta_comments : dk_main_comments
  138. {
  139. sql_query_range = SELECT ( SELECT max_doc_id FROM dk_sph_counter where counter_id = 2 ), IF ( 0 < MAX(comment_id), MAX(comment_id), 1) FROM dk_comments
  140. sql_range_step = 1000
  141. sql_query_pre = SET NAMES utf8
  142.  
  143. sql_query = select \
  144. c.comment_ID*2 as ID, \
  145. c.comment_ID as comment_ID,\
  146. c.comment_post_ID as post_ID,\
  147. '' as title, \
  148. c.comment_content as body, \
  149. '' as category, \
  150. 0 as isPost, \
  151. 1 as isComment, \
  152. 0 as isPage, \
  153. 2 as post_type, \
  154. UNIX_TIMESTAMP(comment_date) AS date_added, \
  155. '' as tags \
  156. from \
  157. dk_comments as c \
  158. where \
  159. c.comment_id>$start AND c.comment_id<=$end and \
  160. c.comment_approved = '1';
  161. }
  162.  
  163. index dk_main
  164. {
  165. source = dk_main_posts
  166. source = dk_main_comments
  167. path = /home/example.com/public_html/wp-content/uploads/sphinx/var/data/dk_main
  168. docinfo = extern
  169. morphology = stem_enru
  170. html_strip = 1
  171. charset_type = utf-8
  172. charset_table = 0..9,U+27, U+41..U+5a->U+61..U+7a, U+61..U+7a, U+aa, U+b5, U+ba, U+c0..U+d6->U+e0..U+f6, U+d8..U+de->U+f8..U+fe, U+df..U+f6, U+f8..U+ff, U+100..U+12f/2, U+130->U+69, U+131, U+132..U+137/2, U+138, U+139..U+148/2, U+149, U+14a..U+177/2, U+178->U+ff, U+179..U+17e/2, U+17f..U+180, U+181->U+253, U+182..U+185/2, U+186->U+254, U+187..U+188/2, U+189..U+18a->U+256..U+257, U+18b..U+18c/2, U+18d, U+18e->U+1dd, U+18f->U+259, U+190->U+25b, U+191..U+192/2, U+193->U+260, U+194->U+263, U+195, U+196->U+269, U+197->U+268, U+198..U+199/2, U+19a..U+19b, U+19c->U+26f, U+19d->U+272, U+19e, U+19f->U+275, U+1a0..U+1a5/2, U+1a6->U+280, U+1a7..U+1a8/2, U+1a9->U+283, U+1aa..U+1ab, U+1ac..U+1ad/2, U+1ae->U+288, U+1af..U+1b0/2, U+1b1..U+1b2->U+28a..U+28b, U+1b3..U+1b6/2, U+1b7->U+292, U+1b8..U+1b9/2, U+1ba..U+1bb, U+1bc..U+1bd/2, U+1be..U+1c3, U+1c4->U+1c6, U+1c5..U+1c6/2, U+1c7->U+1c9, U+1c8..U+1c9/2, U+1ca->U+1cc, U+1cb..U+1dc/2, U+1dd, U+1de..U+1ef/2, U+1f0, U+1f1->U+1f3, U+1f2..U+1f5/2, U+1f6->U+195, U+1f7->U+1bf, U+1f8..U+21f/2, U+220->U+19e, U+221, U+222..U+233/2, U+234..U+23a, U+23b..U+23c/2, U+23d->U+19a, U+23e..U+240, U+241->U+294, U+250..U+2c1, U+2c6..U+2d1, U+2e0..U+2e4, U+2ee, U+37a, U+386..U+389->U+3ac..U+3af, U+38c..U+38e->U+3cc..U+3ce, U+390, U+391..U+3a1->U+3b1..U+3c1, U+3a3..U+3ab->U+3c3..U+3cb, U+3ac..U+3ce, U+3d0..U+3d7, U+3d8..U+3ef/2, U+3f0..U+3f3, U+3f4->U+3b8, U+3f5, U+3f7..U+3f8/2, U+3f9->U+3f2, U+3fa..U+3fb/2, U+3fc..U+3ff, U+400..U+40f->U+450..U+45f, U+410..U+42f->U+430..U+44f, U+430..U+45f, U+460..U+481/2, U+48a..U+4bf/2, U+4c0, U+4c1..U+4ce/2, U+4d0..U+4f9/2, U+500..U+50f/2, U+531..U+556->U+561..U+586, U+559, U+561..U+587, U+5d0..U+5ea, U+5f0..U+5f2, U+621..U+63a, U+640..U+64a, U+66e..U+66f, U+671..U+6d3, U+6d5, U+6e5..U+6e6, U+6ee..U+6ef, U+6fa..U+6fc, U+6ff, U+e01..U+e30, U+e32..U+e33, U+e40..U+e46, U+e81..U+e82, U+e84, U+e87..U+e88, U+e8a, U+e8d, U+e94..U+e97, U+e99..U+e9f, U+ea1..U+ea3, U+ea5, U+ea7, U+eaa..U+eab, U+ead..U+eb0, U+eb2..U+eb3, U+ebd, U+ec0..U+ec4, U+ec6, U+edc..U+edd, U+1000..U+1021, U+1023..U+1027, U+1029..U+102a, U+1050..U+1055, U+10a0..U+10c5->U+2d00..U+2d25, U+10d0..U+10fa, U+10fc, U+2d00..U+2d25, U+1d00..U+1dbf, U+1e00..U+1e95/2, U+1e96..U+1e9b, U+1ea0..U+1ef9/2, U+3005..U+3006, U+3031..U+3035, U+303b..U+303c, U+3041..U+3096, U+309d..U+309f, U+30a1..U+30fa, U+30fc..U+30ff, U+31f0..U+31ff
  173.  
  174. }
  175.  
  176. index dk_delta : dk_main
  177. {
  178. source = dk_delta_posts
  179. source = dk_delta_comments
  180. path = /home/example.com/public_html/wp-content/uploads/sphinx/var/data/dk_delta
  181. }
  182.  
  183. index dk_
  184. {
  185. type = distributed
  186. local = dk_main
  187. local = dk_delta
  188. }
  189.  
  190. source dk_stats
  191. {
  192. type = mysql
  193. sql_host = localhost
  194. sql_user = -------------
  195. sql_pass = --------------
  196. sql_db = -------------
  197. sql_sock = /var/lib/mysql/mysql.sock
  198. sql_port = 3306 # optional, default is 3306
  199. sql_query_pre = SET NAMES utf8
  200.  
  201. sql_query = select id, keywords, status, crc32(keywords) as keywords_crc,\
  202. UNIX_TIMESTAMP(date_added) as date_added \
  203. from dk_sph_stats;
  204.  
  205. sql_attr_uint = status
  206. sql_attr_uint = keywords_crc
  207. sql_attr_timestamp = date_added
  208. }
  209.  
  210. index dk_stats
  211. {
  212. source = dk_stats
  213. path = /home/example.com/public_html/wp-content/uploads/sphinx/var/data/dk_stats
  214. docinfo = extern
  215. morphology = stem_enru
  216. html_strip = 1
  217. charset_type = utf-8
  218. charset_table = 0..9, U+27, U+41..U+5a->U+61..U+7a, U+61..U+7a, U+aa, U+b5, U+ba, U+c0..U+d6->U+e0..U+f6, U+d8..U+de->U+f8..U+fe, U+df..U+f6, U+f8..U+ff, U+100..U+12f/2, U+130->U+69, U+131, U+132..U+137/2, U+138, U+139..U+148/2, U+149, U+14a..U+177/2, U+178->U+ff, U+179..U+17e/2, U+17f..U+180, U+181->U+253, U+182..U+185/2, U+186->U+254, U+187..U+188/2, U+189..U+18a->U+256..U+257, U+18b..U+18c/2, U+18d, U+18e->U+1dd, U+18f->U+259, U+190->U+25b, U+191..U+192/2, U+193->U+260, U+194->U+263, U+195, U+196->U+269, U+197->U+268, U+198..U+199/2, U+19a..U+19b, U+19c->U+26f, U+19d->U+272, U+19e, U+19f->U+275, U+1a0..U+1a5/2, U+1a6->U+280, U+1a7..U+1a8/2, U+1a9->U+283, U+1aa..U+1ab, U+1ac..U+1ad/2, U+1ae->U+288, U+1af..U+1b0/2, U+1b1..U+1b2->U+28a..U+28b, U+1b3..U+1b6/2, U+1b7->U+292, U+1b8..U+1b9/2, U+1ba..U+1bb, U+1bc..U+1bd/2, U+1be..U+1c3, U+1c4->U+1c6, U+1c5..U+1c6/2, U+1c7->U+1c9, U+1c8..U+1c9/2, U+1ca->U+1cc, U+1cb..U+1dc/2, U+1dd, U+1de..U+1ef/2, U+1f0, U+1f1->U+1f3, U+1f2..U+1f5/2, U+1f6->U+195, U+1f7->U+1bf, U+1f8..U+21f/2, U+220->U+19e, U+221, U+222..U+233/2, U+234..U+23a, U+23b..U+23c/2, U+23d->U+19a, U+23e..U+240, U+241->U+294, U+250..U+2c1, U+2c6..U+2d1, U+2e0..U+2e4, U+2ee, U+37a, U+386..U+389->U+3ac..U+3af, U+38c..U+38e->U+3cc..U+3ce, U+390, U+391..U+3a1->U+3b1..U+3c1, U+3a3..U+3ab->U+3c3..U+3cb, U+3ac..U+3ce, U+3d0..U+3d7, U+3d8..U+3ef/2, U+3f0..U+3f3, U+3f4->U+3b8, U+3f5, U+3f7..U+3f8/2, U+3f9->U+3f2, U+3fa..U+3fb/2, U+3fc..U+3ff, U+400..U+40f->U+450..U+45f, U+410..U+42f->U+430..U+44f, U+430..U+45f, U+460..U+481/2, U+48a..U+4bf/2, U+4c0, U+4c1..U+4ce/2, U+4d0..U+4f9/2, U+500..U+50f/2, U+531..U+556->U+561..U+586, U+559, U+561..U+587, U+5d0..U+5ea, U+5f0..U+5f2, U+621..U+63a, U+640..U+64a, U+66e..U+66f, U+671..U+6d3, U+6d5, U+6e5..U+6e6, U+6ee..U+6ef, U+6fa..U+6fc, U+6ff, U+e01..U+e30, U+e32..U+e33, U+e40..U+e46, U+e81..U+e82, U+e84, U+e87..U+e88, U+e8a, U+e8d, U+e94..U+e97, U+e99..U+e9f, U+ea1..U+ea3, U+ea5, U+ea7, U+eaa..U+eab, U+ead..U+eb0, U+eb2..U+eb3, U+ebd, U+ec0..U+ec4, U+ec6, U+edc..U+edd, U+1000..U+1021, U+1023..U+1027, U+1029..U+102a, U+1050..U+1055, U+10a0..U+10c5->U+2d00..U+2d25, U+10d0..U+10fa, U+10fc, U+2d00..U+2d25, U+1d00..U+1dbf, U+1e00..U+1e95/2, U+1e96..U+1e9b, U+1ea0..U+1ef9/2, U+3005..U+3006, U+3031..U+3035, U+303b..U+303c, U+3041..U+3096, U+309d..U+309f, U+30a1..U+30fa, U+30fc..U+30ff, U+31f0..U+31ff
  219. }
  220.  
  221. indexer
  222. {
  223. mem_limit = 32M
  224. }
  225.  
  226. searchd
  227. {
  228. listen = 127.0.0.1:9312
  229. binlog_path = # disable logging
  230. read_timeout = 5
  231. max_children = 30
  232. pid_file = /home/example.com/public_html/wp-content/uploads/sphinx/var/log/searchd.pid
  233. max_matches = 100000
  234. log = /home/example.com/public_html/wp-content/uploads/sphinx/var/log/searchd.log
  235. query_log = /home/example.com/public_html/wp-content/uploads/sphinx/var/log/query.log
  236. }
  237.  
  238. # --eof--
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!