Форум

indexer
{
     mem_limit         = 32M
}searchd
{
   #local sets######################
   listen      = 9306
   log      = /sphinx/log/searchd.log   
   query_log   = /sphinx/log/query.log
   pid_file   = /sphinx/log/searchd.pid

   seamless_rotate   = 1
    preopen_indexes   = 1
    unlink_old   = 1
    workers      = threads # for RT to work
    binlog_path   = /sphinx/data

   
   #default sets ###################
   read_timeout   = 5
   max_children   = 30   
   max_matches   = 1000

}

source db_parent_src
{
   type      = mysql
   
   #local sets##################
   sql_host   = localhost
   sql_user   = user
   sql_pass   = pass
   sql_db      = db
   sql_port   = port
   
   sql_query_pre    = SET NAMES utf8
    sql_query_pre    = SET CHARACTER SET utf8
   
   sql_ranged_throttle   = 200
   sql_attr_string  = source_title
}



#sphinx.conf
index bitrix
{
   #main settings
   type = rt
   path = /sphinx/data/bitrix
   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 db_parent_src

indexer
{
   mem_limit      = 32M
}


searchd
{
        listen                  = 127.0.0.1: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
}



source art
{
   type         = mysql
   sql_host      = localhost
   sql_user      = имя пользователя базы
   sql_pass      = пароль пользователя базы
   sql_db         = база
   sql_port      = 3306   # optional, default is 3306
 
   sql_query_pre = SET NAMES utf8
   sql_query_pre = SET CHARACTER SET utf8
 
   sql_query      = \
      SELECT id, group_id, UNIX_TIMESTAMP(date_added) AS date_added, title, content \
      FROM documents
 
 
   sql_attr_uint      = group_id
   sql_attr_timestamp   = date_added
   sql_ranged_throttle   = 0
   sql_query_info      = SELECT * FROM documents WHERE id=$id
 
}


index имя папки сами придумайте, у меня по названию сайта(site) 
{
   #main settings
   source         = art (это название настроек базы - см. выше source)
      type = rt
      path = /var/lib/sphinx/имя папки
      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
}