Re: InnoDB AUTO-INC lock timeouts / deadlocks on inserts (using

2002-10-01 Thread iod iod
(IOD) - - Original Message - From: "Heikki Tuuri" <[EMAIL PROTECTED]> Date: Tue, 1 Oct 2002 15:00:37 +0300 To: "\"iod iod\"" <[EMAIL PROTECTED]> Subject: Re: InnoDB AUTO-INC lock timeouts / deadlocks on inserts (using > IOD, > > thank you for t

Re: InnoDB AUTO-INC lock timeouts / deadlocks on inserts (using

2002-10-01 Thread iod iod
. regards, IOD Subject: Re: InnoDB AUTO-INC lock timeouts / deadlocks on inserts (using > Iod, > > - Original Message - > From: ""iod iod"" <[EMAIL PROTECTED]> > Newsgroups: mailing.database.mysql > Sent: Thursday, September 26,

InnoDB AUTO-INC lock timeouts / deadlocks on inserts (using AUTO_INCREMENT column)

2002-09-25 Thread iod iod
We have been using InnoDB with MySQL (MySQL-Max-3.23.52-1) for transaction support in some complex situations in our application when maintaining consistency is critical. Recently we did some stress testing by simulating 10 concurrent users (perl/DBD) doing large number of inserts on a few tab