sphinx-2.1.9的安装使用

1.下载/编译安装

cd /usr/local/src
wget http://sphinxsearch.com/files/sphinx-2.1.9-release.tar.gz
tar -xf sphinx-****.tar.gz
cd sphinx-****
./configure -prefix=/usr/local/sphinx  --with-mysql=/usr/local/mysql8(mysql的安装目录)
make && make install

2.配置sphinx

cd /usr/local/sphinx/etc 
cp sphinx-min.conf.dist  sphinx.conf  // 编辑配置

配置文件如下：

source main
{
    type            = mysql

    sql_host        = localhost
    sql_user        = root
    sql_pass        = root
    sql_db            = post
    sql_port        = 3306    # optional, default is 3306

    sql_query        = 
        SELECT id, title, content 
        FROM post_article

    #sql_attr_uint        = group_id
    #sql_attr_timestamp    = date_added

    sql_query_info        = SELECT * FROM post_article WHERE id=$id
}


index main
{
    source            = main
    path            = /usr/local/sphinx/var/data/main
    docinfo            = none
    charset_type        = sbcs
}

indexer
{
    mem_limit        = 128M
}


searchd
{
    listen            = 9312
    listen            = 9306:mysql41
    log            = /usr/local/sphinx/var/log/searchd.log
    query_log        = /usr/local/sphinx/var/log/query.log
    read_timeout        = 5
    max_children        = 30
    pid_file        = /usr/local/sphinx/var/log/searchd.pid
    max_matches        = 1000
    seamless_rotate        = 1
    preopen_indexes        = 1
    unlink_old        = 1
    workers            = threads # for RT to work
    binlog_path        = /usr/local/sphinx/var/data
}

 3.测试

cd /usr/local/sphinx
./bin/indexer --all

会有报错，报错信息如下：
error while loading shared libraries: libmysqlclient.so.21: cannot open shared object file: No such file or directory 
解决办法：
ln -s /usr/local/mysql8/lib/libmysqlclient.so.21 /usr/lib/libmysqlclient.so.21

从新 ./bin/index.....