sphinx.conf

source src1
        {
        type                    = mysql

        #####################################################################
        ## SQL settings (for 'mysql' and 'pgsql' types)
        #####################################################################

        # some straightforward parameters for SQL source types
        sql_host                = localhost
        sql_user                = postgres
        sql_pass                = '12345678'
        sql_db                  = stackowf_production
        sql_port                = 3306

        sql_query               = \
        sql_attr_uint           = group_id
        sql_attr_timestamp      = date_added
        sql_ranged_throttle     = 0

        }

source src1throttled : src1
        {
                sql_ranged_throttle     = 100
        }

index test1
        {
                mlock                   = 0
                min_word_len            = 1
                charset_type            = sbcs
                html_strip              = 0
        }
index test1stemmed : test1
        {
                path                    = /var/lib/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                    = /home/stackowf/shared/tmp/indexes
                rt_field                = title
                rt_field                = content
                rt_attr_uint            = gid
        }

indexer
        {
                mem_limit               = 32M
        }

searchd
        {
                listen                  = 9312
                listen                  = 9306:mysql41
                log                     = /home/stackowf/shared/tmp/searchd.log
                query_log               = /home/stackowf/shared/tmp/query.log
                read_timeout            = 5
                client_timeout          = 300
                max_children            = 30
                pid_file                = /home/stackowf/shared/tmp/searchd.pid
                max_matches             = 1000
                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
          }