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/en/innodb-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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]