[rabbitmq-discuss] RabbitMQ + MySQL

Thu Aug 13 20:38:21 BST 2009

On Aug 13, 2009, at 9:25 PM, Suhail Doshi wrote:

> Anyone using rabbitmq with lots of consumers along with MySQL and  
> hitting dead locks if you run too many consumers, any smart way to  
> deal with that?
>
> My theory was sharding on some distinct id and sending only some  
> data to specific consumers based on an id...
>
> Ideas? Suggestions?
>

If you're using InnoDB you can try to set transaction isolation
level to READ COMMITTED, as described here:

http://celeryproject.org/faq.html#mysql-is-throwing-deadlock-errors-what-can-i-do

-- 
Ask Solem
Developer, Web Team, Opera Software
askh at opera.com