对wordpress安装和配置 Sphinx 搜索

1, Download Sphinx search engine from Sphinx

1
2
3
wget http://www.sphinxsearch.com/downloads/sphinx-0.9.8.tar.gz

tar xzvf sphinx-0.9.8.tar.gz

2, Install MySQL mysql-devel

1
yum install mysql-devel

3, Configure Sphinx

1
2
3
4
cd sphinx-0.9.8
./configure --prefix /home/sphinx/sphinxsearch --with-mysql
make
make install

4, Create a configuration file

1
2
cd /home/sphinx/sphinxsearch/etc
cp sphinx.conf.dist sphinx.conf

5, Edit sphix.conf

vi sphinx.conf

Configuration file sphinx.conf for wordpress

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
source mywhiteboard
{
type = mysql
sql_host = localhost
sql_user = mywhiteboard
sql_pass = a1b2c3z4y5x6
sql_db = ivdb
sql_port = 3306
sql_query = SELECT id, post_title, post_content FROM wp_posts
sql_query_info = SELECT * FROM wp_posts WHERE id =$id
}

index mywhiteboard
{
source = mywhiteboard
path = /home/sphinx/sphinxsearch/var/data/mywhiteboard
docinfo = extern
mlock = 0
morphology = stem_en
enable_star=1

stopwords = /home/sphinx/sphinxsearch/var/data/stopwords.txt
min_word_len = 3
charset_type = sbcs
min_prefix_len = 0
min_infix_len = 3
html_strip = 1
html_remove_elements = style, script
}

indexer
{
mem_limit = 256M
}
searchd
{
port = 3312
log = /home/sphinx/sphinxsearch/var/log/searchd.log
query_log = /home/sphinx/sphinxsearch/var/log/query.log
read_timeout = 5
max_children = 30
pid_file = /home/sphinx/sphinxsearch/var/log/searchd.pid
max_matches = 1000
seamless_rotate = 1
preopen_indexes = 0
unlink_old = 1
}

6, make a directory for indexes

mkdir /home/sphinx/sphinxsearch/var/data/mywhiteboard

7, Start indexer:

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

Sphinx 0.9.8-release (r1371)
Copyright (c) 2001-2008, Andrew Aksyonoff

using config file '/home/sphinx/sphinxsearch/etc/sphinx.conf'...
indexing index 'mywhiteboard'...
collected 1104407 docs, 1938.9 MB
sorted 6551.8 Mhits, 98.5% donedone
total 1104407 docs, 1938867135 bytes
total 5126.826 sec, 378180.78 bytes/sec, 215.42 docs/sec

8, To test if it is working:

1
/home/sphinx/sphinxsearch/bin/search  --config /home/sphinx/sphinxsearch/etc/sphinx.conf insulin
....
20\. document=9345, weight=3
    id=9345
....
words:
1\. 'insulin': 30601 documents, 109926 hits
1
2
3
4
5
6
7
8
9
10
ls -la
/home/sphinx/sphinxsearch/var/data/mywhiteboard
drwxr-xr-x 3 root root 4096 Oct 21 16:20 .
drwxr-xr-x 4 root root 4096 Sep 11 20:08 ..
-rw-r--r-- 1 root root 0 Oct 21 15:32 mywhiteboard.spa
-rw-r--r-- 1 root root 14925566596 Oct 21 16:20 mywhiteboard.spd
-rw-r--r-- 1 root root 237 Oct 21 16:20 mywhiteboard.sph
-rw-r--r-- 1 root root 57254921 Oct 21 16:20 mywhiteboard.spi
-rw-r--r-- 1 root root 0 Oct 21 15:32 mywhiteboard.spm
-rw-r--r-- 1 root root 22721504506 Oct 21 16:20 mywhiteboard.spp

wordpress-sphinx-search 插件的安装教程

http://www.ivinco.com/software/wordpress-sphinx-search-tutorial/