vim /usr/local/etc/sphinx.conf
source src1
{
    type            = mysql
    sql_host        = 127.0.0.1
    sql_user        = test
    sql_pass        =
    sql_db            = test
    sql_port        = 3306    # optional, default is 3306
    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
}
source src1throttled : src1
{
    sql_ranged_throttle    = 100
}
index test1
{
    source            = src1
    path            = /var/db/sphinxsearch/data/test1
    docinfo            = extern
    dict            = keywords
    mlock            = 0
    morphology        = none
    min_word_len        = 1
    html_strip        = 0
}
index test1stemmed : test1
{
    path            = /var/db/sphinxsearch/data/test1stemmed
    morphology        = stem_en
}
index dist1
{
    type            = distributed
    local            = test1
    local            = test1stemmed
    agent            = localhost:9313:remote1
    agent            = localhost:9314:remote2,remote3
    agent_connect_timeout    = 1000
    agent_query_timeout        = 3000
}
index rt
{
    type            = rt
    path            = /var/db/sphinxsearch/data/rt
    rt_field        = title
    rt_field        = content
    rt_attr_uint        = gid
}
indexer
{
    mem_limit        = 128M
}
searchd
{
    listen            = 9312
    listen            = 9306:mysql41
    log            = /var/log/sphinxsearch/searchd.log
    query_log        = /var/log/sphinxsearch/sphinx-query.log
    read_timeout        = 5
    client_timeout        = 300
    max_children        = 30
    persistent_connections_limit    = 30
    pid_file        = /var/run/sphinxsearch/searchd.pid
    seamless_rotate        = 1
    preopen_indexes        = 1
    unlink_old        = 1
    mva_updates_pool    = 1M
    max_packet_size        = 8M
    max_filters        = 256
    max_filter_values    = 4096
    max_batch_queries    = 32
    workers            = threads # for RT to work
}

results matching ""

    No results matching ""