sphinx - config

source products
{
      type          = mysql
      sql_host      = localhost
      sql_user      = user
      sql_pass      = pass
      sql_db        =  bd_name
      sql_port        = 3306

      sql_query_pre        = SET NAMES utf8
      sql_query_pre        = SET CHARACTER SET utf8

      sql_query            = SELECT id, product_code, name, supplier_article FROM products
      sql_field_string = name
}

index products_index
{
      source            = products
      path              = /var/lib/sphinxsearch/data/products_index
      min_word_len       = 2
      min_infix_len = 2
      morphology        = stem_enru, Soundex, Metaphone
      expand_keywords = 1
      index_exact_words = 1
        charset_table = 0..9, A..Z->a..z, _, a..z, \
    U+410..U+42F->U+430..U+44F, U+430..U+44F, U+401->U+0435, U+451->U+0435
      html_strip = 1
}