windows安裝sphinx

標籤：

1.在http://sphinxsearch.com/downloads/release/下載32位版本（先是試了下64位版本，運行searchd的時候出錯，不知道怎麼解決，32位版本的不報錯）。

2.壓縮包解壓。將sphinx-min.conf.in複製一份副本並改名為sphinx.conf，並且建立兩個檔案夾，分別為data和log

3.sphinx.conf裡面的配置參數要改的地方如下（按照自己的環境進行修改）：

## Minimal Sphinx configuration sample (clean, simple, functional)#source src1{    type            = mysql    sql_host        = localhost    sql_user        = test    sql_pass        = 1234    sql_db            = test    sql_port        = 3306    # optional, default is 3306    sql_query        =         SELECT id, group_id, UNIX_TIMESTAMP(date_added) AS date_added, title, content         FROM documents    sql_attr_uint        = group_id    sql_attr_timestamp    = date_added}index test1{    source            = src1    path            = D:/program/sphinx-2.2.6-release-win32/data/}#index testrt#{#    type            = rt#    rt_mem_limit        = 128M##    path            = @[email protected]/data/testrt##    rt_field        = title#    rt_field        = content#    rt_attr_uint        = gid#}indexer{    mem_limit        = 128M}searchd{    listen            = 9312    listen            = 9306:mysql41    log            = D:/program/sphinx-2.2.6-release-win32/log/searchd.log    query_log        = D:/program/sphinx-2.2.6-release-win32/log/query.log    read_timeout        = 5    max_children        = 30    pid_file        = D:/program/sphinx-2.2.6-release-win32/log/searchd.pid    seamless_rotate        = 1    preopen_indexes        = 1    unlink_old        = 1    workers            = threads # for RT to work    binlog_path        = D:/program/sphinx-2.2.6-release-win32/data/}

4.可以將sphinx壓縮包內內建的example.sql匯入進本地mysql中，以便測試：

>mysql -utest -p test < example.sql

5.命令列切換到sphinx的根目錄下面，執行以下命令建立索引：

>bin\indexer.exe test1

6.執行以下命令建立搜尋服務：

>sc delete searchd

>bin\searchd.exe --install --config D:/program/sphinx-2.2.6-release-win32/sphinx.conf

7.利用sphinxapi.php進行測試，在web目錄下面建立一個php測試檔案：

<?phprequire(‘sphinxapi.php‘);$s=new SphinxClient();$s->SetServer(‘localhost‘, ‘9312‘);$result=$s->Query(‘test‘, ‘test1‘);echo ‘<pre>‘;print_r($result);echo ‘</pre>‘;?>

以下是瀏覽器輸出：

Array(    [error] =>     [warning] =>     [status] => 0    [fields] => Array        (            [0] => title            [1] => content        )    [attrs] => Array        (            [group_id] => 1            [date_added] => 2        )    [matches] => Array        (            [1] => Array                (                    [weight] => 2421                    [attrs] => Array                        (                            [group_id] => 1                            [date_added] => 1419180445                        )                )            [2] => Array                (                    [weight] => 2421                    [attrs] => Array                        (                            [group_id] => 1                            [date_added] => 1419180445                        )                )            [4] => Array                (                    [weight] => 1442                    [attrs] => Array                        (                            [group_id] => 2                            [date_added] => 1419180445                        )                )        )    [total] => 3    [total_found] => 3    [time] => 0.000    [words] => Array        (            [test] => Array                (                    [docs] => 3                    [hits] => 5                )        ))

 

windows安裝sphinx