Sphinx 2.2.5-release reference manual

Sphinx

需积分: 0 0 下载量 115 浏览量 2014-11-04 03:39:43 上传评论收藏 1.42MB PDF 举报

温馨提示

试读

254页

Sphinx 2.2.5-release reference manual 使用手册。英文版。

资源详情

资源评论

Sphinx 2.2.5-release reference manual
Free open-source SQL full-text search engine
Copyright © 2001-2014 Andrew Aksyonoff
Copyright © 2008-2014 Sphinx Technologies Inc, http://sphinxsearch.com
Table of Contents
Introduction 
1. About 
2. Sphinx features 
3. Where to get Sphinx 
4. License 
5. Credits 
6. History 
Installation 
1. Supported systems 
2. Compiling Sphinx from source 
2.1. Required tools 
2.2. Compiling on Linux 
2.3. Known compilation issues 
3. Installing Sphinx packages on Debian and Ubuntu 
4. Installing Sphinx packages on RedHat and CentOS 
5. Installing Sphinx on Windows 
6. Sphinx deprecations and changes in default configuration 
7. Quick Sphinx usage tour 
Indexing 
1. Data sources 
2. Full-text fields 
3. Attributes 
4. MVA (multi-valued attributes) 
5. Indexes 
6. Restrictions on the source data 
7. Charsets, case folding, translation tables, and replacement rules 
8. SQL data sources (MySQL, PostgreSQL) 
9. xmlpipe2 data source 
10. tsvpipe (Tab Separated Values) data source 
11. Live index updates 
12. Delta index updates 
13. Index merging 
Real-time indexes 
1. RT indexes overview 
2. Known caveats with RT indexes 
3. RT index internals 
4. Binary logging 
Searching 
1. Matching modes 
2. Boolean query syntax 

3. Extended query syntax 
4. Search results ranking 
4.1. Ranking overview 
4.2. Available built-in rankers 
4.3. Expression based ranker (SPH_RANK_EXPR) 
4.4. Quick summary of the ranking factors 
4.5. Document-level ranking factors 
4.6. Field-level ranking factors 
4.7. Ranking factor aggregation functions 
4.8. Formula expressions for all the built-in rankers 
5. Expressions, functions, and operators 
5.1. Operators 
5.2. Numeric functions 
5.3. Date and time functions 
5.4. Type conversion functions 
5.5. Comparison functions 
5.6. Miscellaneous functions 
6. Sorting modes 
7. Grouping (clustering) search results 
8. Distributed searching 
9.    searchd    query log formats    
9.1. Plain log format 
9.2. SphinxQL log format 
10. MySQL protocol support and SphinxQL 
11. Multi-queries 
12. Collations 
Extending Sphinx 
1. Sphinx UDFs (User Defined Functions) 
2. Sphinx plugins 
3. Ranker plugins 
Command line tools reference 
1.    indexer    command reference    
2.    searchd    command reference    
3.    spelldump    command reference    
4.    indextool    command reference    
5.    wordbreaker    command reference    
SphinxQL reference 
1. SELECT syntax 
2. SELECT @@system_variable syntax 
3. SHOW META syntax 
4. SHOW WARNINGS syntax 
5. SHOW STATUS syntax 
6. INSERT and REPLACE syntax 
7. REPLACE syntax 
8. DELETE syntax 
9. SET syntax 
10. SET TRANSACTION syntax 
11. BEGIN, COMMIT, and ROLLBACK syntax 
12. BEGIN syntax 
13. ROLLBACK syntax 
14. CALL SNIPPETS syntax 
15. CALL KEYWORDS syntax 

16. SHOW TABLES syntax 
17. DESCRIBE syntax 
18. CREATE FUNCTION syntax 
19. DROP FUNCTION syntax 
20. SHOW VARIABLES syntax 
21. SHOW COLLATION syntax 
22. SHOW CHARACTER SET syntax 
23. UPDATE syntax 
24. ALTER syntax 
25. ATTACH INDEX syntax 
26. FLUSH RTINDEX syntax 
27. FLUSH RAMCHUNK syntax 
28. TRUNCATE RTINDEX syntax 
29. SHOW AGENT STATUS 
30. SHOW PROFILE syntax 
31. SHOW INDEX STATUS syntax 
32. SHOW INDEX SETTINGS syntax 
33. OPTIMIZE INDEX syntax 
34. SHOW PLAN syntax 
35. SHOW DATABASES syntax 
36. CREATE PLUGIN syntax 
37. DROP PLUGIN syntax 
38. SHOW PLUGINS syntax 
39. SHOW THREADS syntax 
40. Multi-statement queries 
41. Comment syntax 
42. List of SphinxQL reserved keywords 
43. SphinxQL upgrade notes, version 2.0.1-beta 
API reference 
1. General API functions 
1.1. GetLastError 
1.2. GetLastWarning 
1.3. SetServer 
1.4. SetRetries 
1.5. SetConnectTimeout 
1.6. SetArrayResult 
1.7. IsConnectError 
2. General query settings 
2.1. SetLimits 
2.2. SetMaxQueryTime 
2.3. SetOverride 
2.4. SetSelect 
3. Full-text search query settings 
3.1. SetMatchMode 
3.2. SetRankingMode 
3.3. SetSortMode 
3.4. SetWeights 
3.5. SetFieldWeights 
3.6. SetIndexWeights 
4. Result set filtering settings 
4.1. SetIDRange 
4.2. SetFilter 

4.3. SetFilterRange 
4.4. SetFilterFloatRange 
4.5. SetGeoAnchor 
4.6. SetFilterString 
5. GROUP BY settings 
5.1. SetGroupBy 
5.2. SetGroupDistinct 
6. Querying 
6.1. Query 
6.2. AddQuery 
6.3. RunQueries 
6.4. ResetFilters 
6.5. ResetGroupBy 
7. Additional functionality 
7.1. BuildExcerpts 
7.2. UpdateAttributes 
7.3. BuildKeywords 
7.4. EscapeString 
7.5. Status 
7.6. FlushAttributes 
8. Persistent connections 
8.1. Open 
8.2. Close 
MySQL storage engine (SphinxSE) 
1. SphinxSE overview 
2. Installing SphinxSE 
2.1. Compiling MySQL 5.0.x with SphinxSE 
2.2. Compiling MySQL 5.1.x with SphinxSE 
2.3. Checking SphinxSE installation 
3. Using SphinxSE 
4. Building snippets (excerpts) via MySQL 
Reporting bugs 
   sphinx.conf    options reference    
1. Data source configuration options 
1.1. type 
1.2. sql_host 
1.3. sql_port 
1.4. sql_user 
1.5. sql_pass 
1.6. sql_db 
1.7. sql_sock 
1.8. mysql_connect_flags 
1.9. mysql_ssl_cert, mysql_ssl_key, mysql_ssl_ca 
1.10. odbc_dsn 
1.11. sql_query_pre 
1.12. sql_query 
1.13. sql_joined_field 
1.14. sql_query_range 
1.15. sql_range_step 
1.16. sql_query_killlist 
1.17. sql_attr_uint 
1.18. sql_attr_bool 

1.19. sql_attr_bigint 
1.20. sql_attr_timestamp 
1.21. sql_attr_float 
1.22. sql_attr_multi 
1.23. sql_attr_string 
1.24. sql_attr_json 
1.25. sql_column_buffers 
1.26. sql_field_string 
1.27. sql_file_field 
1.28. sql_query_post 
1.29. sql_query_post_index 
1.30. sql_ranged_throttle 
1.31. xmlpipe_command 
1.32. xmlpipe_field 
1.33. xmlpipe_field_string 
1.34. xmlpipe_attr_uint 
1.35. xmlpipe_attr_bigint 
1.36. xmlpipe_attr_bool 
1.37. xmlpipe_attr_timestamp 
1.38. xmlpipe_attr_float 
1.39. xmlpipe_attr_multi 
1.40. xmlpipe_attr_multi_64 
1.41. xmlpipe_attr_string 
1.42. xmlpipe_attr_json 
1.43. xmlpipe_fixup_utf8 
1.44. mssql_winauth 
1.45. unpack_zlib 
1.46. unpack_mysqlcompress 
1.47. unpack_mysqlcompress_maxsize 
2. Index configuration options 
2.1. type 
2.2. source 
2.3. path 
2.4. docinfo 
2.5. mlock 
2.6. morphology 
2.7. dict 
2.8. index_sp 
2.9. index_zones 
2.10. min_stemming_len 
2.11. stopwords 
2.12. wordforms 
2.13. embedded_limit 
2.14. exceptions 
2.15. min_word_len 
2.16. charset_table 
2.17. ignore_chars 
2.18. min_prefix_len 
2.19. min_infix_len 
2.20. max_substring_len 
2.21. prefix_fields 
2.22. infix_fields 