Small Ant Learning Sphinx (1)--theory Chapter

On-line video on the Php+mysql+sphinx, before just heard, thought today finally able to learn a rise and gain insight, one hours of theoretical discourse finished, and did not anticipate the kind of knowledge to absorb a lot of satisfaction, one theory more, and secondly are in the operation of Linux, no way to practice , first write today's small notes, and then slowly delve into this piece of content.

Sphinx generates index data and provides a more specialized search function for the database.

Why do you use Sphinx? 1. When doing a search when the amount of data is very simple MySQL search is slow (if the table is more slowly) 2. Search Chinese Word segmentation 3. Fast speed

Gets the Sphinx. Http://sphinxsearch.com

How Sphinx works.

1. Modify the Sphinx configuration file

2. Using the indexer tool to generate index data

/usr/bin/indexer-config/etc/sphinxsearch/sphinx.conf-all

Generate Index data

View Sphinx Data

Enter mysql-h0-p9306 by command

When querying, follow the index name from the back. The fields of the data you get at the same time are all defined in the configuration file.

I've learned so much today, so I'm not feeling (⊙﹏⊙) b

Small Ant Learning Sphinx (1)--theory Chapter