Sphinx Search Beginner's Guide电子书

Sphinx Search

Table of Contents

Sphinx Search

Credits

About the Author

Acknowledgement

About the Reviewers

www.PacktPub.com

Support files, eBooks, discount offers, and more

Why Subscribe?

Free Access for Packt account holders

Preface

What this book covers

Who this book is for

Conventions

Time for action - heading

What just happened?

Pop quiz - heading

Have a go hero - heading

Reader feedback

Customer support

Errata

Piracy

Questions

1. Setting Up Sphinx

What you need to know

Different ways of performing a search

Searching on a live database

Searching an index

Sphinx—a full-text search engine

Features

A brief history

License

Installation

System requirements

Sphinx on a Unix-based system

Time for action - installation on Linux

What just happened?

Options to the configure command

Known issues during installation

Sphinx on Windows

Time for action - installation on Windows

What just happened?

Sphinx on Mac OS X

Time for action - installation on a Mac

What just happened?

Other supported systems

Summary

2. Getting Started

Checking the installation

Full-text search

What is full-text search?

Traditional search

Time for action - normal search in MySQL

What just happened?

MySQL full-text search

Advantages of full-text search

When to use a full-text search?

Overview of Sphinx

Primary programs

Time for action - Sphinx in action

What just happened?

Data to be indexed

Creating the Sphinx configuration file

Searching the index

Have a go hero -

Why use Sphinx for full-text searching?

Summary

3. Indexing

What are indexes?

Indexes in Sphinx

Index attributes

Types of attributes

Multi-value attributes (MVA)

Data sources

How to define the data source?

SQL data sources

Creating Index using SQL data source (Blog)

Creating a simple index without any attributes

Time for action - creating database tables for a blog

What just happened?

Time for action - populate the database tables

What just happened?

Time for action - creating the Sphinx configuration file

What just happened?

The indexing workflow

Adding attributes to the index

Time for action - adding attributes to the index

What just happened?

Adding an MVA to the index

Time for action - Adding an MVA to the index

What just happened?

Filtering without searching for a specific phrase

xmlpipe data source

xmlpipe2 data source

Indexing with schema defined in XML stream

Time for action - creating index (without attributes)

What just happened?

Time for action - add attributes to schema

What just happened?

Indexing with schema defined in configuration file

Time for action - create index with schema defined in configuration file

What just happened?

Summary

4. Searching

Client API implementations for Sphinx

Search using client API

Time for action - creating a basic search script

What just happened?

Matching modes

Time for action - searching with different matching modes

What just happened?

Boolean query syntax

Time for action - searching using Boolean query syntax

What just happened?

Extended query syntax

Time for action - searching with extended query syntax

What just happened?

Filtering full-text search results

Time for action - filtering the result set

What just happened?

Weighting search results

Time for action - weighting search results

What just happened?

Sorting modes

Grouping search results

Summary

5. Feed Search

The application

Tools and software used while creating this application

Database structure

Time for action - creating the MySQL database and tables

What just happened?

Basic setup

Time for action - setting up the feeds application

What just happened?

Add feed

Time for action - creating a form to add feeds

What just happened?

Saving the feed data

Time for action - adding code to save feed

What just happened?

Indexing the feeds

Time for action - create the index

What just happened?

Check for duplicate items

Time for action - adding code to avoid duplicate items

What just happened?

Index merging

Time for action - adding the delta index

What just happened?

Search form

Time for action - creating the search form

What just happened?

Perform the search query

Time for action - adding code to perform a search query

What just happened?

Applying filters

Time for action - adding code to filter the results

What just happened?

Time for action - showing search form prefilled with last submitted data

What just happened?

Re-indexing

Have a go hero - trying different search queries

Summary

6. Property Search

The application

Tools and software used while creating this application

Database structure

Time for action - creating the MySQL database and structure

What just happened?

Initial data

Time for action - populating the database

What just happened?

Basic setup

Time for action - setting up the application

What just happened?

Adding a property

Time for action - creating the form to add property

What just happened?

Indexing the properties

Time for action - creating the index

What just happened?

Simple search form

Time for action - creating the simple search form

What just happened?

Full-text search

Time for action - adding code to perform full-text search

What just happened?

Have a go hero - try setting different field weights

Advanced search

Time for action - creating the Advanced search form

What just happened?

Ranged filters

Time for action - adding ranged filters

What just happened?

Have a go hero - adding filter for amenities

Geo distance search

Time for action - creating the search form

What just happened?

Add geo anchor

Time for action - adding code to perform geo distance search

What just happened?

Have a go hero - adding the delta index using the index merging technique

Summary

7. Sphinx Configuration

Sphinx configuration file

Rules for creating the configuration file

Data source configuration

SQL related options

Connection options

sql_port

sql_sock

odbc_dsn

Options to fetch data (SQL data source)

sql_query_pre

sql_query_post

sql_query_post_index

sql_ranged_throttle

Configuration file using advanced options

Time for action - creating a configuration with advanced source options

What just happened?

MS SQL specific options

mssql_winauth

mssql_unicode

Index configuration

Distributed searching

Set up an index on multiple servers

Time for action - creating indexes for distributed searching

What just happened?

Set up the distributed index on the primary server

Time for action - adding distributed index configuration

What just happened?

agent_blackhole

agent_connect_timeout

agent_query_timeout

Distributed searching on single server

charset configuration

charset_type

charset_table

Data related options

stopwords

min_word_len

ignore_chars

html_strip

html_index_attrs

html_remove_elements

Word processing options

Morphology

Time for action - using morphology for stemming

What just happened?

morphology

min_stemming_len

Wordforms

Search daemon configuration

listen

log

query_log

read_timeout

client_timeout

max_children

pid_file

max_matches

seamless_rotate

Indexer configuration

mem_limit

max_iops

max_iosize

max_xmlpipe2_field

Summary

8. What Next?

SphinxQL

SphinxQL in action

Time for action - querying Sphinx using MySQL CLI

What just happened?

SELECT

Column list clause

FROM clause

WHERE clause

GROUP BY clause

ORDER BY clause

LIMIT clause

OPTION clause

SHOW WARNINGS

SHOW STATUS

SHOW META

Use case scenarios

Popular websites using Sphinx

Summary

Index