Sphinx Incremental Index Test

Source: Internet
Author: User

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.