I've not done anything like that, but it would not surprise me if Sphinx locks the index files while indexing... also, if you're adding a *lot* of records, you're still going to need to run a full re-index regularly, else your delta index will get slower and slower to process.
So, maybe the cron job isn't the right approach, or at least, you need to run it less often. -- Pat On 11/03/2010, at 8:13 PM, Mimmo wrote: > Thank you Pat, i used the second one method but i have another > question for you.. When an indexer is calling manually, inside a cron > job for example, and there is still the application that manage the > indexing of delta automatically, is it possible that one indexer lock > the other? > In details: > i have a cronjob like this: > */1 * * * * /opt/sphinx/bin/indexer --config /var/www/virtual/ > myapplication/config/production.sphinx.conf --rotate search_delta > quotation_delta request_delta /var/www/virtual/myapplication/log/ > production.delta_index.log 2>&1 > The records of the model Request are pushed into the database from > another application with delta=1. > The same records are modified by the application. > Now, every minute start my cron job indexer, and every record > modification application side start indexer managed from application. > Take into account that every minute are written a lot of records by > external application and every minute are updated a lot of records by > my application. > The result?I have all the records modified by application not in the > delta-index. > What's appened? > i hope you understand my problem. > > On Mar 11, 12:53 am, Pat Allan <[email protected]> wrote: >> Just to elaborate a little: Sphinx doesn't have the ability to edit fields >> for records (at least, not yet - it looks like the next version will support >> it in some shape, but not yet sure if that'll fit with how TS uses it). So >> yes, the only way to get changed/new data in is to reindex. >> >> The deltas approach means that all changes get stored in separate indexes >> (between full re-indexing - because you'll still need to do that regularly), >> and these small indexes are fast and easy to process, and so the overhead of >> doing that after each change is bearable (at least, in some situations). >> >> Cheers >> >> -- >> Pat >> >> On 09/03/2010, at 5:57 AM, Greg DeVore wrote: >> >>> New records will only show up if you have enabled delta indexing: >> >>> http://freelancing-god.github.com/ts/en/deltas.html >> >>> Greg >> >>> On Mar 8, 1:53 am, Pat Allan <[email protected]> wrote: >>>> (Sorry, I screwed up - accidentally flagged this email as spam - >>>> obviously, I'm in need of some sleep at the moment. Reposting on behalf of >>>> Alec, and have removed the auto-account ban. Sorry!) >> >>>> It seems as though I need to reindex every time I add a new field for >>>> my table for sphinx to pick it up. Otherwise, new records added to the >>>> database don't seem to be coming up in queries. Is this supposed to be >>>> happening or should new records automatically be picked up by sphinx? >> >>> -- >>> You received this message because you are subscribed to the Google Groups >>> "Thinking Sphinx" group. >>> To post to this group, send email to [email protected]. >>> To unsubscribe from this group, send email to >>> [email protected]. >>> For more options, visit this group >>> athttp://groups.google.com/group/thinking-sphinx?hl=en. > > -- > You received this message because you are subscribed to the Google Groups > "Thinking Sphinx" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/thinking-sphinx?hl=en. > -- You received this message because you are subscribed to the Google Groups "Thinking Sphinx" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/thinking-sphinx?hl=en.
