sphinx.conf

# This file will be generated using Emacs Lisp, don't modify it
# unless you know what you are doing.

source base
{
    type = mysql
    
    # some straightforward parameters for SQL source types
    sql_host = 127.0.0.1
    sql_user = emacs
    sql_pass = emacs
    sql_db = emacs_user
    sql_port = 3306  #default is 3306
}
  
source emacs_user_documents : base
{
    # main document fetch query
    # mandatory, integer document ID field MUST be the first selected column
    sql_query = \
        SELECT \
            documents.id AS id, \
            documents.document AS document \
        FROM documents \
                WHERE \
            documents.id >= $start and documents.id <= $end \

	# range query setup, query that must return min and max ID values
	# optional, default is empty
	#
	# sql_query will need to reference $start and $end boundaries
	# if using ranged query:
	#
	# sql_query		= \
	#	SELECT doc.id, doc.id AS group, doc.title, doc.data \
	#	FROM documents doc \
	#	WHERE id>=$start AND id<=$end
	#
	sql_query_range = SELECT MIN(id), MAX(id) FROM documents

    sql_file_field = document
    sql_field_string = document
 
    # ranged query throttling, in milliseconds
    # optional, default is 0 which means no delay
    # enforces given delay before each query step
    sql_ranged_throttle = 0
}

# source info
# {
#     type = xmlpipe2
#     xmlpipe_command = emacsclient -e '(sphinx-info-build-index)'
# }

source emacs_user_info : base
{
    type = mysql
    sql_query = \
        SELECT \
            info.id AS id, \
            info.node AS node, \
            info.contents AS contents \
        FROM info \
                WHERE \
            info.id >= $start and info.id <= $end \

	sql_query_range = SELECT MIN(id), MAX(id) FROM info
    sql_field_string = node
    sql_field_string = contents
    sql_ranged_throttle = 0
}

index emacs_user
{
    type = plain

    # document source(s) to index
    # multi-value, mandatory
    # document IDs must be globally unique across all sources
    source = emacs_user_documents

    # a list of morphology preprocessors to apply
    # optional, default is empty
    #
    # builtin preprocessors are 'none', 'stem_en', 'stem_ru', 'stem_enru',
    # 'soundex', and 'metaphone'; additional preprocessors available from
    # libstemmer are 'libstemmer_XXX', where XXX is algorithm code
    # (see libstemmer_c/libstemmer/modules.txt)
    #
    # morphology        = stem_en, stem_ru, soundex
    # morphology        = libstemmer_german
    # morphology        = libstemmer_sv
    morphology = stem_en

    # index files path and file name, without extension
    # mandatory, path must be writable, extensions will be auto-appended
    path = /home/wvxvw/.emacs.d/sphinx/var/data/user_documents

  	# minimum indexed word length
	# default is 1 (index everything)
	min_word_len = 1

    preopen = 1

    # whether to strip HTML tags from incoming documents
    # known values are 0 (do not strip) and 1 (do strip)
    # optional, default is 0
    html_strip = 0

    # index sentences
    index_sp = 1
}

index info
{
    type = plain
    source = emacs_user_info
    morphology = stem_en
    path = /home/wvxvw/.emacs.d/sphinx/var/data/info
	min_word_len = 1
    preopen = 1
    index_sp = 1
}

indexer
{
    mem_limit = 1024M
}

searchd
{
    # [hostname:]port[:protocol], or /unix/socket/path to listen on
    # known protocols are 'sphinx' (SphinxAPI) and 'mysql41' (SphinxQL)
    #
    # multi-value, multiple listen points are allowed
    # optional, defaults are 9312:sphinx and 9306:mysql41, as below
    #
    # listen            = 127.0.0.1
    # listen            = 192.168.0.1:9312
    # listen            = 9312
    # listen            = /var/run/searchd.sock
    listen = 127.0.0.1:9306:mysql41
    log = /home/wvxvw/.emacs.d/sphinx/var/log/searchd.log
    query_log = /home/wvxvw/.emacs.d/sphinx/var/log/query.log
    pid_file = /home/wvxvw/.emacs.d/sphinx/var/log/searchd.pid
    binlog_path = /home/wvxvw/.emacs.d/sphinx/var/log
}