【原创】sphinx实时索引的配置及实际应用、实例
用coreseek快速搭建sphinx中文分词搜索引擎 的文章链接为： http://blog.zhuyin.org/789.html 本文假设您已经建立好coreseek的普通索引应用了 下面基于这个基础，谈谈如何实现实时索引！ #建立实时索引的配置文件 vi /usr/local/coreseek/etc/sphinx_index_r
用coreseek快速搭建sphinx中文分词搜索引擎 的文章链接为：
http://blog.zhuyin.org/789.html
本文假设您已经建立好coreseek的普通索引应用了
下面基于这个基础，谈谈如何实现实时索引！
#建立实时索引的配置文件
vi /usr/local/coreseek/etc/sphinx_index_rt.conf
index rtindex
{
type = rt
path = /dev/shm/rtindex
docinfo = extern
mlock = 0
morphology = none
min_word_len = 1
html_strip = 0
charset_dictpath = /usr/local/mmseg3/etc/
charset_type = zh_cn.utf-8
rt_field = title
rt_field = content
rt_attr_uint = groupid
rt_attr_bigint = biguid
rt_attr_float = score
rt_attr_timestamp = date_added
rt_attr_string = author
rt_attr_string = title
rt_attr_string = content
rt_mem_limit = 512M
}
searchd
{
workers = threads
listen = 9312
listen = 127.0.0.1:9306:mysql41
read_timeout = 5
max_children = 30
max_matches = 1000
seamless_rotate = 0
preopen_indexes = 0
unlink_old = 1
pid_file = /usr/local/coreseek/var/log/searchd_rtindex.pid
log = /usr/local/coreseek/var/log/searchd_rtindex.log
query_log = /usr/local/coreseek/var/log/query_rtindex.log
binlog_path = /usr/local/coreseek/var/log/rtindex/
binlog_flush = 2
binlog_max_log_size = 16M
}
上面的属性就不一一说了，只要留意
rt_field
rt_attr_uint
rt_attr_bigint
rt_attr_string
……
之类的就好，因为这些属性关系到您要索引的字段以及得到的结果是否包含这些字段的内容！
当然
rt_mem_limit
binlog_max_log_size
pid_file
之类的，请根据自己的实际环境设置好。
配置好上面的配置后
#实时索引不需要indexer！！，也就是不需要下面两句的命令了
#/usr/local/coreseek/bin/indexer -c /usr/local/coreseek/etc/sphinx_index_rt.conf –all
#/usr/local/coreseek/bin/search -c etc/csft.conf -a Twittter
#直接开启searchd /usr/local/coreseek/bin/searchd --config /usr/local/coreseek/etc/sphinx_index_rt.conf #创建管理命令 echo '/usr/local/coreseek/bin/searchd --config /usr/local/coreseek/etc/sphinx_index_rt.conf' > /root/sphinx_start echo 'killall searchd' > /root/sphinx_stop echo 'killall searchd sleep 4 /usr/local/coreseek/bin/searchd --config /usr/local/coreseek/etc/sphinx_index_rt.conf' > /root/sphinx_restart chmod 755 /root/sphinx*
这个时候您
ps awx|grep searchd
应该有以下的进程在跑了：
到这里表明实时索引服务已经启动，下面就是自己写程序往数据源添加内容了。
在此要特别说明一下：
sphinx的实时索引配置本身并不需要数据源(source),它的数据是要通过程序利用
localhost:9306:mysql41协议的方式，往里面加。
下面就写一段实际应用的php代码吧：
比如我有一个文章表 news 需要做实时索引
那在插入、删除、修改 news表的内容的同时，您得写一段类似下面的代码来对实时索引的内容进行更改：
//插入到news表的操作完成后
//连接到实时索引，使用MySQL41协议
$link = mysql_connect('127.0.0.1:9306') or die('connect bad');
if (!$link) {
echo mysql_errno() . ": " . mysql_error(). "\n";
exit;
}
//$id应该是前面插入news表的时候返回的news_id。
$sql="INSERT INTO rtindex(id,title,content,groupid,biguid,score,date_added,author) VALUES ( $id, '$title', '$content', $groupid,$biguid,$score,$date_added,'$author')";
mysql_query($sql);
if(mysql_errno())
{
echo mysql_errno() . ": " . mysql_error(). "\n";
echo $sql;
exit;
}
在做实时索引查询的时候，php代码如下
//连接到实时索引，使用MySQL41协议
$link = mysql_connect('127.0.0.1:9306') or die('connect bad');
if (!$link) {
echo mysql_errno() . ": " . mysql_error(). "\n";
exit;
}
$query=mysql_query("SELECT * FROM rtindex WHERE MATCH('你好吗？？')");
if(mysql_errno())
{
echo mysql_errno() . ": " . mysql_error(). "\n";
exit;
}
while($row=mysql_fetch_array($query,MYSQL_ASSOC))
{
print_r($row);
}
die;
当然，上面的php代码都没经过优化，只是很粗糙地完成了这个过程，实际的代码可能会封装成类/方法等等。
关于实时索引的建立及应用，到此结束。
如果大家有不同的建议，欢迎留言，大家一起交流！
原文地址：【原创】sphinx实时索引的配置及实际应用、实例, 感谢原作者分享。
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
How to Undo Delete from Home Screen in iPhone
Apr 17, 2024 pm 07:37 PM
Deleted something important from your home screen and trying to get it back? You can put app icons back on the screen in a variety of ways. We have discussed all the methods you can follow and put the app icon back on the home screen. How to Undo Remove from Home Screen in iPhone As we mentioned before, there are several ways to restore this change on iPhone. Method 1 – Replace App Icon in App Library You can place an app icon on your home screen directly from the App Library. Step 1 – Swipe sideways to find all apps in the app library. Step 2 – Find the app icon you deleted earlier. Step 3 – Simply drag the app icon from the main library to the correct location on the home screen. This is the application diagram
Understand Linux Bashrc: functions, configuration and usage
Mar 20, 2024 pm 03:30 PM
Understanding Linux Bashrc: Function, Configuration and Usage In Linux systems, Bashrc (BourneAgainShellruncommands) is a very important configuration file, which contains various commands and settings that are automatically run when the system starts. The Bashrc file is usually located in the user's home directory and is a hidden file. Its function is to customize the Bashshell environment for the user. 1. Bashrc function setting environment
The role and practical application of arrow symbols in PHP
Mar 22, 2024 am 11:30 AM
The role and practical application of arrow symbols in PHP In PHP, the arrow symbol (->) is usually used to access the properties and methods of objects. Objects are one of the basic concepts of object-oriented programming (OOP) in PHP. In actual development, arrow symbols play an important role in operating objects. This article will introduce the role and practical application of arrow symbols, and provide specific code examples to help readers better understand. 1. The role of the arrow symbol to access the properties of an object. The arrow symbol can be used to access the properties of an object. When we instantiate a pair
From beginner to proficient: Explore various application scenarios of Linux tee command
Mar 20, 2024 am 10:00 AM
The Linuxtee command is a very useful command line tool that can write output to a file or send output to another command without affecting existing output. In this article, we will explore in depth the various application scenarios of the Linuxtee command, from entry to proficiency. 1. Basic usage First, let’s take a look at the basic usage of the tee command. The syntax of tee command is as follows: tee[OPTION]...[FILE]...This command will read data from standard input and save the data to
How to configure and install FTPS in Linux system
Mar 20, 2024 pm 02:03 PM
Title: How to configure and install FTPS in Linux system, specific code examples are required. In Linux system, FTPS is a secure file transfer protocol. Compared with FTP, FTPS encrypts the transmitted data through TLS/SSL protocol, which improves Security of data transmission. In this article, we will introduce how to configure and install FTPS in a Linux system and provide specific code examples. Step 1: Install vsftpd Open the terminal and enter the following command to install vsftpd: sudo
Explore the advantages and application scenarios of Go language
Mar 27, 2024 pm 03:48 PM
The Go language is an open source programming language developed by Google and first released in 2007. It is designed to be a simple, easy-to-learn, efficient, and highly concurrency language, and is favored by more and more developers. This article will explore the advantages of Go language, introduce some application scenarios suitable for Go language, and give specific code examples. Advantages: Strong concurrency: Go language has built-in support for lightweight threads-goroutine, which can easily implement concurrent programming. Goroutin can be started by using the go keyword
The wide application of Linux in the field of cloud computing
Mar 20, 2024 pm 04:51 PM
The wide application of Linux in the field of cloud computing With the continuous development and popularization of cloud computing technology, Linux, as an open source operating system, plays an important role in the field of cloud computing. Due to its stability, security and flexibility, Linux systems are widely used in various cloud computing platforms and services, providing a solid foundation for the development of cloud computing technology. This article will introduce the wide range of applications of Linux in the field of cloud computing and give specific code examples. 1. Application virtualization technology of Linux in cloud computing platform Virtualization technology
Understanding MySQL timestamps: functions, features and application scenarios
Mar 15, 2024 pm 04:36 PM
MySQL timestamp is a very important data type, which can store date, time or date plus time. In the actual development process, rational use of timestamps can improve the efficiency of database operations and facilitate time-related queries and calculations. This article will discuss the functions, features, and application scenarios of MySQL timestamps, and explain them with specific code examples. 1. Functions and characteristics of MySQL timestamps There are two types of timestamps in MySQL, one is TIMESTAMP
