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