Re: InnoDB behaviour with multiple clients

2001-07-16 Thread Heikki Tuuri
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

Re: InnoDB behaviour with multiple clients

2001-07-10 Thread Peter Zaitsev
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