Sphinx安装与使用

最新推荐文章于 2024-06-27 18:30:24 发布

君君要上天

最新推荐文章于 2024-06-27 18:30:24 发布

阅读量1.3k

点赞数

分类专栏： sphinx 文章标签： sphinx

本文链接：https://blog.csdn.net/u010837612/article/details/70826860

版权

sphinx 专栏收录该内容

6 篇文章 0 订阅

订阅专栏

Sphinx安装

首先你要有mysql环境，我使用的是lnmp环境

下载并安装Sphinx，版本可自由选择

wget http://sphinxsearch.com/files/sphinx-2.2.11-release.tar.gz
tar -zxvf sphinx-2.2.11-release.tar.gz
cd sphinx-2.2.11-release.tar.gz
./configure --prefix=/usr/local/sphinx --with-mysql=/usr/local/mysql
make && make install

创建数据

在mysql中建表

CREATE TABLE `article` (
  `id` int(11) NOT NULL,
  `content` varchar(200) NOT NULL DEFAULT '',
  `createtime` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

插入数据

INSERT INTO `article` VALUES ('1', 'hello world', '2016-11-11 00:36:23');
INSERT INTO `article` VALUES ('2', 'php is greater than others', '2016-11-10 00:36:59');

配置sphinx

进入Sphinx配置文件所在目录

cd /usr/local/sphinx/ect/

你能看到三个文件：
example.sql sphinx.conf.dist sphinx-min.conf.dist

我们使用第三个，最简单的配置

cp sphinx-min.conf.dist sphinx.conf
vim sphinx.conf

配置文件如下：

source article_src
{
    type            = mysql

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

    sql_query       = \
        SELECT id, content,createtime FROM article 

    #sql_attr_uint      = group_id
    #sql_attr_timestamp = date_added
}
index article 
{
    source          = article_src
    path            = /usr/local/sphinx/var/data/article
}

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
    seamless_rotate     = 1
    preopen_indexes     = 1
    unlink_old      = 1
    workers         = threads # for RT to work
    binlog_path     = /usr/local/sphinx/var/data
}