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