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.
