#
# sphinx configuration file sample
#

## data source definition

source products
{
    type            = mysql
    sql_host        = localhost
    sql_user        = root
    sql_pass        =
    sql_db          = perfume
    sql_sock        = /tmp/mysql.sock

    sql_query       = \
        SELECT products.id, products.name, brands.name, products.description \
        FROM products INNER JOIN brands ON products.brand_id = brands.id
}

## index definition

index products
{
    source          = products
    path            = ../sphinx/products

    # morphology
    morphology      = stem_en
}

## indexer settings

indexer
{
    # memory limit
    mem_limit       = 32M
}

## searchd settings

searchd
{
    address         = 127.0.0.1
    port            = 3312
    log             = ../log/searchd.log
    query_log       = ../log/searchd_query.log
    read_timeout    = 5
    max_children    = 30
    pid_file        = ../log/searchd.pid
    max_matches     = 1000
}