Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

It's covered in sphinx documents:

But after reading it,I don't think it really can achieve that.

Have you guys ever also thought of this problem?

share|improve this question

I think that the terms live update indexing and almost real-time are terribly misleading. Perhaps incrementally updating index is appropriate for what sphinx is really doing there.

Having said that, for my applications of interest, the biggest limitation of the delta+main solution presented is that only new data is indexed with the deltas -- previously indexed data which has been updated in the db is not flagged for re-indexing.

share|improve this answer

This post is quite old now, however, I've come across the similar problem recently.

I use delta and main indices in my application. I use cron to schedule indices' rotations. The delta index is being updated every few minutes and the main index once a day. This updates both indices.

For example:

*/5 * * * * /path/to/indexer delta --rotate --quiet

00 7 * * * /path/to/indexer main --rotate --quiet
share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.