indexer
{
    mem_limit = 512M
}

source base {
    type          = mysql
    sql_host      = 127.0.0.1
    sql_user      = root
    sql_pass      = abc1234$
    sql_db        = qole
    sql_port      = 3306

    sql_query_pre  = SET NAMES utf8
    sql_query_pre  = SET CHARACTER SET utf8
    sql_query_pre  = SET CHARACTER_SET_RESULTS=utf8
}

#### sql_field_ => save and create index, sql_attr_ => only save not create index
#### string => string, uint => integer. float => float, timestamp => timestamp

source shops:base
{
    sql_query          = SELECT id, area_id, name, slug, description, logo, is_activated, UNIX_TIMESTAMP(created_at) AS created_at FROM shops
    sql_field_string   = name
    sql_attr_uint      = area_id
    sql_attr_string    = slug
    sql_attr_string    = description
    sql_attr_string    = logo
    sql_attr_uint      = is_activated
    sql_attr_timestamp = created_at
}

index shops_index
{
    source            = shops
    path              = /var/lib/sphinxsearch/data/shops_index
    docinfo           = extern
    min_word_len      = 1
    min_prefix_len    = 0
}

searchd
{
    listen            = 9306:mysql41
    log               = /var/log/sphinxsearch/searchd.log
    query_log         = /var/log/sphinxsearch/query.log
    read_timeout      = 5
    max_children      = 30
    pid_file          = /var/run/sphinxsearch/searchd.pid
    seamless_rotate   = 1
    preopen_indexes   = 1
    unlink_old        = 1
    binlog_path       = /var/lib/sphinxsearch/data
}