Answer the question
In order to leave comments, you need to log in
Sphinx does not find some words. What could be the reason?
For example, there is a product: Water eyeliner 1/2 in-in
When searching for "Eyeliner" nothing will be found.
Config:
source parentSource
{
type = mysql
sql_host = localhost
sql_user = root
sql_pass =
sql_db = db
sql_port = 3306 # optional, default is 3306
sql_query_pre = SET NAMES utf8
sql_query_pre = SET SESSION query_cache_type=OFF
}
source catalog : parentSource
{
sql_query = \
SELECT ... \
sql_attr_uint = fk
sql_ranged_throttle = 0
}
index catalog
{
source = catalog
path = /h/sitename/htdocs/sphinx/data/catalog
morphology = stem_enru
min_word_len = 1
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, U+401->U+451, U+451
ignore_chars = U+0020
}
indexer
{
mem_limit = 128M
}
searchd
{
listen = 9312
listen = 9306:mysql41
log = /h/sitename/htdocs/sphinx/log/searchd.log
query_log = /h/sitename/htdocs/sphinx/log/query.log
read_timeout = 5
client_timeout = 300
max_children = 30
persistent_connections_limit = 30
pid_file = /h/sitename/htdocs/sphinx/log/searchd.pid
seamless_rotate = 1
preopen_indexes = 1
unlink_old = 1
mva_updates_pool = 1M
max_packet_size = 8M
max_filters = 256
max_filter_values = 4096
max_batch_queries = 32
workers = threads # for RT to work
binlog_path = /h/sitename/htdocs/sphinx/data
}
common
{
}
Answer the question
In order to leave comments, you need to log in
I will offer an alternative to the sphinx: PHP-class "Fuzzy search"
Check your strings in the search DEMO form , maybe this solution will suit you.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question