Sphinx Config

#
# Minimal Sphinx configuration sample (clean, simple, functional)
#

source articles
{
        type                    = mysql

        sql_host                = localhost
        sql_user                = myusername
        sql_pass                = mypassword
        sql_db                  = mydatabase
        sql_port                = 3306  # optional, default is 3306

        sql_query               = SELECT ID AS ArticleID, Title, Description FROM articles

        # sql_attr_timestamp    = date_added
        sql_query_info          = SELECT * FROM articles WHERE ID=$id
}

index articles
{
        source                  = articles
        path                    = data/articles
        docinfo                 = extern
        charset_type            = utf-8
        min_word_len            = 3
        min_prefix_len          = 0
        min_infix_len           = 3
}

source publications
{
        type                    = mysql

        sql_host                = localhost
        sql_user                = myusername
        sql_pass                = mypassword
        sql_db                  = mydatabase
        sql_port                = 3306  # optional, default is 3306

        sql_query               = SELECT Title_ID AS PublicationID, Title_ID, Title, PageTitle, PageContent, Description FROM publications
        #sql_attr_unit          = PublicationID
        sql_query_info          = SELECT * FROM publications WHERE Title_ID=$id
}

index publications
{
        source                  = publications
        path                    = data/publications
        docinfo                 = extern
        charset_type            = utf-8
        min_word_len            = 3
        min_prefix_len          = 0
        min_infix_len           = 3
}

source library_content
{
        type                    = mysql

        sql_host                = localhost
        sql_user                = myusername
        sql_pass                = mypassword
        sql_db                  = mydatabase
        sql_port                = 3306  # optional, default is 3306

        sql_query               = SELECT ArticleID AS LibraryID, FileText FROM library_article_content
        sql_query_info          = SELECT * FROM library_article_content WHERE ArticleID=$id
}

index library_content
{
        source                  = library_content
        path                    = data/library_content
        docinfo                 = extern
        charset_type            = utf-8
        min_word_len            = 3
        min_prefix_len          = 0
}

source tt_content
{
        type                    = mysql

        sql_host                = localhost
        sql_user                = myusername
        sql_pass                = mypassword
        sql_db                  = mydatabase
        sql_port                = 3306  # optional, default is 3306

        sql_query               = SELECT ArticleID AS TTID, PageContent FROM tt_article_content
        #sql_attr_unit          = TTID
        sql_query_info          = SELECT * FROM tt_article_content WHERE ArticleID=$id
}

index tt_content
{
        source                  = tt_content
        path                    = data/tt_content
        docinfo                 = extern
        charset_type            = utf-8
        min_word_len            = 3
        min_prefix_len          = 0
        min_infix_len           = 3
}

indexer
{
        mem_limit               = 32M
}

searchd
{
        listen                  = 9312
        listen                  = 3312:mysql41
        log                     = /var/log/searchd.log
        query_log               = /var/log/query.log
        read_timeout            = 5
        max_children            = 0
        pid_file                = /var/log/searchd.pid
        max_matches             = 1000
        seamless_rotate         = 1
        preopen_indexes         = 1
        unlink_old              = 1
        workers                 = threads # for RT to work
        binlog_path             = /var/data
}