sphinx的使用

野性酷女 2022-06-15 01:49 233阅读 0赞

刚接触使用sphinx，读了些资料，现在就把我所理解到的记录下：

1：修改sphinx.conf文件后，需要重新建立索引，查询才会生效，所谓的全文索引查找，就是在setfilter后（相当于sql的where条件)，query('content','index‘);

(1)：content代表要查询的文字。(2)：index是建立的要查询的索引

找到匹配的结果。

2：当我们使用API从sphinx执行了一个查询之后，接口会返回一个数组。在这个数组中存在total\_found和total两个值。

当查询出的结果数小于sphin中配置的最大返回结果数（默认为1000）时，这两个值是相等的。

而查询出的结果数大于sphin中配置的最大返回结果数（默认为1000）时，total\_found的值是在sphinx中所有满足搜索条件的结果数，而total返回的是sphin中配置的最大返回值。

因此，在分页等需要所有满足搜索条件的结果数的时候，应该使用total\_found的值。

3：代码实例如下

require(“sphinxapi.php”);              //加载类文件

$cl=new SphinxClient();               //实例化类

$cl->SetServer(‘localhost’,9312); //设置服务

$cl->SetArrayResult(true);           //设置 显示结果集方式

$cl->SetLimits(0,10);                   //同 sql语句中的LIMIT

$cl->SetSortMode(“mode”);         //排序模式 SPH\_SORT\_ATTR\_DESC和SPH\_SORT\_ATTR\_ASC

$result=$cl->Query(‘ff’,\[索引名称可选\]);                 //执行搜索

Var\_dump($result);                      //输出

4：sphinx建立所以 及监听

切换到 DOS sphinx/bin 目录下

a.       建立索引

Indexer  –c  sphinx.conf  索引名称/–all (–all参数是建立所有索引)

完成后提示如下:

total 535600 docs, 10707632 bytes

total 34.323 sec, 311958 bytes/sec, 15604.27 docs/sec

total 5 reads, 0.282 sec, 45592.6 kb/call avg, 56.4 msec/call avg

total 547 writes, 12.172 sec, 1017.0 kb/call avg, 22.2 msec/call avg

b.       建立完成后

可以执行 search \[–c\] sphinx.conf 搜索内容 (-c参数:是否允许模糊搜索)

c.       监听端口

Searchd

运行后 提示

listening on all interfaces, port=9312

accepting connections

监听成功后 既可以运行PHP程序 进行 搜索

5：

<table style="border-top-width:0px; border-right-width:1px; border-bottom-width:1px; border-left-width:1px; border-top-style:initial; border-right-style:solid; border-bottom-style:solid; border-left-style:solid; border-top-color:initial; border-right-color:rgb(204,204,204); border-bottom-color:rgb(204,204,204); border-left-color:rgb(204,204,204); font-size:0.8em; width:708px"> 
 <tbody> 
 <tr> 
 <th style="font-family:arial,nsimsun,sans-serif; font-size:12px; border-top-width:1px; border-right-width:1px; border-bottom-width:1px; border-left-width:1px; border-top-style:solid; border-right-style:dotted; border-bottom-style:dotted; border-left-style:dotted; border-top-color:rgb(204,204,204); border-right-color:rgb(211,211,211); border-bottom-color:rgb(211,211,211); border-left-color:rgb(211,211,211); padding-top:8px; padding-right:5px; padding-bottom:8px; padding-left:5px; vertical-align:top; background-color:rgb(247,248,252); text-align:left"> 属性</th> 
 <th style="font-family:arial,nsimsun,sans-serif; font-size:12px; border-top-width:1px; border-right-width:1px; border-bottom-width:1px; border-left-width:1px; border-top-style:solid; border-right-style:dotted; border-bottom-style:dotted; border-left-style:dotted; border-top-color:rgb(204,204,204); border-right-color:rgb(211,211,211); border-bottom-color:rgb(211,211,211); border-left-color:rgb(211,211,211); padding-top:8px; padding-right:5px; padding-bottom:8px; padding-left:5px; vertical-align:top; background-color:rgb(247,248,252); text-align:left"> 描述</th> 
 </tr> 
 <tr> 
 <td style="font-family:arial,nsimsun,sans-serif; font-size:12px; border-top-width:1px; border-right-width:1px; border-bottom-width:1px; border-left-width:1px; border-top-style:solid; border-right-style:dotted; border-bottom-style:dotted; border-left-style:dotted; border-top-color:rgb(204,204,204); border-right-color:rgb(211,211,211); border-bottom-color:rgb(211,211,211); border-left-color:rgb(211,211,211); padding-top:8px; padding-right:5px; padding-bottom:8px; padding-left:5px; vertical-align:top; background-color:rgb(237,237,237)"> <code style="font-family:monospace; font-size:small!important">sql_attr_uint</code>&nbsp;和<code style="font-family:monospace; font-size:small!important">sql_attr_bigint</code></td> 
 <td style="font-family:arial,nsimsun,sans-serif; font-size:12px; border-top-width:1px; border-right-width:1px; border-bottom-width:1px; border-left-width:1px; border-top-style:solid; border-right-style:dotted; border-bottom-style:dotted; border-left-style:dotted; border-top-color:rgb(204,204,204); border-right-color:rgb(211,211,211); border-bottom-color:rgb(211,211,211); border-left-color:rgb(211,211,211); padding-top:8px; padding-right:5px; padding-bottom:8px; padding-left:5px; vertical-align:top; background-color:rgb(237,237,237)"> 32 位无符号整数值和 64 位有符号整数值。可对所有整数数据库字段和&nbsp;<code style="font-family:monospace; font-size:small!important">DATE</code>&nbsp;使用这两种类型。</td> 
 </tr> 
 <tr> 
 <td style="font-family:arial,nsimsun,sans-serif; font-size:12px; border-top-width:1px; border-right-width:1px; border-bottom-width:1px; border-left-width:1px; border-top-style:solid; border-right-style:dotted; border-bottom-style:dotted; border-left-style:dotted; border-top-color:rgb(204,204,204); border-right-color:rgb(211,211,211); border-bottom-color:rgb(211,211,211); border-left-color:rgb(211,211,211); padding-top:8px; padding-right:5px; padding-bottom:8px; padding-left:5px; vertical-align:top"> <code style="font-family:monospace; font-size:small!important">sql_attr_float</code></td> 
 <td style="font-family:arial,nsimsun,sans-serif; font-size:12px; border-top-width:1px; border-right-width:1px; border-bottom-width:1px; border-left-width:1px; border-top-style:solid; border-right-style:dotted; border-bottom-style:dotted; border-left-style:dotted; border-top-color:rgb(204,204,204); border-right-color:rgb(211,211,211); border-bottom-color:rgb(211,211,211); border-left-color:rgb(211,211,211); padding-top:8px; padding-right:5px; padding-bottom:8px; padding-left:5px; vertical-align:top"> 32 位浮点值。如果您想要存储地理坐标，可使用此属性类型。还要注意的是，如果您需要更高的精确度，则没有解决方法；字段四舍五入到七位小数。</td> 
 </tr> 
 <tr> 
 <td style="font-family:arial,nsimsun,sans-serif; font-size:12px; border-top-width:1px; border-right-width:1px; border-bottom-width:1px; border-left-width:1px; border-top-style:solid; border-right-style:dotted; border-bottom-style:dotted; border-left-style:dotted; border-top-color:rgb(204,204,204); border-right-color:rgb(211,211,211); border-bottom-color:rgb(211,211,211); border-left-color:rgb(211,211,211); padding-top:8px; padding-right:5px; padding-bottom:8px; padding-left:5px; vertical-align:top"> <code style="font-family:monospace; font-size:small!important">sql_attr_bool</code></td> 
 <td style="font-family:arial,nsimsun,sans-serif; font-size:12px; border-top-width:1px; border-right-width:1px; border-bottom-width:1px; border-left-width:1px; border-top-style:solid; border-right-style:dotted; border-bottom-style:dotted; border-left-style:dotted; border-top-color:rgb(204,204,204); border-right-color:rgb(211,211,211); border-bottom-color:rgb(211,211,211); border-left-color:rgb(211,211,211); padding-top:8px; padding-right:5px; padding-bottom:8px; padding-left:5px; vertical-align:top"> 一个布尔型（单个位）值，类似于 MySQL 的&nbsp;<code style="font-family:monospace; font-size:small!important">tinyint</code>&nbsp;值。</td> 
 </tr> 
 <tr> 
 <td style="font-family:arial,nsimsun,sans-serif; font-size:12px; border-top-width:1px; border-right-width:1px; border-bottom-width:1px; border-left-width:1px; border-top-style:solid; border-right-style:dotted; border-bottom-style:dotted; border-left-style:dotted; border-top-color:rgb(204,204,204); border-right-color:rgb(211,211,211); border-bottom-color:rgb(211,211,211); border-left-color:rgb(211,211,211); padding-top:8px; padding-right:5px; padding-bottom:8px; padding-left:5px; vertical-align:top"> <code style="font-family:monospace; font-size:small!important">sql_attr_timestamp</code></td> 
 <td style="font-family:arial,nsimsun,sans-serif; font-size:12px; border-top-width:1px; border-right-width:1px; border-bottom-width:1px; border-left-width:1px; border-top-style:solid; border-right-style:dotted; border-bottom-style:dotted; border-left-style:dotted; border-top-color:rgb(204,204,204); border-right-color:rgb(211,211,211); border-bottom-color:rgb(211,211,211); border-left-color:rgb(211,211,211); padding-top:8px; padding-right:5px; padding-bottom:8px; padding-left:5px; vertical-align:top"> 一种 UNIX 时间戳，可表示从 1970-01-01 到 2038-01-19 的日期/时间值。您在 Sphinx 中无法直接使用&nbsp;<code style="font-family:monospace; font-size:small!important">DATE</code>&nbsp;或&nbsp;<code style="font-family:monospace; font-size:small!important">DATETIME</code>&nbsp;列类型。您必须使用&nbsp;<code style="font-family:monospace; font-size:small!important">UNIX_TIMESTAMP()</code>&nbsp;函数将它们转换为时间戳。如果您仅需要日期，可使用&nbsp;<code style="font-family:monospace; font-size:small!important">TO_DAYS()</code>&nbsp;函数将&nbsp;<code style="font-family:monospace; font-size:small!important">DATE</code>&nbsp;字段转换为一个整数。</td> 
 </tr> 
 <tr> 
 <td style="font-family:arial,nsimsun,sans-serif; font-size:12px; border-top-width:1px; border-right-width:1px; border-bottom-width:1px; border-left-width:1px; border-top-style:solid; border-right-style:dotted; border-bottom-style:dotted; border-left-style:dotted; border-top-color:rgb(204,204,204); border-right-color:rgb(211,211,211); border-bottom-color:rgb(211,211,211); border-left-color:rgb(211,211,211); padding-top:8px; padding-right:5px; padding-bottom:8px; padding-left:5px; vertical-align:top"> <code style="font-family:monospace; font-size:small!important">sql_attr_string</code>&nbsp;和<code style="font-family:monospace; font-size:small!important">sql_field_string</code></td> 
 <td style="font-family:arial,nsimsun,sans-serif; font-size:12px; border-top-width:1px; border-right-width:1px; border-bottom-width:1px; border-left-width:1px; border-top-style:solid; border-right-style:dotted; border-bottom-style:dotted; border-left-style:dotted; border-top-color:rgb(204,204,204); border-right-color:rgb(211,211,211); border-bottom-color:rgb(211,211,211); border-left-color:rgb(211,211,211); padding-top:8px; padding-right:5px; padding-bottom:8px; padding-left:5px; vertical-align:top"> 字符串（很明显！），但前者仅用于检索，而后者可作为全文本被索引。</td> 
 </tr> 
 </tbody> 
</table>

6：

## 如何改变Sphinx搜索的Total最大限制值 ##

> Sphinx搜索匹配的总数默认为1000。不过，你可以修改成任意值。官方建议是1,000 - 10,000 之间。 
> 
> **修改Sphinx搜索匹配总数的方法** 
> 
> 假如你希望搜索匹配总数为 8000 
> 
> 1） Sphinx.conf（修改配置文件需要重新建立索引） 
> max\_matches = 8000 <-修改成你希望的值 
> 
>

> 2）sphinxapi.php

>  $this->\_maxmatches = 8000; //改成希望的值

> 
> 3）Sphinx客户端调用 
> sphinxClient.SetLimits(0,10, 8000); <-修改第三个参数

sphinx服务启动

<table style="margin:0px; padding:0px; border:0px; font-size:13px; vertical-align:baseline; border-collapse:collapse; border-spacing:0px; color:rgb(0,0,0); font-family:Arial,'Liberation Sans','DejaVu Sans',sans-serif; line-height:12.800000190734863px"> 
 <tbody style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent"> 
 <tr style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent"> 
 <td style="margin:0px; padding:0px; border:0px; font-size:13px; vertical-align:top; background-color:transparent; width:60px"> 
 <div style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent; text-align:center"> 
 1 
 <a title="This answer is not useful" style="margin:0px auto; padding:0px; border:0px; font-size:1px; vertical-align:baseline; background-color:transparent; color:rgb(0,119,204); overflow:hidden; display:block; width:41px; height:25px; text-indent:-9999em" rel="nofollow">down vote</a> 
 <span title="loading when this answer was accepted..." style="margin:0px auto; padding:0px; border:0px; font-size:1px; vertical-align:baseline; background-color:transparent; overflow:hidden; text-indent:-9999em; width:39px; height:40px; display:block; color:rgb(128,129,133)">accepted 
 </div> </td> 
 <td style="margin:0px; padding:0px; border:0px; font-size:13px; vertical-align:baseline; background-color:transparent"> 
 <div style="margin:0px 5px 5px 0px; padding:0px; border:0px; font-size:14px; vertical-align:baseline; background-color:transparent; word-wrap:break-word; width:660px; line-height:17.804800033569336px"> 
 You'll need to call indexer on the new index to create it and then --rotate to update it. 
 So it would be something like 
 <pre><code><code style="margin:0px; padding:0px; border:0px; vertical-align:baseline; font-family:Consolas,Menlo,Monaco,'Lucida Console','Liberation Mono','DejaVu Sans Mono','Bitstream Vera Sans Mono','Courier New',monospace,serif; white-space:inherit">indexer --config /path/to/config.conf indexname</code></code></pre> 
 And then when you just want to update your indexes 
 <pre><code><code style="margin:0px; padding:0px; border:0px; vertical-align:baseline; font-family:Consolas,Menlo,Monaco,'Lucida Console','Liberation Mono','DejaVu Sans Mono','Bitstream Vera Sans Mono','Courier New',monospace,serif; white-space:inherit">indexer --config /path/to/config.conf --rotate --all</code></code></pre> 
 This will create a temporary copy of each index and replace the old ones when finished. For more info on what actually happens see&nbsp;<a href="http://sphinxsearch.com/docs/manual-0.9.9.html#ref-indexer" style="margin:0px; padding:0px; border:0px; vertical-align:baseline; background-color:transparent; color:rgb(74,107,130); text-decoration:none" rel="nofollow">http://sphinxsearch.com/docs/manual-0.9.9.html#ref-indexer</a> 
 On the other error your getting Do 
 <pre><code><code style="margin:0px; padding:0px; border:0px; vertical-align:baseline; font-family:Consolas,Menlo,Monaco,'Lucida Console','Liberation Mono','DejaVu Sans Mono','Bitstream Vera Sans Mono','Courier New',monospace,serif; white-space:inherit">ps aux | grep searchd</code></code></pre> 
 if it returns no results, then remove /usr/local/sphinx/var/log/searchd.pid and start searchd again 
 </div> </td> 
 </tr> 
 </tbody> 
</table>