How to reindex Sphinx with MySQL

Question

I am trying to figure out how I should reindex the Sphinx. I use v 0.9.9, so I have no way to do index updates in real time.

I think I read somewhere that this can be done using the cron job, and that the index does not need to be completely rebuilt (so don't stop the daemon). However, I never wrote or ran any cron work orders, so I don’t know where to start.

Any thoughts?

Answer 1

I think that after this you are the main + delta index. The main index you create speaks once a day, and then every 5 minutes (or any other period that you need) you update it with changes from the moment it was last created. There is something in the docs that explains this, and there are also posts on Google about it.

http://sphinxsearch.com/docs/current.html#delta-updates

In terms of cronjob, to restore your delta every 5 minutes, you need something like:

*/5 * * * * /opt/sphinx/bin/indexer -c /opt/sphinx/etc/sphinx.conf --rotate delta_idx