Coreseek 在 Windows 安装问题和使用步骤

Question

1、配置文件

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                = 123456
    sql_db                    =test
    sql_port                = 3307
    sql_query_pre            = SET NAMES utf8
    sql_query_pre = REPLACE INTO sph_counter SELECT 1,MAX(id) FROM documents 
    sql_query                = SELECT id, title,create_time, content FROM documents \
       WHERE id<=( SELECT max_doc_id FROM sph_counter WHERE counter_id=1 ) 
         
    sql_attr_timestamp        = create_time 
    #从SQL读取到的值必须为整数，作为时间属性

}

source delta:mysql {
#这里是新增的增量索引源  
        sql_query_pre = SET NAMES utf8  
        sql_query = SELECT id, title,create_time, content FROM documents \
               WHERE id>( SELECT max_doc_id FROM sph_counter WHERE counter_id=1 ) 
        #sql_query_post_index    = replace into sph_counter select 1,max(id) from picture_info  
}  

#index定义
index mysql
{
    source            = mysql             #对应的source名称
    path            = D:/SOFT_PHP_PACKAGE/search/yzdd/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 = D:/SOFT_PHP_PACKAGE/search/yzdd/coreseek/etc/                             #Windows环境下设置，/符号结尾，最好给出绝对路径，例如：C:/usr/local/coreseek/etc/...
    charset_type        = zh_cn.utf-8
}

index delta:mysql {
#这是新增的增量索引  
        source          = delta  
        path            = D:/SOFT_PHP_PACKAGE/search/yzdd/coreseek/var/data/delta  
}   

#全局index定义
indexer{
    mem_limit            = 128M
}

#searchd服务定义
searchd{
    listen                  =   9312
    read_timeout        = 5
    max_children        = 30
    max_matches            = 1000
    seamless_rotate        = 0
    preopen_indexes        = 0
    compat_sphinxql_magics = 0
    unlink_old            = 1
    pid_file = D:/SOFT_PHP_PACKAGE/search/yzdd/coreseek/var/log/searchd_mysql.pid  
    #请修改为实际使用的绝对路径，例如：/usr/local/coreseek/var/...
    log = D:/SOFT_PHP_PACKAGE/search/yzdd/coreseek/var/log/searchd_mysql.log       
     #请修改为实际使用的绝对路径，例如：/usr/local/coreseek/var/...
    query_log = D:/SOFT_PHP_PACKAGE/search/yzdd/coreseek/var/log/query_mysql.log 
    #请修改为实际使用的绝对路径，例如：/usr/local/coreseek/var/...
    binlog_path =D:/SOFT_PHP_PACKAGE/search/yzdd/coreseek/var/log/                               
    #关闭binlog日志
}

2.创建索引

indexer.exe --all
indexer.exe delta

安装服务后

indexer.exe --all --rotate
indexer.exe delta --rotate

3.安装服务

searchd.exe --install --config D:/SOFT_PHP_PACKAGE/search/yzdd/coreseek/bin/csft.conf

注册表路径

D:/SOFT_PHP_PACKAGE/search/yzdd/coreseek/bin/searchd.exe --ntservice --config D:/SOFT_PHP_PACKAGE/search/yzdd/coreseek/bin/csft.conf

4.计划任务

mysql.bat 主索引文件

cd D:/SOFT_PHP_PACKAGE/search/yzdd/coreseek/bin
indexer.exe --all --rotate

delta.bat 增量索引文件

cd D:/SOFT_PHP_PACKAGE/search/yzdd/coreseek/bin
indexer.exe delta --rotate

Windows 2008 服务器

开始->管理工具->任务计划程序->任务计划程序库->（右键点击）创建任务

5.查看日志文件

searchd_mysql.log

的确是每隔五分钟执行一次增量索引