D
D
denis6342016-08-05 14:36:12
Sphinx
denis634, 2016-08-05 14:36:12

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

2 answer(s)
P
Puma Thailand, 2016-08-05
@opium

look at kveri log of a sphinx for a start.

X
xmoonlight, 2016-09-07
@xmoonlight

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 question

Ask a Question

731 491 924 answers to any question