Home > Article > Backend Development > The incremental index added by coreseek cannot take effect. What's going on?
In Windows 7 64-bit environment, version 3.2.14 win32 is used.
Problem: After starting the searchd service, the indexes added are invalid. They can only take effect after restarting the searchd service.
Main index: mysql
Increment index: new
Operation process:
1. Create the main index:
<code>indexer -c csft.conf mysql </code>
2. Start the service:
<code>serachd </code>
3. Search through php:
can find 8 results
4. Newly added data on related keywords in the database
5. Add incremental index
indexer -c csft.conf new --rotate
6. Search through php
The results are still 8
7. Or try merged index:
<code>indexer -c csft.conf mysql new -merge-dst-range deleted 0 0 --rotate </code>
8. Search through php
The result is still 8 items
9. Re-establish the main index:
<code>indexer -c csft.conf mysql --rotate </code>
10. Search through php
The result is still 8 items
11. Close the original searchd service, and then start the searchd service, the query result will have the data just inserted
(The strange thing is that if you do not close the original searchd service, start searchd directly in the window where the index is built Service, the search results will change, but there are only two or three, I don’t know why? )
Profile:
<code>#MySQL数据源配置,详情请查看:http://www.coreseek.cn/products-install/mysql/ #请先将var/test/documents.sql导入数据库,并配置好以下的MySQL用户密码数据库 #源定义 source mysql { type = mysql sql_host = localhost sql_user = root sql_pass = root sql_db = mall sql_port = 3306 sql_query_pre = SET NAMES utf8 #插入文章表的最大id sql_query_pre = REPLACE INTO acticle_new SELECT 1, MAX(id) FROM acticle sql_query = SELECT id, title,content FROM acticle #sql_query第一列id需为整数 #title、content作为字符串/文本字段,被全文索引 #sql_attr_uint = group_id #从SQL读取到的值必须为整数 #sql_attr_timestamp = date_added #从SQL读取到的值必须为整数,作为时间属性 sql_query_info_pre = SET NAMES utf8 #命令行查询时,设置正确的字符集 sql_query_info = SELECT * FROM acticle WHERE id=$id #命令行查询时,从数据库读取原始数据信息 } #增量数据源 source new:mysql { sql_query_pre = SET NAMES utf8 sql_query=select id,title,content from acticle where id>(select newid from acticle_new where id=1); sql_query_post = REPLACE INTO acticle_new SELECT 1, MAX(id) FROM acticle sql_query_post_index = REPLACE INTO acticle_new SELECT 1, MAX(id) FROM acticle } #index 主索引定义 index mysql { source = mysql #对应的source名称 path = E:/coreseek/var/data/mysql #请修改为实际使用的绝对路径,例如:/usr/local/coreseek/var/... docinfo = extern mlock = 0 morphology = none min_word_len = 1 //最小索引词长度,设置后无效,原因不明 html_strip = 0 #中文分词配置,详情请查看:http://www.coreseek.cn/products-install/coreseek_mmseg/ #charset_dictpath = /usr/local/mmseg3/etc/ #BSD、Linux环境下设置,/符号结尾 charset_dictpath = E:/coreseek/etc/ #Windows环境下设置,/符号结尾,最好给出绝对路径,例如:C:/usr/local/coreseek/etc/... charset_type = zh_cn.utf-8 } #增量索引 index new:mysql { type=rt source = new #对应的source名称 path = E:/coreseek/var/data/new #请修改为实际使用的绝对路径,例如:/usr/local/coreseek/var/... docinfo = extern mlock = 0 morphology = none min_word_len = 1 //最小索引词长度 html_strip = 0 #中文分词配置,详情请查看:http://www.coreseek.cn/products-install/coreseek_mmseg/ #charset_dictpath = /usr/local/mmseg3/etc/ #BSD、Linux环境下设置,/符号结尾 charset_dictpath = E:/coreseek/etc/ #Windows环境下设置,/符号结尾,最好给出绝对路径,例如:C:/usr/local/coreseek/etc/... charset_type = zh_cn.utf-8 } #全局index定义 indexer { mem_limit = 128M } #searchd服务定义 searchd { listen = 9312 read_timeout = 5 max_children = 30 max_matches = 1000 seamless_rotate = 0 preopen_indexes = 0 unlink_old = 1 pid_file = E:/coreseek/var/log/searchd_mysql.pid #请修改为实际使用的绝对路径,例如:/usr/local/coreseek/var/... log = E:/coreseek/var/log/searchd_mysql.log #请修改为实际使用的绝对路径,例如:/usr/local/coreseek/var/... query_log = E:/coreseek/var/log/query_mysql.log #请修改为实际使用的绝对路径,例如:/usr/local/coreseek/var/... }</code>
In Windows 7 64-bit environment, version 3.2.14 win32 is used.
Problem: After starting the searchd service, the indexes added are invalid. They can only take effect after restarting the searchd service.
Main index: mysql
Increment index: new
Operation process:
1. Create the main index:
<code>indexer -c csft.conf mysql </code>
2. Start the service:
<code>serachd </code>
3. Search through php:
can find 8 results
4. Newly added data on related keywords in the database
5. Add incremental index
indexer -c csft.conf new --rotate
6. Search through php
The results are still 8
7. Or try merged index:
<code>indexer -c csft.conf mysql new -merge-dst-range deleted 0 0 --rotate </code>
8. Search through php
The result is still 8 items
9. Re-establish the main index:
<code>indexer -c csft.conf mysql --rotate </code>
10. Search through php
The result is still 8 items
11. Close the original searchd service, and then start the searchd service, the query result will have the data just inserted
(The strange thing is that if you do not close the original searchd service, start searchd directly in the window where the index is built) Service, the search results will change, but there are only two or three, I don’t know why?)
Profile:
<code>#MySQL数据源配置,详情请查看:http://www.coreseek.cn/products-install/mysql/ #请先将var/test/documents.sql导入数据库,并配置好以下的MySQL用户密码数据库 #源定义 source mysql { type = mysql sql_host = localhost sql_user = root sql_pass = root sql_db = mall sql_port = 3306 sql_query_pre = SET NAMES utf8 #插入文章表的最大id sql_query_pre = REPLACE INTO acticle_new SELECT 1, MAX(id) FROM acticle sql_query = SELECT id, title,content FROM acticle #sql_query第一列id需为整数 #title、content作为字符串/文本字段,被全文索引 #sql_attr_uint = group_id #从SQL读取到的值必须为整数 #sql_attr_timestamp = date_added #从SQL读取到的值必须为整数,作为时间属性 sql_query_info_pre = SET NAMES utf8 #命令行查询时,设置正确的字符集 sql_query_info = SELECT * FROM acticle WHERE id=$id #命令行查询时,从数据库读取原始数据信息 } #增量数据源 source new:mysql { sql_query_pre = SET NAMES utf8 sql_query=select id,title,content from acticle where id>(select newid from acticle_new where id=1); sql_query_post = REPLACE INTO acticle_new SELECT 1, MAX(id) FROM acticle sql_query_post_index = REPLACE INTO acticle_new SELECT 1, MAX(id) FROM acticle } #index 主索引定义 index mysql { source = mysql #对应的source名称 path = E:/coreseek/var/data/mysql #请修改为实际使用的绝对路径,例如:/usr/local/coreseek/var/... docinfo = extern mlock = 0 morphology = none min_word_len = 1 //最小索引词长度,设置后无效,原因不明 html_strip = 0 #中文分词配置,详情请查看:http://www.coreseek.cn/products-install/coreseek_mmseg/ #charset_dictpath = /usr/local/mmseg3/etc/ #BSD、Linux环境下设置,/符号结尾 charset_dictpath = E:/coreseek/etc/ #Windows环境下设置,/符号结尾,最好给出绝对路径,例如:C:/usr/local/coreseek/etc/... charset_type = zh_cn.utf-8 } #增量索引 index new:mysql { type=rt source = new #对应的source名称 path = E:/coreseek/var/data/new #请修改为实际使用的绝对路径,例如:/usr/local/coreseek/var/... docinfo = extern mlock = 0 morphology = none min_word_len = 1 //最小索引词长度 html_strip = 0 #中文分词配置,详情请查看:http://www.coreseek.cn/products-install/coreseek_mmseg/ #charset_dictpath = /usr/local/mmseg3/etc/ #BSD、Linux环境下设置,/符号结尾 charset_dictpath = E:/coreseek/etc/ #Windows环境下设置,/符号结尾,最好给出绝对路径,例如:C:/usr/local/coreseek/etc/... charset_type = zh_cn.utf-8 } #全局index定义 indexer { mem_limit = 128M } #searchd服务定义 searchd { listen = 9312 read_timeout = 5 max_children = 30 max_matches = 1000 seamless_rotate = 0 preopen_indexes = 0 unlink_old = 1 pid_file = E:/coreseek/var/log/searchd_mysql.pid #请修改为实际使用的绝对路径,例如:/usr/local/coreseek/var/... log = E:/coreseek/var/log/searchd_mysql.log #请修改为实际使用的绝对路径,例如:/usr/local/coreseek/var/... query_log = E:/coreseek/var/log/query_mysql.log #请修改为实际使用的绝对路径,例如:/usr/local/coreseek/var/... }</code>