Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- source application
- {
- type = pgsql
- sql_host = 192.168.1.2
- sql_user = www
- sql_pass = ghjcnjq
- sql_db = shop
- sql_port = 5432
- sql_query_pre = SET NAMES 'utf-8'
- }
- source legacySource : application
- {
- sql_query = \
- SELECT i.id, 'i' AS prefix, i.title, i.photo,i.base_price, i.base_quantity, i.fixed_price, \
- i.in_store, i.model, g.title AS group_title, g.id AS group_id \
- #,regexp_replace(i.title,'~*[^a-zA-Z0-9 ]','','g') AS fix \
- FROM legacy.data_item i \
- LEFT JOIN legacy.data_group g ON g.id = i.parent_id \
- WHERE i.id BETWEEN $start AND $end AND g.status = 1
- sql_query_range = SELECT MIN(id),MAX(id) FROM legacy.data_item
- sql_range_step = 5000
- sql_attr_string = prefix
- sql_field_str2wordcount = title
- sql_attr_string = photo
- sql_attr_uint = base_price:12
- sql_attr_uint = base_quantity:4
- sql_attr_uint = fixed_price:12
- sql_attr_uint = in_store:4
- #sql_field_str2wordcount = model
- sql_attr_string = group_title
- sql_attr_uint = group_id:12
- sql_attr_string = manufactor
- }
- source publicSource : application
- {
- sql_query = \
- SELECT p.id, 'p' AS prefix, p.title, p.photo,p.base_price, p.base_quantity, p.fixed_price, \
- p.in_store, p.model, g.title AS group_title, g.id AS group_id \
- #,regexp_replace(p.title,'~*[^a-zA-Z0-9 ]','','g') AS fix \
- FROM public.data_item p \
- LEFT JOIN legacy.data_group_type gt ON gt.type_id =p.type_id \
- LEFT JOIN legacy.data_group g ON g.id = gt.group_id \
- WHERE p.id BETWEEN $start AND $end AND g.status = 1
- sql_query_range = SELECT MIN(id),MAX(id) FROM public.data_item
- sql_range_step = 5000
- sql_attr_string = prefix
- sql_field_str2wordcount = title
- sql_attr_string = photo
- sql_attr_uint = base_price:12
- sql_attr_uint = base_quantity:4
- sql_attr_uint = fixed_price:12
- sql_attr_uint = in_store:4
- #sql_field_str2wordcount = model
- sql_attr_string = group_title
- sql_attr_uint = group_id:12
- sql_attr_string = manufactor
- }
- index legacyIndex
- {
- source = legacySource
- path = /var/run/sphinx/legacySource/legacyIndex
- docinfo = extern
- mlock = 0
- morphology = stem_enru, soundex, metaphone
- charset_type = utf-8
- charset_table = 0..9, A..Z->a..z, a..z,U+410..U+42F->U+430..U+44F, U+430..U+44F
- #ignore_chars = U+AD,U+2D,U+27,U+22,U+2B,U+3D,U+3E,U+3F,U+3C,U+3B,U+3A,U+2F,U+2E,U+2C,U+2A,U+20..U+29
- blend_chars = +, U+0024, U+0026, U+0028, U+0029, U+194, U+160, U+002F, U+005C, U+007C, U+005F, U+002D
- #blend_mode = trim_tail
- min_prefix_len = 0
- min_infix_len = 2
- enable_star = 1
- min_word_len = 2
- ngram_len = 1
- wordforms = /home/www/sphinx/wordforms.txt
- }
- index publicIndex
- {
- source = publicSource
- path = /var/run/sphinx/publicSource/publicIndex
- docinfo = extern
- mlock = 0
- morphology = stem_enru, soundex, metaphone
- charset_type = utf-8
- charset_table = 0..9, A..Z->a..z, a..z,U+410..U+42F->U+430..U+44F, U+430..U+44F
- #ignore_chars = U+AD,U+2D,U+27,U+22,U+2B,U+3D,U+3E,U+3F,U+3C,U+3B,U+3A,U+2F,U+2E,U+2C,U+2A,U+20..U+29
- blend_chars = +, U+0024, U+0026, U+0028, U+0029, U+194, U+160, U+002F, U+005C, U+007C, U+005F, U+002D
- #blend_mode = trim_tail
- min_prefix_len = 0
- min_infix_len = 2
- enable_star = 1
- min_word_len = 2
- ngram_len = 1
- wordforms = /home/www/sphinx/wordforms.txt
- }
- indexer
- {
- mem_limit = 128M
- }
- searchd
- {
- listen = 127.0.0.1
- port = 5000
- log = /home/www/sphinx/searchd.log
- query_log = /home/www/sphinx/query.log
- read_timeout = 2
- max_children = 32
- pid_file = /home/www/sphinx/searchd.pid
- }
Add Comment
Please, Sign In to add comment