Sphinx.conf - Revision history

Sebas at 16:22, 9 November 2020

2020-11-09T16:22:33Z

Sebas at 14:58, 4 November 2020

2020-11-04T14:58:16Z

Sebas at 13:36, 4 November 2020

2020-11-04T13:36:07Z

Sebas at 14:07, 2 November 2020

2020-11-02T14:07:46Z

Sebas: Created page with "# # Sphinx configuration file sample # ############################################################################# ## data source definition ###############################..."

2020-11-02T14:06:51Z

Created page with "# # Sphinx configuration file sample # ############################################################################# ## data source definition ###############################..."

New page

#
# Sphinx configuration file sample
#

#############################################################################
## data source definition
#############################################################################

source sku_products
{
# data source type. mandatory, no default value
# known types are mysql, pgsql, mssql, xmlpipe, xmlpipe2, odbc
type = mysql

#####################################################################
## SQL settings (for 'mysql' and 'pgsql' types)
#####################################################################

# some straightforward parameters for SQL source types
sql_host = localhost
sql_user = root
sql_pass = sebastian
sql_db = sku_io
sql_port = 3306 # optional, default is 3306

# pre-query, executed before the main fetch query
# multi-value, optional, default is empty list of queries
#
sql_query_pre = SET NAMES utf8

# main document fetch query
# mandatory, integer document ID field MUST be the first selected column
sql_query = SELECT id, parent_id, brand_id, sku, name, barcode, mpn FROM products

sql_attr_uint = parent_id
sql_attr_uint = brand_id

}

source sku_attributes
{
# data source type. mandatory, no default value
# known types are mysql, pgsql, mssql, xmlpipe, xmlpipe2, odbc
type = mysql

#####################################################################
## SQL settings (for 'mysql' and 'pgsql' types)
#####################################################################

# some straightforward parameters for SQL source types
sql_host = localhost
sql_user = root
sql_pass = sebastian
sql_db = sku_io
sql_port = 3306 # optional, default is 3306

# pre-query, executed before the main fetch query
# multi-value, optional, default is empty list of queries
#
sql_query_pre = SET NAMES utf8

# main document fetch query
# mandatory, integer document ID field MUST be the first selected column
sql_query = SELECT id, product_id, attribute_id, value FROM product_attributes

sql_attr_uint = product_id
sql_attr_uint = attribute_id

}

#############################################################################
## index definition
#############################################################################

index sku_products {
source = sku_products
path = /var/sphinxsearch/sku_products.sphinx.index

morphology = stem_en #, metaphone # You can add metaphone morphology if you want.
min_word_len = 1 # Indexes all words
blend_chars = - # This presumes people won't type a hyphen into the search bar: quite likely
blend_mode = trim_both #
html_strip = 1 # Just in case anyone tries to get clever in the admin panel and use HTML

# <substrings section>
# Index substrings too, down to 3 chars but no less
min_infix_len = 3
# These three options are needed to differentiate full word matches from
# infix (substring) matches and rank them higher
dict = keywords
index_exact_words = 1
expand_keywords = 1
# </substrings section>
}

index sku_attributes {
source = sku_attributes
path = /var/sphinxsearch/sku_attributes.sphinx.index

morphology = stem_en #, metaphone # You can add metaphone morphology if you want.
min_word_len = 1 # Indexes all words
blend_chars = - # This presumes people won't type a hyphen into the search bar: quite likely
blend_mode = trim_both #
html_strip = 1 # Just in case anyone tries to get clever in the admin panel and use HTML
}

# index sku_attributes {
# type = rt
# path = /var/sphinxsearch/sku_attributes.sphinx.index
#
# rt_mem_limit = 2047M
#
# rt_attr_uint = id
# rt_attr_uint = product_id
# rt_attr_uint = attribute_id
# rt_field = value
# }

#############################################################################
## indexer settings
#############################################################################

indexer
{
# memory limit, in bytes, kiloytes (16384K) or megabytes (256M)
# optional, default is 128M, max is 2047M, recommended is 256M to 1024M
mem_limit = 1024M
}

#############################################################################
## searchd settings
#############################################################################

searchd
{

# [hostname:]port[:protocol], or /unix/socket/path to listen on
# known protocols are 'sphinx' (SphinxAPI) and 'mysql41' (SphinxQL)
#
# multi-value, multiple listen points are allowed
# optional, defaults are 9312:sphinx and 9306:mysql41, as below
#
listen = 9312
listen = 9306:mysql41

# log file, searchd run info is logged here
# optional, default is 'searchd.log'
log = /var/log/sphinxsearch/searchd.log

# query log file, all search queries are logged here
# optional, default is empty (do not log queries)
query_log = /var/log/sphinxsearch/query.log

# client read timeout, seconds
# optional, default is 5
read_timeout = 10

# request timeout, seconds
# optional, default is 5 minutes
client_timeout = 10

# maximum amount of children to fork (concurrent searches to run)
# optional, default is 0 (unlimited)
max_children = 30

# maximum amount of persistent connections from this master to each agent host
# optional, but necessary if you use agent_persistent. It is reasonable to set the value
# as max_children, or less on the agent's hosts.
persistent_connections_limit = 30

# PID file, searchd process ID file name
# mandatory
pid_file = /var/log/sphinxsearch/searchd.pid

# seamless rotate, prevents rotate stalls if precaching huge datasets
# optional, default is 1
seamless_rotate = 1

# whether to forcibly preopen all indexes on startup
# optional, default is 1 (preopen everything)
preopen_indexes = 1

# whether to unlink .old index copies on succesful rotation.
# optional, default is 1 (do unlink)
unlink_old = 1

# MVA updates pool size
# shared between all instances of searchd, disables attr flushes!
# optional, default size is 1M
mva_updates_pool = 1M

# max allowed network packet size
# limits both query packets from clients, and responses from agents
# optional, default size is 8M
max_packet_size = 8M

# max allowed per-query filter count
# optional, default is 256
max_filters = 256

# max allowed per-filter values count
# optional, default is 4096
max_filter_values = 4096

# max allowed per-batch query count (aka multi-query count)
# optional, default is 32
max_batch_queries = 32

# multi-processing mode (MPM)
# known values are none, fork, prefork, and threads
# threads is required for RT backend to work
# optional, default is threads
workers = threads # for RT to work
}

# --eof--

@@ Line 90: / Line 90: @@
      # <substrings section>
-         # [http://sphinxsearch.com/docs/current/conf-min-infix-len.html|Explained here]
+         # Explained here: [http://sphinxsearch.com/docs/current/conf-min-infix-len.html]
          # Index substrings too, down to 3 chars but no less
@@ Line 114: / Line 114: @@
      # <substrings section>
-         # [http://sphinxsearch.com/docs/current/conf-min-infix-len.html|Explained here]
+         # Explained here: [http://sphinxsearch.com/docs/current/conf-min-infix-len.html]
          # Index substrings too, down to 3 chars but no less
@@ Line 138: / Line 138: @@
+#
 #    # <substrings section>
-#        # [http://sphinxsearch.com/docs/current/conf-min-infix-len.html|Explained here]
+#        # Explained here: [http://sphinxsearch.com/docs/current/conf-min-infix-len.html]
+#
 #        # Index substrings too, down to 3 chars but no less

@@ Line 185: / Line 185: @@
 	# optional, default is empty (do not log queries)
 	query_log		= /var/log/sphinxsearch/query.log
 	# client read timeout, seconds

@@ Line 90: / Line 90: @@
      # <substrings section>
          # Index substrings too, down to 3 chars but no less
          min_infix_len = 3
@@ Line 109: / Line 111: @@
      blend_mode   = trim_both   #
      html_strip   = 1           # Just in case anyone tries to get clever in the admin panel and use HTML
+}
@@ Line 121: / Line 136: @@
 #     rt_attr_uint = attribute_id
 #     rt_field = value
 # }

@@ Line 1: / Line 1: @@
+#
 # Sphinx configuration file sample
@@ Line 221: / Line 222: @@
 # --eof--