Sphinx configuration file template

``` source feed_items { type = mysql sql_host = 127.0.0.1 sql_user = root sql_pass = sql_db = xxx_production sql_port = 3306 # optional, default is 3306 sql_sock = /var/run/mysqld/mysqld.sock sql_query_pre = SET NAMES utf8 #sql_query_pre = SET SESSION query_cache_type=OFF # Unique ID should be first column sql_query = \ SELECT i.id, i.title, i.link, f.link, f.title FROM feed_items i LEFT JOIN feeds f ON f.id = i.feed_id } index feed_items { source = feed_items path = /var/sphinx/xxx morphology = libstemmer_sv charset_type = utf-8 } indexer { mem_limit = 32M } searchd { address = 127.0.0.1 port = 3312 log = /var/log/sphinx/searchd.log query_log = /var/log/sphinx/query.log pid_file = /var/log/searchd.pid max_matches = 1000 } ```