How to cope with deadlocks?

[eluser]Otemu[/eluser]
Hi,

"Use SHOW ENGINE INNODB STATUS to determine the cause of the latest deadlock" Have you tried this? Maybe you can see the cause and modify your queries.

"Always be prepared to re-issue a transaction if it fails due to deadlock" - A loop would help here as Rana said above, maybe set a delay for each loop to give a chance that maybe another lock will become free and the query may now execute.

"try using a lower isolation level such as READ COMMITTED" - Have you tried this and seen the effect run SET TRANSACTION ISOLATION LEVEL READ COMMITTED;

if nothing else helps, serialize your transactions with table-level locks. - have you tried this?