1source src1 2{ 3 type = mysql 4 sql_host = localhost 5 sql_user = root 6 sql_pass = 7 sql_db = sphinx_test 8 sql_port = 3306 9 10 sql_query = SELECT id, name, description, UNIX_TIMESTAMP(created_at) AS created_at, group_id, rating FROM links 11 sql_attr_uint = group_id 12 sql_attr_timestamp = created_at 13 sql_attr_float = rating 14 sql_attr_multi = uint tags from query; SELECT link_id, tag_id FROM links_tags 15 sql_query_info = SELECT * FROM links WHERE id=$id 16} 17 18source src2 19{ 20 type = mysql 21 sql_host = localhost 22 sql_user = root 23 sql_pass = 24 sql_db = sphinx_test 25 sql_port = 3306 26 27 sql_query = SELECT id, name, description, UNIX_TIMESTAMP(created_at) AS created_at, group_id FROM links64 28 sql_attr_uint = group_id 29 sql_attr_timestamp = created_at 30 sql_query_info = SELECT * FROM links WHERE id=$id 31} 32 33index test1 34{ 35 source = src1 36 path = /opt/sphinx-0.9.9/var/data/test1 37 docinfo = extern 38 morphology = none 39 stopwords = 40 charset_type = utf-8 41} 42 43index test2 44{ 45 source = src2 46 path = /opt/sphinx-0.9.9/var/data/test2 47 docinfo = extern 48 morphology = none 49 stopwords = 50 charset_type = utf-8 51} 52 53indexer 54{ 55 mem_limit = 32M 56} 57 58searchd 59{ 60 port = 9312 61 log = /opt/sphinx-0.9.9/var/log/searchd.log 62 query_log = /opt/sphinx-0.9.9/var/log/query.log 63 read_timeout = 5 64 max_children = 30 65 pid_file = /opt/sphinx-0.9.9/var/log/searchd.pid 66 max_matches = 1000 67} 68