首先建立一個(gè)計(jì)數(shù)表，保存數(shù)據(jù)表的最新記錄ID

CREATE TABLE `sph_counter` (
  `id` int(11) unsigned NOT NULL,
  `max_id` int(11) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='sphinx增量表最大記錄數(shù)';

#定義主索引源

source test
{
    type                    = mysql
    sql_host                = localhost
    sql_user                = root
    sql_pass                = 8888
    sql_db                    = test
    sql_port                = 3306
    sql_query_pre            = SET NAMES utf8
    sql_query_pre           = replace INTO sph_counter select 1, MAX(id) from test where status=1 #取最大記錄數(shù)

    sql_query = select id from test where id<(select max_id from sph_counter where id=1) and  status = 1

　##如果這里不加id<的條件，合并索引時(shí)會(huì)報(bào)字段數(shù)不匹配的錯(cuò)誤

　#FATAL: failed to merge index 'test_delta' into index 'test': fulltext fields count mismatch (me=/usr/local/sphinx/var/data/test, in=/usr/local/sphinx/var/data/test_delta, myfields=4, infields=5)
    sql_query_info = select * from test where id = $id
}

#增量索引數(shù)據(jù)源定義
source test_delta : test
{
        sql_query_pre = SET NAMES utf8
        sql_query = select * from test  where id>=(select max_id from sph_counter where id=1) and status = 1
        sql_query_info = select * from test where id = $id

}

#定義主索引

index test
{
    source            = test            #對(duì)應(yīng)的source名稱
    path            = /usr/local/sphinx/var/data/test #請(qǐng)修改為實(shí)際使用的絕對(duì)路徑，例如：/usr/local/coreseek/var/...
    docinfo            = extern
    mlock            = 0
    morphology        = none
    min_word_len        = 2
    html_strip                = 1

    #中文分詞配置，詳情請(qǐng)查看：http://www.tjdsmy.cn/products-install/coreseek_mmseg/
    charset_dictpath = /usr/local/mmseg/etc/ #BSD、Linux環(huán)境下設(shè)置，/符號(hào)結(jié)尾
    #charset_dictpath = etc/                             #Windows環(huán)境下設(shè)置，/符號(hào)結(jié)尾，最好給出絕對(duì)路徑，例如：C:/usr/local/coreseek/etc/...
    charset_type        = zh_cn.utf-8
}
#定義增量索引
index test_delta:test
{
    source            = test_delta            #對(duì)應(yīng)的source名稱
    path            = /usr/local/sphinx/var/data/test_delta #請(qǐng)修改為實(shí)際使用的絕對(duì)路徑，例如：/usr/local/coreseek/var/...
    docinfo            = extern
    mlock            = 0
    morphology        = none
    min_word_len        = 2
    html_strip                = 1

    #中文分詞配置，詳情請(qǐng)查看：http://www.tjdsmy.cn/products-install/coreseek_mmseg/
    charset_dictpath = /usr/local/mmseg/etc/ #BSD、Linux環(huán)境下設(shè)置，/符號(hào)結(jié)尾
    #charset_dictpath = etc/                             #Windows環(huán)境下設(shè)置，/符號(hào)結(jié)尾，最好給出絕對(duì)路徑，例如：C:/usr/local/coreseek/etc/...
    charset_type        = zh_cn.utf-8
}

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

#searchd服務(wù)定義
searchd
{
    listen                  =   9312
    read_timeout        = 5
    max_children        = 30
    max_matches            = 1000
    seamless_rotate        = 0
    preopen_indexes        = 0
    unlink_old            = 1
    pid_file = /usr/local/sphinx/var/log/searchd_mysql.pid  #請(qǐng)修改為實(shí)際使用的絕對(duì)路徑，例如：/usr/local/coreseek/var/...
    log = /usr/local/sphinx/var/log/searchd_mysql.log        #請(qǐng)修改為實(shí)際使用的絕對(duì)路徑，例如：/usr/local/coreseek/var/...
    query_log = /usr/local/sphinx/var/log/query_mysql.log #請(qǐng)修改為實(shí)際使用的絕對(duì)路徑，例如：/usr/local/coreseek/var/...
    binlog_path =                                #關(guān)閉binlog日志
}

保存配置文件后退出，先停止searchd進(jìn)程再啟動(dòng)，然后重新生成索引。

停止進(jìn)程
/usr/local/sphinx/bin/searchd -c /usr/local/sphinx/etc/csft.conf --stop

啟動(dòng)進(jìn)程
/usr/local/sphinx/bin/searchd -c /usr/local/sphinx/etc/csft.conf

重新生成所有索引
/usr/local/sphinx/bin/indexer -c /usr/local/sphinx/etc/csft.conf --all --rotate
增量索引
/usr/local/sphinx/bin/indexer -c /usr/local/sphinx/etc/csft.conf test_delta --rotate
合并索引
/usr/local/sphinx/bin/indexer -c /usr/local/sphinx/etc/csft.conf --merge test test_delta --rotate

如果合并索引時(shí)出現(xiàn)下面問題：

FATAL: failed to merge index 'test_delta' into index 'test': source index preload failed: failed to open /usr/local/sphinx/var/data/test_delta.sph: No such file or directory

停止searchd進(jìn)程，然后重新啟動(dòng)searchd進(jìn)?。

增量索引可以放在crontab里根據(jù)需要設(shè)置幾分鐘運(yùn)行一次，然后執(zhí)行索引合并，至于主索引重建可以選擇在訪問量不大或者半夜運(yùn)行。

##每5分鐘運(yùn)行增量索引

*/5 * * * /usr/local/sphinx/bin/indexer -c /usr/local/sphinx/etc/csft.conf test_delta --rotate > /dev/null 2>&1

##每10分鐘執(zhí)行一次增量索引合并

*/10 * * * /usr/local/sphinx/bin/indexer -c /usr/local/sphinx/etc/csft.conf --merge test test_delta --rotate

##凌晨0點(diǎn)5分重新建立主索引

5 0 * * * /usr/local/sphinx/bin/indexer -c /usr/local/sphinx/etc/csft.conf --all --rotate > /dev/null 2>&1