Hi Eric I've no idea if Sphinx uses transactions - perhaps a question for the Sphinx forum? http://sphinxsearch.com/forum/
A replicated DB would be nice, but I'm not going to rush to patch TS for that, since it's not something that most people have. Still, if you can write the patch in an unobtrusive way, I'll definitely look at merging it in :) Cheers -- Pat On 18/07/2010, at 4:01 AM, Eric wrote: > I've been seeing some deadlocks in a production system which show > innodb status says was caused by sphinx's delta statement: > UPDATE `database_table` SET `delta` = 0 WHERE `delta` = 1 > > I'm wondering if sphinx puts the sql_query_pre (update statement) and > the sql_query in a transaction? This would explain why a statement > like this causes problems. The table has less than 9000 rows so the > update statement couldn't be slowing things down too much. The system > has relatively few users > > Might it make sense to leverage a replicated DB? I was thinking > perhaps of doing the delta update out of sync with the select > statement so that we could reduce the read locks. > > Thanks, > Eric > > -- > 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.
