How to erase a realtime index in Sphinx?

Question

I want to use a realtime index as an instantly available delta for today's changes, so it needs to be erased nightly. Is there a nice way to remove all documents from an RT-index? I suppose I could select everything from it and issue a DELETE for every found id, but that does not seem to be a wise way.

score 14 · Accepted Answer · edited Feb 10 '14 at 15:59

14

TRUNCATE RTINDEX rt_user was added in sphinx 2.2.2

edited Feb 10 '14 at 15:59

Pentium10

204,586
122
423
502

answered Nov 28 '11 at 08:31

tmg_tt

474
2
6

score 0 · Answer 2 · answered Mar 26 '14 at 05:42

I've tried TRUNCATE RTINDEX ... without any luck. The easiest method I found was to change the path configuration of the index. eg:

index myindex { type = rt path = /var/lib/sphinxsearch/data/myindex ... to

index myindex { type = rt path = /var/lib/sphinxsearch/data/myindex-v2 ...

score 0 · Answer 3 · answered Nov 24 '11 at 06:28

0

It seems this is not yet possible. http://sphinxsearch.com/forum/view.html?id=6898 deals with this question and the only solution the forum mentions is shutting down Sphinx, clearing out binlog and the relevant files of the index and restart.

answered Nov 24 '11 at 06:28

chx

11,270
7
55
129

How to erase a realtime index in Sphinx?

3 Answers3