sphinx.conf.sample - mainline in StatusNet

#
# Minimal Sphinx configuration sample for statusnet
#

source src1
{
    type                    = mysql
    sql_host                = localhost
    sql_user                = USERNAME
    sql_pass                = PASSWORD
    sql_db                  = identi_ca
    sql_port                = 3306
    sql_query               = SELECT id, UNIX_TIMESTAMP(created) as created_ts, nickname, fullname, location, bio, homepage FROM profile
    sql_query_info          = SELECT * FROM profile where id = $id
    sql_attr_timestamp      = created_ts
}


source src2
{
    type                    = mysql
    sql_host                = localhost
    sql_user                = USERNAME
    sql_pass                = PASSWORD
    sql_db                  = identi_ca
    sql_port                = 3306
    sql_query               = SELECT id, UNIX_TIMESTAMP(created) as created_ts, content FROM notice
    sql_query_info          = SELECT * FROM notice where notice.id = $id AND notice.is_local != -2
    sql_attr_timestamp      = created_ts
}

index identica_notices
{
    source                  = src2
    path                    = DIRECTORY/data/identica_notices
    docinfo                 = extern
    charset_type            = utf-8
    min_word_len            = 3
    stopwords               = DIRECTORY/data/stopwords-en.txt
}


index identica_people
{
    source                  = src1
    path                    = DIRECTORY/data/identica_people
    docinfo                 = extern
    charset_type            = utf-8
    min_word_len            = 3
    stopwords               = DIRECTORY/data/stopwords-en.txt
}

indexer
{
    mem_limit               = 32M
}

searchd
{
    port                    = 3312
    log                     = DIRECTORY/log/searchd.log
    query_log               = DIRECTORY/log/query.log
    read_timeout            = 5
    max_children            = 30
    pid_file                = DIRECTORY/log/searchd.pid
    max_matches             = 1000
    seamless_rotate         = 1
    preopen_indexes         = 0
    unlink_old              = 1
}

1	#
2	# Minimal Sphinx configuration sample for statusnet
3	#
4
5	source src1
6	{
7	type = mysql
8	sql_host = localhost
9	sql_user = USERNAME
10	sql_pass = PASSWORD
11	sql_db = identi_ca
12	sql_port = 3306
13	sql_query = SELECT id, UNIX_TIMESTAMP(created) as created_ts, nickname, fullname, location, bio, homepage FROM profile
14	sql_query_info = SELECT * FROM profile where id = $id
15	sql_attr_timestamp = created_ts
16	}
17
18
19	source src2
20	{
21	type = mysql
22	sql_host = localhost
23	sql_user = USERNAME
24	sql_pass = PASSWORD
25	sql_db = identi_ca
26	sql_port = 3306
27	sql_query = SELECT id, UNIX_TIMESTAMP(created) as created_ts, content FROM notice
28	sql_query_info = SELECT * FROM notice where notice.id = $id AND notice.is_local != -2
29	sql_attr_timestamp = created_ts
30	}
31
32	index identica_notices
33	{
34	source = src2
35	path = DIRECTORY/data/identica_notices
36	docinfo = extern
37	charset_type = utf-8
38	min_word_len = 3
39	stopwords = DIRECTORY/data/stopwords-en.txt
40	}
41
42
43	index identica_people
44	{
45	source = src1
46	path = DIRECTORY/data/identica_people
47	docinfo = extern
48	charset_type = utf-8
49	min_word_len = 3
50	stopwords = DIRECTORY/data/stopwords-en.txt
51	}
52
53	indexer
54	{
55	mem_limit = 32M
56	}
57
58	searchd
59	{
60	port = 3312
61	log = DIRECTORY/log/searchd.log
62	query_log = DIRECTORY/log/query.log
63	read_timeout = 5
64	max_children = 30
65	pid_file = DIRECTORY/log/searchd.pid
66	max_matches = 1000
67	seamless_rotate = 1
68	preopen_indexes = 0
69	unlink_old = 1
70	}

Gitorious