Temp table:
CREATE TABLE ' sph_counter ' ( ' counter_id ' int (one) not null, ' max_doc_id ' int (one) not NULL, PRIMARY KEY (' Coun ter_id ') Engine=myisam DEFAULT Charset=utf8
Source src{# Data source type. Mandatory, nodefaultValue # Known types is MySQL, Pgsql, MSSQL, Xmlpipe, Xmlpipe2, ODBC type=MySQL sql_host=localhost sql_user=Root Sql_pass=201671zhuang sql_db=Test Sql_port=3306# Optional,default is 3306Sql_query_pre=SET NAMES UTF8 sql_query_pre= SET SESSION query_cache_type=OFF Sql_query_pre= REPLACE into Sph_counter SELECT1, MAX (ID) from CN sql_query= SELECT Id,title,content fromcnwhereid<= (SELECT max_doc_id from Sph_counter WHERE counter_id=1) Sql_query_info= SELECT * from CN WHERE id=$id} #表示增量数据源source moresrc:src{sql_query_pre=SET NAMES UTF8 sql_query_pre= SET SESSION query_cache_type=OFF sql_query= SELECT Id,title,content fromcnwhereId> (SELECT max_doc_id from Sph_counter WHERE counter_id=1) #sql_ranged_throttle= -}index src{Source=src Path=/usr/local/coreseek/var/data/test1 DocInfo=externMlock=0morphology=None # Enable Chinese word breaker in source data source need to set read data encoding character set to UTF-8, otherwise it will not be processed correctly, and if it is XML, the correct output is UTF-8 encoding format, if it is MySQL, set read data output character set to UTF-8 can be charset_type= zh_cn.utf-8# chinese Word thesaurus location Charset_dictpath=/usr/local/mmseg/etc/}index moresrc:src{Source=moresrc Path=/usr/local/coreseek/var/data/moresrc morphology=stem_en}indexer{# memory limit,inchbytes, kiloytes (16384K) or megabytes (256M) # Optional,default is32M, Max is2047M, recommended is256M to 1024M #现在还是不知道是什么意思 mem_limit=32M}
[Email protected]:/usr/local/coreseek/bin#/usr/local/coreseek/bin/indexer-c/usr/local/coreseek/etc/ Csft.increment.conf--all--Rotatecoreseek Fulltext4.1[Sphinx2.0.2-Dev (r2922)] Copyright (c) -- ., Beijing Choice Software Technologies Inc (http://www.coreseek.com)using configfile '/usr/local/coreseek/etc/csft.increment.conf'... indexing Index'src'... Warning:attribute Count is0: Switching to none docinfocollected6Docs0.0mbsorted0.0mHITs,100.0% Done Total6Docs293Bytestotal0.011Sec25970Bytes/sec,531.82docs/secindexing Index'moresrc'... Warning:attribute Count is0: Switching to none docinfocollected0Docs0.0Mbtotal0Docs0Bytestotal0.001Sec0Bytes/sec,0.00docs/Sectotal3Reads0.000Sec0.1Kb/call AVG,0.0msec/Call avgtotal OneWrites,0.000Sec0.1Kb/call AVG,0.0msec/Call avgrotating indices:succesfully sent SIGHUP to Searchd (PID=13100).
[Email protected]:/usr/local/coreseek/bin#/usr/local/coreseek/bin/indexer moresrc-c/usr/local/coreseek/etc/ Csft.increment.conf--Rotatecoreseek Fulltext4.1[Sphinx2.0.2-Dev (r2922)] Copyright (c) -- ., Beijing Choice Software Technologies Inc (http://www.coreseek.com)using configfile '/usr/local/coreseek/etc/csft.increment.conf'... indexing Index'moresrc'... Warning:attribute Count is0: Switching to none docinfocollected1Docs0.0mbsorted0.0mHITs,100.0% Done Total1Docs -Bytestotal0.008Sec3457Bytes/sec,115.24docs/Sectotal2Reads0.000Sec0.0Kb/call AVG,0.0msec/Call avgtotal6Writes,0.000Sec0.0Kb/call AVG,0.0msec/Call avgrotating indices:succesfully sent SIGHUP to Searchd (PID=13100).
[Email protected]:/usr/local/coreseek/bin#/usr/local/coreseek/bin/indexer--merge src moresrc-c/usr/local/coreseek /etc/csft.increment.conf--Rotatecoreseek Fulltext4.1[Sphinx2.0.2-Dev (r2922)] Copyright (c) -- ., Beijing Choice Software Technologies Inc (http://www.coreseek.com)using configfile '/usr/local/coreseek/etc/csft.increment.conf'.. read0.0Of0.0MB,100.0% Donemerged0.0kwordsmergedinch 0.000Sectotal +Reads0.000Sec6.4Kb/call AVG,0.0msec/Call avgtotal5Writes,0.000Sec0.1Kb/call AVG,0.0msec/Call avgrotating indices:succesfully sent SIGHUP to Searchd (PID=13100).
[Email protected]:/usr/local/coreseek/bin#./search-c/usr/local/coreseek/etc/csft.increment.conf Test Coreseek Fulltext4.1[Sphinx2.0.2-Dev (r2922)] Copyright (c) -- ., Beijing Choice Software Technologies Inc (http://www.coreseek.com)using configfile '/usr/local/coreseek/etc/csft.increment.conf'. .. index'src': Query'Test': Returned3Matches of3Totalinch 0.000secdisplaying matches:1. Document=2, weight=2637 ID=2title=?????content=?? ?????? ???? ??Addtime=02. Document=7, weight=2627 ID=7title=??content=????????Addtime=03. Document=1, weight=1571 ID=1title=???content=???????? ?????? ????Addtime=1444444444words:1.'Test':3Documents -Hitsindex'moresrc': Query'Test': Returned1Matches of1Totalinch 0.000secdisplaying matches:1. Document=7, weight=2500 ID=7title=??content=????????Addtime=0words:1.'Test':1Documents5Hits
Sphinx Incremental Index Test