Конфиг:
source items
{
type = mysql
sql_host = localhost
sql_user = *********
sql_pass = *********
sql_db = *********
sql_port = 3306
sql_query_pre = SET NAMES utf8
sql_query = \
SELECT i.id, i.sku, i.title, i.description, i.manufacturer, c.title, c.description \
FROM `items` i LEFT JOIN `customItems` c \
ON i.id = c.id \
WHERE i.qty > 0
sql_query_info = SELECT id FROM items WHERE id = $id
}
index items
{
source = items
path = /var/www/*********/sphinx/items
docinfo = extern
mlock = 0
morphology = stem_enru
min_word_len = 3
charset_type = utf-8
min_infix_len = 2
enable_star = 1
}
indexer
{
mem_limit = 32M
}
searchd
{
listen = 127.0.0.1:3312
}
Тестирую:
indexer --config /var/www/*******/sphinx/config --all
Sphinx 2.1.2-id64-release (r4245)
Copyright (c) 2001-2013, Andrew Aksyonoff
Copyright (c) 2008-2013, Sphinx Technologies Inc (http://sphinxsearch.com)
using config file '/var/www/*******/sphinx/config'...
indexing index 'items'...
WARNING: Attribute count is 0: switching to none docinfo
collected 23800 docs, 6.3 MB
sorted 15.8 Mhits, 100.0% done
total 23800 docs, 6258040 bytes
total 12.226 sec, 511862 bytes/sec, 1946.66 docs/sec
total 36 reads, 0.065 sec, 2633.8 kb/call avg, 1.8 msec/call avg
total 202 writes, 0.247 sec, 851.2 kb/call avg, 1.2 msec/call avg
search --config /var/www/*******/sphinx/config словоДляПоиска
Sphinx 2.1.2-id64-release (r4245)
Copyright (c) 2001-2013, Andrew Aksyonoff
Copyright (c) 2008-2013, Sphinx Technologies Inc (http://sphinxsearch.com)
using config file '/var/www/*******/sphinx/config'...
index 'items': search error: query too complex, not enough stack (thread_stack=1206872K or higher required).