Hi!
Is it so that your test inserts, updates, and deletes
rows at random? Can these rows overlap? Do you have big
transactions?
If the above are true, you will inevitably get a lot
of deadlocks and rollbacks. Real-world applications
should be written in a way that deadlocks cannot occur,
or they
Hello Denis,
Tuesday, July 10, 2001, 12:51:40 PM, you wrote:
If I'm not mistaken the problem is - conflicting transactions which
you have here. I'm really not shure INNODB dead lock detection is
quite fine graned. Also it's shurely may roll back more long running
transaction. But anyway you