indexer
{
    mem_limit = 512M
}

source base {
    type          = mysql
    sql_host      = localhost
    sql_user      = root
    sql_pass      = abc1234$
    sql_db        = gxomens
    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 posts:base
{
    sql_query      = SELECT * FROM posts WHERE is_activated = 1 and is_deleted = 0
    #'id', 'key', 'title', 'slug', 'category_id', 'board_id', 'image', 'tags', 'url', 'url_title', 'description', 'content', 'views', 'like', 'pin', 'user_id', 'is_activated', 'is_deleted'

    sql_field_string   = title
    sql_attr_uint      = category_id
    sql_attr_string    = key
    sql_attr_string    = image
    sql_attr_string    = slug
}

index posts_index
{
    source            = posts
    path              = /var/lib/sphinxsearch/data/posts_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
}