下载安装
wget http://sphinxsearch.com/files/sphinx-2.3.1-beta.tar.gz
tar zxvf sphinx-2.3.1-beta.tar.gz
cd sphinx-2.3.1-beta
./configure --prefix=/usr/local/sphinx –with-mysql
make
sudo make install
测试数据:
image.png
配置
cd /usr/local/sphinx/etc
sudo cp sphinx.conf.dist sphinx.conf
vim sphinx.conf
最精简配置
source src_doc
{
type = mysql
sql_host = localhost
sql_user = xxx
sql_pass = xxx
sql_db = xxx
sql_sock = /var/lib/mysql/mysql.sock
sql_query_pre = SET NAMES utf8
sql_query_pre = SET SESSION query_cache_type=OFF
sql_query = SELECT id,title,intro FROM kb_doc
sql_attr_uint = id
sql_field_string = title
sql_field_string = intro
sql_ranged_throttle = 0
}
index index_doc
{
source = src_doc
path = /usr/local/sphinx/var/data/doc
docinfo = extern
dict = keywords
mlock = 0
morphology = none
min_word_len = 1
ngram_len = 1
ngram_chars = U+3000..U+2FA1F
html_strip = 0
}
indexer
{
mem_limit = 256M
}
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
client_timeout = 300
max_children = 30
persistent_connections_limit = 30
pid_file = /usr/local/sphinx/var/log/searchd.pid
seamless_rotate = 1
preopen_indexes = 1
unlink_old = 1
mva_updates_pool = 1M
max_packet_size = 8M
max_filters = 256
max_filter_values = 4096
max_batch_queries = 32
}
SHOW VARIABLES LIKE "sock%";
启动服务
cd /usr/local/sphinx/bin
sudo ./indexer --all --rotate
sudo ./searchd
searchd 开启端口:
listening on all interfaces, port=9312
listening on all interfaces, port=9306
测试
<?php
header("content-type:text/html;charset=utf8");
include'./sphinxapi.php';
$sphinx=new SphinxClient();
$sphinx->SetServer('127.0.0.1',9312);
$res=$sphinx->Query("瑞典","*");
print_r($res);//打印数据
?>
执行脚本:
$ php demo.php
输出结果
Array
(
[error] =>
[warning] =>
[status] => 0
[fields] => Array
(
[0] => title
[1] => intro
)
[attrs] => Array
(
[title] => 7
[intro] => 7
)
[matches] => Array
(
[31] => Array
(
[weight] => 4681
[attrs] => Array
(
[title] => 瑞典哈马比生态城
[intro] => 位于瑞典首都的哈马比生态城是一个在可持续经济、环境和社会领域取得了显著成就的综合生态社区。该社区以高循环、低能耗等环保特征举世闻名。
为申办2004年奥运会，斯德哥尔摩市政府对哈马比社区进行规划和改造，虽然斯德哥尔摩未申报成功，但哈马比生态城的建设却继续进行了下去。
)
)
[32] => Array
(
[weight] => 4681
[attrs] => Array
(
[title] => 瑞典马尔默
[intro] => 马尔默是瑞典第三大城市，历史悠久，地理条件优越。这个曾经以重工业为主的城市，自上世纪九十年代以来，通过西港区城区改造等项目，大范围使用可再生清洁能源、采取垃圾分类回收和无害化处理，通过发展循环经济成功实现了从工业重镇向环保生态城市的转型。
)
)
[33] => Array
(
[weight] => 2632
[attrs] => Array
(
[title] => 瑞典斯德哥尔摩市Henriksdal污水厂
[intro] => Henriksdal是当今世界上最大规模的污水处理厂之一，所占空间为30万m3左右，拥有约长达18km的地下管道。该厂建设在岩洞内，地质结构特殊。在厂址上方生活的人口大约有1630人左右。
Henriksdal也是当今欧洲最大规模、最现代化的污水处理厂之一，于1941年建成开放，每天可轻度处理约15万m3的污水。Henriksdal表面的设施包括：控制中心、机械处理装置、淤泥存储箱、淤泥增稠装置、沼气池、沼气收集和存储装置。
)
)
)
[total] => 3
[total_found] => 3
[time] => 0.000
[words] => Array
(
[瑞] => Array
(
[docs] => 4
[hits] => 9
)
[典] => Array
(
[docs] => 17
[hits] => 19
)
)
)
