Sphinx实时索引

来源：互联网发布：c语言类编辑：程序博客网时间：2024/05/22 05:26

1，首先创建一个表用来储存主索引和增量索引的id值

CREATE TABLE IF NOT EXISTS `sph_counter` (  `s_id` int(10) unsigned NOT NULL auto_increment,  `p_id` int(11) NOT NULL,   PRIMARY KEY  (`s_id`)      ) ;

2，改sphinx配置文件

#主数据源source main{type= mysqlsql_host= localhostsql_user= rootsql_pass= rootsql_db= testsql_port= 3306# optional, default is 3306sql_sock= /tmp/mysql.socksql_query_pre= SET NAMES utf8sql_query_pre= SET SESSION query_cache_type=OFF    sql_query_pre                  = replace into sph_coner select 1,max(id) from postsql_query = select id,title,content from post where id<= (select p_id from sph_coner where s_id=1)sql_ranged_throttle= 0sql_query_info= SELECT * FROM post WHERE id=$id}增量数据源source delta : main{sql_query_pre = SET NAMES utf8sql_query = select id,title,content from post where id >= (select p_id from sph_coner where s_id=1)}#主数据索引index main{source= main path= /usr/local/sphinx/var/data/maindocinfo= externmlock= 0morphology= nonemin_word_len= 1charset_type = zh_cn.utf-8charset_dictpath = /usr/local/mmseg/etc/html_strip= 0}#增量数据索引index delta : main{source = deltapath= /usr/local/sphinx/var/data/delta}#索引器indexer{mem_limit=256M}#客户端检索进程searchd{log= /usr/local/sphinx/var/log/searchd.logquery_log= /usr/local/sphinx/var/log/query.logread_timeout= 5client_timeout= 300max_children= 30pid_file= /usr/local/sphinx/var/log/searchd.pidmax_matches= 1000seamless_rotate= 1preopen_indexes= 0unlink_old= 1mva_updates_pool= 1Mmax_packet_size= 8Mmax_filters= 256max_filter_values= 4096}# --eof--

3，测试sphinx时时索引

INSERT INTO `post` (`title`, `content`) VALUES('my title', 'my content'),

<span style="white-space: pre;"> 执行 </span>/usr/local/coreseek/bin/indexer delta –rotate

./search  my title

0 0