sphinx Introduction and installation of sphinx

Introduction

Background:

1. Large amount of data, content review, existing search resume index is slow; staff turnover, existing search is difficult to maintain

2. Front-end calls are complex; full table scan is used, search speed is slow; the results are There is no sorting; it is difficult to find the most accurate data as quickly as possible

Suggested optimization:

1. High-speed index creation

2. Avoid doing like operations on the database and reduce pressure

3. Sort the search results by weight

4. Front-end development is easy to call

5. It is best to have a low threshold, easy to master and maintain in the future

---

Installation

1. Install the lamp environment

If you have already installed it, skip this step.
2. Download the required files
Note: If you use Ubuntu 10.10 (sphinxsearch), you can use apt-get install to install directly, you can skip this step (but Chinese word segmentation is not supported)
Coreseek Fulltext Server (source code): http://www.coreseek.cn/uploads/csft/3.1/Source/csft-3.1.tar.gz
Coreseek Mmseg (source code): http://www.coreseek.cn/uploads/csft/3.1/Source /mmseg-3.1.tar.gz
3. Tools must be installed
sudo apt-get install autoconf automake autotools-dev cpp curl gawk gcc lftp libc6-dev linux-libc-dev make libpcre3-dev libpcrecpp0 g++ libtool libncurses5-dev
sudo aptitude install libmysql++-dev libmysqlclient15-dev checkinstall
4. Install mmseg
sudo su
tar zxvf mmseg-3.1.tar.gz
mkdir /usr/local/mmseg
cd mmseg-3.1
./configure --prefix=/usr /local/mmseg
make
make install
5. Install sphinx
Note: If you use Ubuntu 10.10 (sphinxsearch), you can use sudo apt-get install sphinxsearch to quickly install (but Chinese word segmentation is not supported)
If not, use the following Command:
(If you are installing mysql manually below, please change --with-mysql to your corresponding mysql installation directory)
tar zxvf csft-3.1.tar.gz
mkdir /usr/local/coreseek
cd csft-3.1
./configure --prefix=/usr/local/coreseek --with-mysql --with-mmseg-includes=/usr/local/mmseg/include/mmseg --with-mmseg-libs=/usr/local/ mmseg/lib/
make clean
make
make install
6. Test
The installation is complete, the following is the test.
Note: If you use Ubuntu 10.10 (sphinxsearch), the following configuration file sphinx.conf.dist should be in /etc/sphinxsearch Directory
cd /usr/local/coreseek/etc
sudo cp sphinx.conf.dist sphinx.conf
sudo vim sphinx.conf (modification example is as follows)
mysql -uroot test < /usr/local/coreseek/etc/ example.sql (l creates a sample data table, of course you can also use phpmyadmin to import)
Note: If you use Ubuntu 10.10 (sphinxsearch), below you can directly use the commands sudo indexer --all and sudo search test
sudo /usr/ local/coreseek/bin/indexer -c /usr/local/coreseek/etc/sphinx.conf --all
sudo /usr/local/coreseek/bin/search -c /usr/local/coreseek/etc/sphinx.conf test

sudo /usr/local/coreseek/bin/searchd -c /usr/local/coreseek/etc/sphinx.conf (start searchd process for sphinxapi call)

Note: If you use Ubuntu 10.10 (sphinxsearch ), the following parameters should be modified as follows:
path = /var/lib/sphinxsearch/data/idxbook1
log = /var/log/sphinxsearch/searchd.log
query_log = /var/log/sphinxsearch/query. log
pid_file = /var/run/searchd.pid
Also, the charset_dictpath and charset_table parameters will not be supported, that is, Chinese word segmentation will not be supported

The above introduces the introduction and installation of sphinx, including sphinx content. I hope it will be helpful to friends who are interested in PHP tutorials.