1# 2# Minimal Sphinx configuration sample (clean, simple, functional) 3# 4 5source src1 6{ 7 type = mysql 8 9 sql_host = localhost 10 sql_user = test 11 sql_pass = 12 sql_db = test 13 sql_port = 3306 # optional, default is 3306 14 15 sql_query = \ 16 SELECT id, group_id, UNIX_TIMESTAMP(date_added) AS date_added, title, content \ 17 FROM documents 18 19 sql_attr_uint = group_id 20 sql_attr_timestamp = date_added 21 22 sql_query_info = SELECT * FROM documents WHERE id=$id 23} 24 25 26index test1 27{ 28 source = src1 29 path = @CONFDIR@/data/test1 30 docinfo = extern 31 charset_type = sbcs 32} 33 34 35index testrt 36{ 37 type = rt 38 rt_mem_limit = 32M 39 40 path = @CONFDIR@/data/testrt 41 charset_type = utf-8 42 43 rt_field = title 44 rt_field = content 45 rt_attr_uint = gid 46} 47 48 49indexer 50{ 51 mem_limit = 32M 52} 53 54 55searchd 56{ 57 listen = 9312 58 listen = 9306:mysql41 59 log = @CONFDIR@/log/searchd.log 60 query_log = @CONFDIR@/log/query.log 61 read_timeout = 5 62 max_children = 30 63 pid_file = @CONFDIR@/log/searchd.pid 64 max_matches = 1000 65 seamless_rotate = 1 66 preopen_indexes = 1 67 unlink_old = 1 68 workers = threads # for RT to work 69 binlog_path = @CONFDIR@/data 70} 71