Home > Article > Backend Development > 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:
sphinx is a full-text search engine that only supports Russian and English
Due to the above reasons, a specialized company has developed a Chinese word segmentation package called coresesk.
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
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.
Modify configuration file
Index file
Memory settings:
sphinxd configuration:
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:
You can read the configuration file separately and run it
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
Easy to use
use
The above has introduced learning sphinx, including sphinx content. I hope it will be helpful to friends who are interested in PHP tutorials.