This is an old version of the documentation. Follow to go to the new Manticore Search manual.

No, thanks
  • Downloads
  • Services
  • Resources

    • Documentation
    • Cheatsheets
    • Courses
    • Free Config Review
    • Blog
    • Forum
  • About

    • Manticore Search
    • Clients
  • Contact
2.4.1

Manticore Documentation

  • Introduction
    • About
    • Manticore features
    • Where to get Manticore
    • License
    • Credits
  • Installation
    • Installing Manticore packages on Debian and Ubuntu
    • Installing Manticore packages on RedHat and CentOS
    • Installing Manticore on Windows
    • Compiling Manticore from source
      • Required tools
      • Optional dependencies
      • General building options
      • Compiling on UNIX systems
      • Compiling on Windows
    • Quick Manticore usage tour
  • Indexing
    • Data sources
    • Full-text fields
    • Attributes
      • Example sphinx.conf part:
      • Example application code (in PHP):
    • MVA (multi-valued attributes)
    • Indexes
      • Offline/plain indexes
      • Real-Time indexes
      • Distributed indexes
      • Templates indexes
    • Restrictions on the source data
    • Charsets, case folding, translation tables, and replacement rules
    • SQL data sources (MySQL, PostgreSQL)
      • Ranged queries
      • sql_query_post vs. sql_query_post_index
    • xmlpipe2 data source
    • TSV/CSV data source
    • Live index updates
    • Delta index updates
    • Index merging
  • Real-time indexes
    • RT indexes overview
    • Known caveats with RT indexes
    • RT index internals
    • Binary logging
  • Searching
    • Matching modes
    • Boolean query syntax
    • Extended query syntax
    • Search results ranking
      • Ranking overview
      • Available built-in rankers
        • Legacy matching modes rankers
      • Quick summary of the ranking factors
      • Document-level ranking factors
      • Field-level ranking factors
      • Ranking factor aggregation functions
      • Formula expressions for all the built-in rankers
    • Expressions, functions, and operators
      • Operators
      • Numeric functions
      • Date and time functions
      • Type conversion functions
      • Comparison functions
      • Miscellaneous functions
    • Sorting modes
      • SPH_SORT_TIME_SEGMENTS mode
      • SPH_SORT_EXTENDED mode
      • SPH_SORT_EXPR mode
    • Grouping (clustering) search results
    • Distributed searching
    • Query log formats
      • Plain log format
      • SphinxQL log format
    • MySQL protocol support and SphinxQL
    • HTTP protocol
    • Multi-queries
    • Collations
    • Query cache
    • MySQL storage engine (SphinxSE)
      • SphinxSE overview
        • Installing SphinxSE
        • Compiling MySQL 5.0.x with SphinxSE
        • Compiling MySQL 5.1.x with SphinxSE
        • Checking SphinxSE installation
        • Using SphinxSE
      • Building snippets (excerpts) via MySQL
  • Extending
    • UDFs (User Defined Functions)
    • Plugins
    • Ranker plugins
  • Command line tools reference
    • indexer command reference
    • indextool command reference
    • searchd command reference
    • spelldump command reference
    • wordbreaker command reference
  • SphinxQL reference
    • ALTER syntax
    • ATTACH INDEX syntax
    • BEGIN, COMMIT, and ROLLBACK syntax
    • BEGIN syntax
    • CALL KEYWORDS syntax
    • CALL QSUGGEST syntax
    • CALL SNIPPETS syntax
    • CALL SUGGEST syntax
    • Comment syntax
    • CREATE FUNCTION syntax
    • CREATE PLUGIN syntax
    • DELETE syntax
    • DESCRIBE syntax
    • DROP FUNCTION syntax
    • DROP PLUGIN syntax
    • FLUSH ATTRIBUTES syntax
    • FLUSH HOSTNAMES syntax
    • FLUSH RAMCHUNK syntax
    • FLUSH RTINDEX syntax
    • INSERT and REPLACE syntax
    • List of SphinxQL reserved keywords
    • Multi-statement queries
    • OPTIMIZE INDEX syntax
    • RELOAD INDEX syntax
    • RELOAD PLUGINS syntax
    • REPLACE syntax
    • ROLLBACK syntax
    • SELECT syntax
      • Column list
      • EXIST()
      • SNIPPET()
      • REMOVE_REPEATS()
      • FROM
      • WHERE
      • GROUP BY
      • GROUP_CONCAT()
      • ZONESPANLIST()
      • WITHIN GROUP ORDER BY
      • HAVING
      • ORDER BY
      • LIMIT
      • OPTION
      • FACET
      • Subselects
    • SELECT @@system_variable syntax
    • SET syntax
    • SET TRANSACTION syntax
    • SHOW AGENT STATUS
    • SHOW CHARACTER SET syntax
    • SHOW COLLATION syntax
    • SHOW DATABASES syntax
    • SHOW INDEX SETTINGS syntax
    • SHOW INDEX STATUS syntax
    • SHOW META syntax
    • SHOW PLAN syntax
    • SHOW PLUGINS syntax
    • SHOW PROFILE syntax
    • SHOW STATUS syntax
    • SHOW TABLES syntax
    • SHOW THREADS syntax
    • SHOW VARIABLES syntax
    • SHOW WARNINGS syntax
    • TRUNCATE RTINDEX syntax
    • UPDATE syntax
  • API reference
    • General API functions
      • GetLastError
      • GetLastWarning
      • SetServer
      • SetConnectTimeout
      • SetArrayResult
      • IsConnectError
    • General query settings
      • SetSelect
      • SetLimits
      • SetMaxQueryTime
      • SetOverride
    • Full-text search query settings
      • SetFieldWeights
      • SetIndexWeights
      • SetMatchMode
      • SetRankingMode
      • SetSortMode
      • SetWeights
    • Result set filtering settings
      • SetFilter
      • SetFilterRange
      • SetFilterFloatRange
      • SetFilterString
      • SetIDRange
      • SetGeoAnchor
    • GROUP BY settings
      • SetGroupBy
      • SetGroupDistinct
    • Querying
      • AddQuery
      • Query
      • RunQueries
      • ResetFilters
      • ResetGroupBy
    • Additional functionality
      • BuildExcerpts
      • BuildKeywords
      • EscapeString
      • FlushAttributes
      • Status
      • UpdateAttributes
    • Persistent connections
      • Open
      • Close
  • Configuration reference
    • Common section configuration options
      • lemmatizer_base
      • progressive_merge
      • json_autoconv_keynames
      • json_autoconv_numbers
      • on_json_attr_error
      • plugin_dir
      • rlp_environment
      • rlp_max_batch_docs
      • rlp_max_batch_size
      • rlp_root
    • Data surce configuration options
      • csvpipe_delimiter
      • mssql_winauth
      • mysql_connect_flags
      • mysql_ssl_cert, mysql_ssl_key, mysql_ssl_ca
      • odbc_dsn
      • sql_attr_bigint
      • sql_attr_bool
      • sql_attr_float
      • sql_attr_json
      • sql_attr_multi
      • sql_attr_string
      • sql_attr_timestamp
      • sql_attr_uint
      • sql_column_buffers
      • sql_db
      • sql_field_string
      • sql_file_field
      • sql_host
      • sql_joined_field
      • sql_pass
      • sql_port
      • sql_query_killlist
      • sql_query_post_index
      • sql_query_post
      • sql_query_pre
      • sql_query_range
      • sql_query
      • sql_ranged_throttle
      • sql_range_step
      • sql_sock
      • sql_user
      • type
      • unpack_mysqlcompress_maxsize
      • unpack_mysqlcompress
      • unpack_zlib
      • xmlpipe_attr_bigint
      • xmlpipe_attr_bool
      • xmlpipe_attr_float
      • xmlpipe_attr_json
      • xmlpipe_attr_multi_64
      • xmlpipe_attr_multi
      • xmlpipe_attr_string
      • xmlpipe_attr_timestamp
      • xmlpipe_attr_uint
      • xmlpipe_command
      • xmlpipe_field
      • xmlpipe_field_string
      • xmlpipe_fixup_utf8
    • Index configuration options
      • agent_blackhole
      • agent_connect_timeout
      • agent_persistent
      • agent_query_timeout
      • agent
        • Agent mirrors
      • bigram_freq_words
      • bigram_index
      • blend_chars
      • blend_mode
      • charset_table
      • dict
      • docinfo
      • embedded_limit
      • exceptions
      • expand_keywords
      • global_idf
      • ha_strategy
        • Simple random balancing
        • Adaptive randomized balancing
        • Round-robin balancing
      • hitless_words
      • html_index_attrs
      • html_remove_elements
      • html_strip
      • ignore_chars
      • index_exact_words
      • index_field_lengths
      • index_sp
      • index_zones
      • infix_fields
      • inplace_docinfo_gap
      • inplace_enable
      • inplace_hit_gap
      • inplace_reloc_factor
      • inplace_write_factor
      • local
      • max_substring_len
      • min_infix_len
      • min_prefix_len
      • min_stemming_len
      • min_word_len
      • mlock
      • morphology
      • ngram_chars
      • ngram_len
      • ondisk_attrs
      • overshort_step
      • path
      • phrase_boundary
      • phrase_boundary_step
      • prefix_fields
      • preopen
      • regexp_filter
      • rlp_context
      • rt_attr_bigint
      • rt_attr_bool
      • rt_attr_float
      • rt_attr_json
      • rt_attr_multi_64
      • rt_attr_multi
      • rt_attr_string
      • rt_attr_timestamp
      • rt_attr_uint
      • rt_field
      • rt_mem_limit
      • source
      • stopwords
      • stopword_step
      • stopwords_unstemmed
      • type
      • wordforms
    • indexer program configuration options
      • lemmatizer_cache
      • max_file_field_buffer
      • max_iops
      • max_iosize
      • max_xmlpipe2_field
      • mem_limit
      • on_file_field_error
      • write_buffer
    • searchd program configuration options
      • agent_connect_timeout
      • agent_query_timeout
      • agent_retry_count
      • agent_retry_delay
      • attr_flush_period
      • binlog_flush
      • binlog_max_log_size
      • binlog_path
      • client_timeout
      • collation_libc_locale
      • collation_server
      • dist_threads
      • expansion_limit
      • grouping_in_utc
      • ha_period_karma
      • ha_ping_interval
      • hostname_lookup
      • listen_backlog
      • listen
      • log
      • max_batch_queries
      • max_children
      • max_filters
      • max_filter_values
      • max_packet_size
      • mva_updates_pool
      • mysql_version_string
      • net_workers
      • net_wait_tm
      • net_throttle_accept net_throttle_action
      • ondisk_attrs_default
      • persistent_connections_limit
      • pid_file
      • predicted_time_costs
      • preopen_indexes
      • qcache_max_bytes
      • qcache_thresh_msec
      • qcache_ttl_sec
      • query_log_format
      • query_log_min_msec
      • query_log
      • query_log_mode
      • queue_max_length
      • read_buffer
      • read_timeout
      • read_unhinted
      • rt_flush_period
      • rt_merge_iops
      • rt_merge_maxiosize
      • seamless_rotate
      • shutdown_timeout
      • snippets_file_prefix
      • sphinxql_state
      • sphinxql_timeout
      • subtree_docs_cache
      • subtree_hits_cache
      • thread_stack
      • unlink_old
      • watchdog
      • workers
  • Reporting bugs
    • Bug-tracker
    • Crashes
    • Uploading your data
  • Release notes
    • Version 2.4.1 GA, 16 October 2017
      • Features and improvements
      • Compiling
      • Folders and service
      • Bugfixes
    • Version 2.3.3, 06 July 2017

Looking for the Cheatsheets?

Download

Manticore Search
  • Docs »
  • Searching

SearchingΒΆ

  • Matching modes
  • Boolean query syntax
  • Extended query syntax
  • Search results ranking
    • Ranking overview
    • Available built-in rankers
      • Legacy matching modes rankers
    • Quick summary of the ranking factors
    • Document-level ranking factors
    • Field-level ranking factors
    • Ranking factor aggregation functions
    • Formula expressions for all the built-in rankers
  • Expressions, functions, and operators
    • Operators
    • Numeric functions
    • Date and time functions
    • Type conversion functions
    • Comparison functions
    • Miscellaneous functions
  • Sorting modes
    • SPH_SORT_TIME_SEGMENTS mode
    • SPH_SORT_EXTENDED mode
    • SPH_SORT_EXPR mode
  • Grouping (clustering) search results
  • Distributed searching
  • Query log formats
    • Plain log format
    • SphinxQL log format
  • MySQL protocol support and SphinxQL
  • HTTP protocol
  • Multi-queries
  • Collations
  • Query cache
  • MySQL storage engine (SphinxSE)
    • SphinxSE overview
      • Installing SphinxSE
      • Compiling MySQL 5.0.x with SphinxSE
      • Compiling MySQL 5.1.x with SphinxSE
      • Checking SphinxSE installation
      • Using SphinxSE
    • Building snippets (excerpts) via MySQL
Next Previous

© Copyright 2017-2020, Manticore Search team.

Built with Sphinx using a theme provided by Read the Docs.
Menu v: 2.4.1
latest
HTML
Single HTML
PDF
3.4.2
HTML
Single HTML
PDF
3.4.0
HTML
Single HTML
PDF
3.3.0
HTML
Single HTML
PDF
3.2.2
HTML
Single HTML
PDF
3.2.0
HTML
Single HTML
PDF
3.1.2
HTML
Single HTML
PDF
3.1.0
HTML
Single HTML
PDF
3.0.2
HTML
Single HTML
PDF
3.0.0
HTML
Single HTML
PDF
2.8.2
HTML
Single HTML
PDF
2.7.5
HTML
Single HTML
PDF
2.6.4
HTML
Single HTML
PDF
2.5.1
HTML
Single HTML
PDF
2.4.1
HTML
Single HTML
PDF
Links
Project Home
Github