Learn sphinx sphinx Chinese django sphinx python sphinx usage

How to use sphinx technology in our PHP development?

Answer: Corresponding to the fields in the MySQL database, it means splitting the Chinese information in the fields into multiple words, and then indexing these words. When querying in the future, first query these index files, then return the primary key IDs of the records that meet the conditions, and then query the MySQL database based on the primary key IDs to return the records.

What is sphinx? (Baidu Encyclopedia)

Note: For sphinx, if there are tens of millions of records in a single table, the response time is at the millisecond level.

Note: By default sphinx only supports English and Russian

Official website:

http://sphinxsearch.com/

Since Sphinx only supports the above two languages, a third-party company has developed a middle segmentation package for sphinx called coreseek

Official website:

http://www.coreseek.cn/

Customer case: http://www.coreseek.cn/products/ft_powered/

Note two points:

1. sphinx is a full-text search engine that only supports Russian and English

2. Due to the above reasons, a specialized company has developed a Chinese word segmentation package called coresesk.

3. There is a company in China that does a better job (massive word segmentation)

   http://www.hylanda.com/

   Story: http://home.hylanda.com/show_5_19.html

   

   Practical operation

4. Download

   

   2. Build a big data table (lyrics table)

   mysql > source d:/songs.sql

   File Directory:

   Command:

   

   sphinx installation-use

   Installation

   Please note: sphinx configuration file must not be opened using Windows Notepad. (BOM header)

   

   API interface file: You can use php to call this interface to operate the index file on the sphinx server side.

   

5. Modify configuration file

   

   Index file

   

   Memory settings:

   

   sphinxd configuration:

   

6. Indexing

   

   The name after index in the configuration file

   

   Directory structure after indexing

   

   3. Actual use

   a. Start the sphinx service and use the help information to see how to use it.

   

   Use:

7. You can read the configuration file separately and run it

8. can also be installed as a system service in Windows to run

   

   Start the sphinx service (read the configuration file for a single start)

   

   is defined as after system service (installation)

   

   Use

   1. Specific use (sphinx process can be seen in the picture below)

   sphinx flow chart:

   sphinx storage engine: Through the following steps, we found that when the PHP program performs a query, it must first return the primary key ID based on the sphinx server, then query the MySQL database based on the primary key ID, and finally return the database.

   At this time, you can think like this, use sphinx as a storage engine of MySQL. At this time, the php program can directly connect to the MySQL server, and the MySQL server obtains the word segmented data from its own sphinx storage engine. There is no need to connect to the sphinx server once. This storage engine is called sphinxSE.

   http://blog.csdn.net/uestc_huan/article/details/6395145

   

9. Easy to use

   

10. use

    

    

The above has introduced learning sphinx, including sphinx content. I hope it will be helpful to friends who are interested in PHP tutorials.