Hi,

I am experiencing deadlocks using InnoDB row level locking. I would
like to prevent these deadlocks by accessing the rows in the
affected table in a fixed order, as suggested in the MySQL manual
http://dev.mysql.com/doc/refman/5.1/...deadlocks.html.

Unfortunately, I could not find how to ensure that rows are accessed
in a specific order. Any help on how to achieve this is greatly
appreciated.

Thanks in advance,

Stephan