Форум

#
# Minimal Sphinx configuration for Bitrix
#
searchd
{
    listen         = 9312
    listen         = 9306:mysql41
    log         = /var/log/sphinx/searchd.log
    query_log      = /var/log/sphinx/query.log
    read_timeout      = 5
    max_children      = 30
    pid_file      = /var/run/sphinx/searchd.pid
    #max_matches      = 1000
    seamless_rotate      = 1
    preopen_indexes      = 1
    unlink_old      = 1
    workers         = threads # for RT to work
    binlog_path      = /var/lib/sphinx/
    binlog_max_log_size    = 512M
    binlog_flush      = 2
    rt_flush_period      = 3600
}

indexer
{
    lemmatizer_cache   = 128M
    #lemmatizer_base   = /etc/sphinx/dicts/   # lemmatizer_base в Sphinx 2.2.1+ располагается в секции common
}
common
{
    lemmatizer_base       = /usr/share/sphinx/dicts/
}

index bitrix
{
   #main settings
      type = rt
       path            = /var/lib/sphinx/testrt

      docinfo = inline
   #choose appropriate type of morphology to use
      #morphology = lemmatize_ru_all, lemmatize_en_all, lemmatize_de_all, stem_enru
      morphology = stem_enru, soundex
   #these settings are used by bitrix:search.title component
      dict = keywords
      prefix_fields = title
      infix_fields=
      min_prefix_len = 2
   #   enable_star = 1
   #all fields must be defined exactly as followed
      rt_field = title
      rt_field = body
      rt_attr_uint = module_id
      rt_attr_string = module
      rt_attr_uint = item_id
      rt_attr_string = item
      rt_attr_uint = param1_id
      rt_attr_string = param1
      rt_attr_uint = param2_id
      rt_attr_string = param2
      rt_attr_timestamp = date_change
      rt_attr_timestamp = date_to
      rt_attr_timestamp = date_from
      rt_attr_uint = custom_rank
      rt_attr_multi = tags
      rt_attr_multi = right
      rt_attr_multi = site
      rt_attr_multi = param
   #depends on settings of your site
      # uncomment for single byte character set
      #charset_type = sbcs
      # uncomment for UTF character set
      #charset_type = utf-8
}

source bitrix
{
   type         = mysql
   sql_host      = localhost
   sql_user      = catalog
   sql_pass      = ******
   sql_db         = *****
   sql_port      = 9306   # optional, default is 3306
 
   sql_query_pre = SET NAMES utf8
   sql_query_pre = SET CHARACTER SET utf8
 
   sql_query      = \
      SEL ECT id, group_id, UNIX_TIMESTAMP(date_added) AS date_added, title, content \
      FR OM documents
 
 
   sql_attr_uint      = group_id
   sql_attr_timestamp   = date_added
   sql_ranged_throttle   = 0
   #sql_query_info      = SELECT * FR OM documents WH ERE id=$id
 
}