Don't like ads? PRO users don't see any ads ;-)
Public Pastes

sphinx.conf

By: techouse on Mar 24th, 2012  |  syntax: PHP  |  size: 12.10 KB  |  hits: 53  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. #!/usr/bin/php -q
  2. <?php
  3. error_reporting(0);
  4. $path_to_config = "/usr/share/wordpress";
  5. if ( file_exists( $path_to_config . '/wp-config.php') ) {
  6.  
  7.     /** The config file resides in ABSPATH */
  8.     require_once( $path_to_config . '/wp-config.php' );
  9.  
  10. } elseif ( file_exists( dirname($path_to_config) . '/wp-config.php' ) && ! file_exists( dirname($path_to_config) . '/wp-settings.php' ) ) {
  11.  
  12.     /** The config file resides one level above ABSPATH but is not part of another install*/
  13.     require_once( dirname($path_to_config) . '/wp-config.php' );
  14.  
  15. }
  16. ini_set('short_open_tag', 0);
  17. ?>
  18. ##########################
  19. # WARNING: it is not original sphinx.conf - this file adopted to sphinx
  20. # which installed by wordpress Sphinx Search plugin.
  21. # Don't use this file as example of sphinx configuration,
  22. # better visit the official doc page at http://www.sphinxsearch.com/doc.html
  23. ##########################
  24.  
  25.  
  26. source csawi_main_posts
  27. {
  28.         type    = mysql
  29.         sql_host        = <?php echo DB_HOST."\n"?>
  30.         sql_user        = <?php echo DB_USER."\n"?>
  31.         sql_pass        = <?php echo DB_PASSWORD."\n"?>
  32.         sql_db          = <?php echo DB_NAME."\n"?>
  33.   sql_sock = /var/lib/mysql/mysql.sock
  34.         sql_port        = 3306  # optional, default is 3306
  35.         sql_query_pre   = SET NAMES utf8
  36.         sql_query_pre   = REPLACE INTO <?php echo $table_prefix?>sph_counter SELECT 1, MAX(id) FROM csawi_posts
  37.         sql_query_range = SELECT MIN(id),( SELECT max_doc_id FROM <?php echo $table_prefix?>sph_counter WHERE counter_id=1 ) FROM csawi_posts
  38.         sql_range_step = 1000
  39.  
  40.         sql_query               = select \
  41.                 p.ID*2+1 as ID, \
  42.                 0 as comment_ID,\
  43.                 p.ID as post_ID,\
  44.                 p.post_title as title, \
  45.                 p.post_content as body, \
  46.                 t.name as category, \
  47.                 IF(p.post_type = 'post', 1, 0) as isPost, \
  48.                 0 as isComment, \
  49.                 IF(p.post_type = 'page', 1, 0) as isPage, \
  50.                 IF(p.post_type = 'post', 0, IF(p.post_type = 'page', 1, 2)) as post_type, \
  51.                 UNIX_TIMESTAMP(post_date) AS date_added \
  52.         from \
  53.                 csawi_posts as p \
  54.         left join \
  55.                 csawi_term_relationships tr on (p.ID = tr.object_id) \
  56.         left join \
  57.                 csawi_term_taxonomy tt on (tt.term_taxonomy_id = tr.term_taxonomy_id and tt.taxonomy = 'category') \
  58.         left join \
  59.                 csawi_terms t on (tt.term_id = t.term_id) \
  60.         where \
  61.                 p.id>=$start AND p.id<=$end and \
  62.                 p.post_status = 'publish' \
  63.         group by p.ID
  64.  
  65.         sql_attr_uint           = comment_ID
  66.         sql_attr_uint           = post_ID
  67.         sql_attr_uint           = isPost
  68.         sql_attr_uint           = isPage
  69.         sql_attr_uint           = isComment
  70.         sql_attr_uint           = post_type
  71.         sql_attr_timestamp      = date_added
  72. }
  73.  
  74. source csawi_main_comments
  75. {
  76.         type    = mysql
  77.         sql_host        = <?php echo DB_HOST."\n"?>
  78.         sql_user        = <?php echo DB_USER."\n"?>
  79.         sql_pass        = <?php echo DB_PASSWORD."\n"?>
  80.         sql_db          = <?php echo DB_NAME."\n"?>
  81.   sql_sock = /var/lib/mysql/mysql.sock
  82.         sql_port        = 3306  # optional, default is 3306
  83.         sql_query_pre   = SET NAMES utf8
  84.         sql_query_pre   = REPLACE INTO <?php echo $table_prefix?>sph_counter SELECT 2, MAX(comment_id) FROM csawi_comments
  85.         sql_query_range = SELECT MIN(comment_id),( SELECT max_doc_id FROM <?php echo $table_prefix?>sph_counter WHERE counter_id=2 ) FROM csawi_comments
  86.         sql_range_step = 1000
  87.  
  88.         sql_query               = select \
  89.                 c.comment_ID*2 as ID, \
  90.                 c.comment_ID as comment_ID,\
  91.                 c.comment_post_ID as post_ID,\
  92.                 '' as title, \
  93.                 c.comment_content as body, \
  94.                 '' as category, \
  95.                 0 as isPost, \
  96.                 1 as isComment, \
  97.                 0 as isPage, \
  98.                 2 as post_type, \
  99.                 UNIX_TIMESTAMP(comment_date) AS date_added \
  100.         from \
  101.                 csawi_comments as c \
  102.         where \
  103.                 c.comment_id>=$start AND c.comment_id<=$end and \
  104.                 c.comment_approved = '1';
  105.  
  106.         sql_attr_uint           = comment_ID
  107.         sql_attr_uint           = post_ID
  108.         sql_attr_uint           = isPost
  109.         sql_attr_uint           = isPage
  110.         sql_attr_uint           = isComment
  111.         sql_attr_uint           = post_type
  112.         sql_attr_timestamp      = date_added
  113. }
  114.  
  115. source csawi_delta_posts : csawi_main_posts
  116. {
  117.     sql_query_range     = SELECT ( SELECT max_doc_id FROM <?php echo $table_prefix?>sph_counter where counter_id = 1 ), MAX(id) FROM csawi_posts
  118.     sql_range_step = 1000
  119.     sql_query_pre       = SET NAMES utf8
  120.  
  121.     sql_query   = select \
  122.                 p.ID*2+1 as ID, \
  123.                 0 as comment_ID,\
  124.                 p.ID as post_ID,\
  125.                 p.post_title as title, \
  126.                 p.post_content as body, \
  127.                 t.name as category, \
  128.                 IF(p.post_type = 'post', 1, 0) as isPost, \
  129.                 0 as isComment, \
  130.                 IF(p.post_type = 'page', 1, 0) as isPage, \
  131.                 IF(p.post_type = 'post', 0, IF(p.post_type = 'page', 1, 2)) as post_type, \
  132.             UNIX_TIMESTAMP(post_date) AS date_added \
  133.         from \
  134.                 csawi_posts as p \
  135.         left join \
  136.                 csawi_term_relationships tr on (p.ID = tr.object_id) \
  137.         left join \
  138.                 csawi_term_taxonomy tt on (tt.term_taxonomy_id = tr.term_taxonomy_id and tt.taxonomy = 'category') \
  139.         left join \
  140.                 csawi_terms t on (tt.term_id = t.term_id) \
  141.         where \
  142.                  p.id>$start AND p.id<=$end and \
  143.                 p.post_status = 'publish' \
  144.         group by p.ID ;
  145. }
  146.  
  147. source csawi_delta_comments : csawi_main_comments
  148. {
  149.     sql_query_range     = SELECT ( SELECT max_doc_id FROM <?php echo $table_prefix?>sph_counter where counter_id = 2 ), MAX(comment_id) FROM csawi_comments
  150.     sql_range_step = 1000
  151.     sql_query_pre       = SET NAMES utf8
  152.  
  153.     sql_query   = select \
  154.                 c.comment_ID*2 as ID, \
  155.                 c.comment_ID as comment_ID,\
  156.                 c.comment_post_ID as post_ID,\
  157.                 '' as title, \
  158.                 c.comment_content as body, \
  159.                 '' as category, \
  160.                 0 as isPost, \
  161.                 1 as isComment, \
  162.                 0 as isPage, \
  163.                 2 as post_type, \
  164.             UNIX_TIMESTAMP(comment_date) AS date_added \
  165.         from \
  166.                 csawi_comments as c \
  167.         where \
  168.                 c.comment_id>$start AND c.comment_id<=$end and \
  169.                 c.comment_approved = '1';
  170. }
  171.  
  172. index csawi_main
  173. {
  174.         source  = csawi_main_posts
  175.         source  = csawi_main_comments
  176.         path    = /usr/share/wordpress/wp-content/uploads/sphinx/var/data/csawi_main
  177.         docinfo = extern
  178.         morphology      = stem_enru
  179.         html_strip              = 1
  180.         charset_type    = utf-8
  181.         charset_table   = 0..9,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
  182.  
  183. }
  184.  
  185. index csawi_delta : csawi_main
  186. {
  187.     source      = csawi_delta_posts
  188.     source      = csawi_delta_comments
  189.     path        = /usr/share/wordpress/wp-content/uploads/sphinx/var/data/csawi_delta
  190. }
  191.  
  192. index csawi_
  193. {
  194.     type        = distributed
  195.     local       = csawi_main
  196.     local       = csawi_delta
  197. }
  198.  
  199. source csawi_stats
  200. {
  201.     type        = mysql
  202.     sql_host    = <?php echo DB_HOST."\n"?>
  203.     sql_user    = <?php echo DB_USER."\n"?>
  204.     sql_pass    = <?php echo DB_PASSWORD."\n"?>
  205.     sql_db              = <?php echo DB_NAME."\n"?>
  206.   sql_sock = /var/lib/mysql/mysql.sock
  207.     sql_port    = 3306  # optional, default is 3306
  208.     sql_query_pre       = SET NAMES utf8
  209.  
  210.     sql_query   =  select id, keywords, status, crc32(keywords) as keywords_crc,\
  211.     UNIX_TIMESTAMP(date_added) as date_added \
  212.     from <?php echo $table_prefix?>sph_stats;
  213.  
  214.     sql_attr_uint       = status
  215.     sql_attr_uint       = keywords_crc
  216.     sql_attr_timestamp  = date_added
  217. }
  218.  
  219. index csawi_stats
  220. {
  221.         source  = csawi_stats
  222.         path    = /usr/share/wordpress/wp-content/uploads/sphinx/var/data/csawi_stats
  223.         docinfo = extern
  224.         morphology      = stem_enru
  225.         html_strip              = 1
  226.         charset_type    = utf-8
  227.         charset_table   = 0..9,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
  228. }
  229.  
  230. indexer
  231. {
  232.         mem_limit       = 32M
  233. }
  234.  
  235. searchd
  236. {
  237.         port                    = 9312
  238.         read_timeout    = 5
  239.         max_children    = 30
  240.         pid_file                = /usr/share/wordpress/wp-content/uploads/sphinx/var/log/searchd.pid
  241.         max_matches             = 100000
  242.         log                             = /usr/share/wordpress/wp-content/uploads/sphinx/var/log/searchd.log
  243.         query_log               = /usr/share/wordpress/wp-content/uploads/sphinx/var/log/query.log
  244. }
  245.  
  246. # --eof--
create a new version of this paste RAW Paste Data