sphinx在windows下的簡單安裝與使用

標籤：style   http   color   java   使用   os   io   strong   

1、 http://sphinxsearch.com/downloads/release/，我這裡下的是“Win64 binaries w/MySQL+PgSQL+libstemmer+id64 support”，下載後檔案名稱：sphinx-2.0.6-release-win64-id64-full.zip；

 2、將其解壓到D: \ sphinx，並在D:\sphinx下建立目錄data(用來存放索引檔案)與log(用來存放記錄檔)； 3、將D:\sphinx\sphinx.conf.in複製到D:\sphinx\bin\sphinx.conf.in，並重新命名為sphinx.conf； 4、修改 D:\sphinx\bin\sphinx.conf 如下：    4.1、搜尋source src1修改{...}中的內容        # 使用的資料庫類型        type = mysql         # 伺服器        sql_host = localhost         # 資料庫登入名稱        sql_user = root         # 資料庫登入密碼        sql_pass = root         # 操作的資料庫名稱        sql_db = test         # 資料庫伺服器連接埠        sql_port = 3306         # 設定編碼，如果用的是utf-8編碼        sql_query_pre = SET NAMES utf-8         （以上7條前如有#將其刪除）    4.2、搜尋index test1修改{...}中的內容        # 放索引的目錄        path = D:/sphinx/data/         # 編碼        charset_type = utf-8         # 指定utf-8編碼錶        charset_table = 0..9, A..Z->a..z, _, a..z, U+410..U+42F->U+430..U+44F, U+430..U+44F         # 簡單分詞，只有0和1，需要搜尋中文必須置1        ngram_len = 1         # 需要分詞的字元，搜尋中文時必須        ngram_chars = U+3000..U+2FA1F         （以上5條前如有#將其刪除） 5、匯入測試資料將D:\sphinx\example.sql中語句執行到test資料庫中，注意：test資料庫建立時需要指定為utf-8格式； 6、開啟cmd視窗，進入目錄D:\sphinx\bin； 7、建立索引，執行 indexer.exe test1，test1即為sphinx.conf中index test1

Sphinx 2.0.6-id64-release (r3473)Copyright (c) 2001-2012, Andrew AksyonoffCopyright (c) 2008-2012, Sphinx Technologies Inc (http://sphin using config file ‘./sphinx.conf‘...indexing index ‘test1‘...collected 4 docs, 0.0 MBsorted 0.0 Mhits, 100.0% donetotal 4 docs, 222 bytestotal 0.019 sec, 11252 bytes/sec, 202.74 docs/sectotal 2 reads, 0.000 sec, 0.2 kb/call avg, 0.0 msec/call avgtotal 9 writes, 0.000 sec, 0.1 kb/call avg, 0.0 msec/call avg

    成功... 8、搜尋‘test‘，執行 search.exe test

Sphinx 2.0.6-id64-release (r3473)Copyright (c) 2001-2012, Andrew AksyonoffCopyright (c) 2008-2012, Sphinx Technologies Inc (http://sphinxsearch.com) using config file ‘./sphinx.conf‘...index ‘test1‘: query ‘test ‘: returned 3 matches of 3 total in 0.000 sec displaying matches:1. document=1, weight=2421, group_id=1, date_added=Tue Feb 26 10:25:31 2013        id=1        group_id=1        group_id2=5        date_added=2013-02-26 10:25:31        title=test one        content=this is my test document number one. also checking search within phrases.2. document=2, weight=1442, group_id=3, date_added=Tue Feb 26 10:25:31 2013        id=2        group_id=3        group_id2=6        date_added=2013-02-26 10:25:31        title= ????        content=this is my test document number two ???????3. document=4, weight=1442, group_id=2, date_added=Tue Feb 26 10:25:31 2013        id=4        group_id=2        group_id2=8        date_added=2013-02-26 10:25:31        title=doc number four        content=this is to test groups words:1. ‘test‘: 3 documents, 4 hits index ‘test1stemmed‘: search error: failed to open D:/sphinx/data/test1stemmed.sph: No such file or directory.

     最後面的一句error可忽略； 9、搜尋中文，首先將資料庫中的內容update含有中文，執行sql語句：

UPDATE documents SET title=‘中文‘, content=‘this is my test document number one. also checking search within phrases.含有中文。‘ WHERE id=1;UPDATE documents SET title=‘中文標題‘, content=‘this is my test document number one. also checking search within phrases.含有中文內容。‘ WHERE id=2;UPDATE documents SET title=‘中文標題測試‘, content=‘this is my test document number one. also checking search within phrases.含有中文內容。‘ WHERE id=3;

重建立立索引（執行第7步）；然後執行 search.exe 中文

Sphinx 2.0.6-id64-release (r3473)Copyright (c) 2001-2012, Andrew AksyonoffCopyright (c) 2008-2012, Sphinx Technologies Inc (http://sphinxsearch.com) using config file ‘./sphinx.conf‘...indexing index ‘test1‘...collected 4 docs, 0.0 MBsorted 0.0 Mhits, 100.0% donetotal 4 docs, 349 bytestotal 0.025 sec, 13808 bytes/sec, 158.26 docs/sectotal 2 reads, 0.000 sec, 0.3 kb/call avg, 0.0 msec/call avgtotal 9 writes, 0.000 sec, 0.2 kb/call avg, 0.0 msec/call avg D:\sphinx\bin>search.exe 中文Sphinx 2.0.6-id64-release (r3473)Copyright (c) 2001-2012, Andrew AksyonoffCopyright (c) 2008-2012, Sphinx Technologies Inc (http://sphinxsearch.com) using config file ‘./sphinx.conf‘...index ‘test1‘: query ‘中文 ‘: returned 0 matches of 0 total in 0.000 sec words: index ‘test1stemmed‘: search error: failed to open D:/sphinx/data/test1stemmed.sph: No such file or directory.

    沒有搜尋到，因為windows命令列中的中文時GBK編碼格式，所以沒有匹配內容。我們可以使用PHP程式來試試； 10、進入D:\sphinx\api\目錄，可以發現sphinx支援php、java、ruby調用，並提供對應的test例子，這裡我們使用php來操作，首先將api複製到D:\www\下並重新命名為sphinxapi，因為我本機上apache的web目錄為D:\www，在D:\www\sphinxapi\下建立search.php，內容為：

<?phprequire ‘sphinxapi.php‘;$s = new SphinxClient();$s->SetServer(‘localhost‘, 9312);$result = $s->Query(‘中國‘);print_r($result);echo ‘<br /><br />‘;$result = $s->Query(‘中文‘);print_r($result);?>

    然後回到cmd命令列中，開啟sphinx服務，執行 searchd.exe(這個必須要執行的)

Sphinx 2.0.6-id64-release (r3473)Copyright (c) 2001-2012, Andrew AksyonoffCopyright (c) 2008-2012, Sphinx Technologies Inc (http://sphinxsearch.com) using config file ‘./sphinx.conf‘...WARNING: compat_sphinxql_magics=1 is deprecated; please update your applicationand configWARNING: preopen_indexes=1 has no effect with seamless_rotate=0listening on all interfaces, port=9312listening on all interfaces, port=9306precaching index ‘test1‘precaching index ‘test1stemmed‘WARNING: index ‘test1stemmed‘: preload: failed to open D:/sphinx/data/test1stemmed.sph: No such file or directory; NOT SERVINGprecaching index ‘rt‘WARNING: index ‘rt‘: preload: failed to open @[email protected]/data/rt.lock: No such file or directory; NOT SERVINGprecached 3 indexes in 0.018 sec

    成功...    然後在瀏覽器中執行http://localhost/sphinxapi/search.php，列印出來的數組結果可以很清晰的看見搜尋的結果比對。。。 11、至此sphinx在windows下的簡單安裝與使用就完成了。。。