# sphinx config
source pages
{
  type        = mysql
  # whether to strip HTML
  # values can be 0 (don't strip) or 1 (do strip)
  # WARNING, only works with mysql source for now
  # WARNING, should work ok for PERFECTLY formed XHTML for now
  # WARNING, POSSIBLE TO BUG on malformed everday HTML
  # optional, default is 0
  strip_html      = 1
 
  # what HTML attributes to index if stripping HTML
  # format is as follows:
  #
  index_html_attrs  = img=alt,title; a=title;
  
  sql_host      = <%= sphinx_db_host %>
  sql_user      = <%= sphinx_db_user %>
  sql_pass      = <%= sphinx_db_pass %>
  sql_db        = <%= sphinx_db_name %>
  sql_port      = <%= sphinx_db_port %> # optional, default is 3306
 
  sql_query_pre = SET NAMES UTF8
  sql_query_pre = SET SESSION query_cache_type=OFF
  sql_query_pre = INSERT INTO indexer_status (started_at, status, index_name, hostname) VALUES (NOW(), 'indexing', 'pages', USER()) \
    ON DUPLICATE KEY UPDATE started_at = NOW(), status = 'indexing'
  
  sql_query = SELECT id, user_id, language, UNIX_TIMESTAMP(created_at) AS created_at, UNIX_TIMESTAMP(updated_at) AS updated_at, body, title FROM pages WHERE id>=$start AND id<=$end
  sql_query_range = SELECT MIN(id),MAX(id) FROM pages where type='Article'
  sql_range_step = 1000
  
  sql_query_post = UPDATE indexer_status SET updated_at = NOW(), status = 'updated' WHERE index_name = 'pages' and hostname = USER()
  
  sql_attr_uint      = user_id
  sql_attr_timestamp = created_at
  sql_attr_timestamp = updated_at
}
 
source pages_delta : pages
{
  # Clear and reset sql_query_pre
  sql_query_pre =
  sql_query_pre = SET NAMES UTF8
  sql_query_pre = SET SESSION query_cache_type=OFF
  sql_query_pre = INSERT INTO indexer_status (id, started_at, status, index_name, hostname) VALUES (NOW(), 'indexing', 'pages_delta', USER()) \
    ON DUPLICATE KEY UPDATE started_at = NOW(), status = 'indexing'
  
  sql_query = SELECT id, user_id, language, UNIX_TIMESTAMP(created_at) AS created_at, UNIX_TIMESTAMP(updated_at) AS updated_at, body, title \
   FROM pages \
   WHERE updated_at >= (SELECT updated_at FROM indexer_status WHERE index_name = 'pages_delta' and hostname = USER())  
   
  sql_query_post = 
  sql_query_post = UPDATE indexer_status SET updated_at = NOW(), status = 'updated' WHERE index_name = 'pages_delta' and hostname = USER()
  sql_query_range =
  sql_range_step =
}
 
index pages
{
  source      = pages
  path      = <%= sphinx_index_root %>/pages
  docinfo      = extern
  morphology    = stem_en
  stopwords      = <%= sphinx_conf_path %>/stopwords.txt
  min_word_len    = 1
  charset_type    = utf-8
  min_prefix_len    = 0
  min_infix_len    = 0
}
 
index pages_delta : pages
{
  source           = pages_delta
  path             = <%= sphinx_index_root %>/pages_delta
  
}
 
#############################################################################
## indexer settings
#############################################################################
 
indexer
{
  # memory limit
  #
  # may be specified in bytes (no postfix), kilobytes (mem_limit=1000K)
  # or megabytes (mem_limit=10M)
  #
  # will grow if set unacceptably low
  # will warn if set too low and potentially hurting the performance
  #
  # optional, default is 32M
  mem_limit      = 64M
}
 
#############################################################################
## searchd settings
#############################################################################
 
searchd
{
  # IP address on which search daemon will bind and accept
  # incoming network requests
  #
  # optional, default is to listen on all addresses,
  # ie. address = 0.0.0.0
  #
  address        = <%= sphinx_host %>
  # address        = 192.168.0.1
 
 
  # port on which search daemon will listen
  port        = <%= sphinx_port %>
 
 
  # log file
  # searchd run info is logged here
  log          = <%= sphinx_log_root %>/searchd.log
 
 
  # query log file
  # all the search queries are logged here
  query_log      = <%= sphinx_log_root %>/query.log
 
 
  # client read timeout, seconds
  read_timeout    = 5
 
 
  # maximum amount of children to fork
  # useful to control server load
  max_children    = 30
 
 
  # a file which will contain searchd process ID
  # used for different external automation scripts
  # MUST be present
  pid_file      = <%= sphinx_pid_path %>
 
 
  # maximum amount of matches this daemon would ever retrieve
  # from each index and serve to client
  #
  # this parameter affects per-client memory and CPU usage
  # (16+ bytes per match) in match sorting phase; so blindly raising
  # it to 1 million is definitely NOT recommended
  #
  # starting from 0.9.7, it can be decreased on the fly through
  # the corresponding API call; increasing is prohibited to protect
  # against malicious and/or malformed requests
  #
  # default is 1000 (just like with Google)
  max_matches      = 1000
}
 
# --eof--