[rabbitmq-discuss] RabbitMQ + MySQL

[Ask Solem]

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