Re: InnoDB: Lock wait timeout problem. Please help.

2002-06-28 Thread Mikhail Entaltsev
AIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, June 28, 2002 11:20 AM Subject: Re: InnoDB: Lock wait timeout problem. Please help. > Heikki, > > Thank you very much for response. > But I still don't understand why do I have lock in Conn1. > Let's go through stat

Re: InnoDB: Lock wait timeout problem. Please help.

2002-06-28 Thread Mikhail Entaltsev
I appreciate it very much. Mikhail. - Original Message ----- From: "Heikki Tuuri" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, June 28, 2002 10:42 AM Subject: Re: InnoDB: Lock wait timeout problem. Please help. > Mikhail, > > I think MySQL i

Re: InnoDB: Lock wait timeout problem. Please help.

2002-06-28 Thread Heikki Tuuri
PROTECTED]> Newsgroups: mailing.database.mysql Sent: Friday, June 28, 2002 1:29 AM Subject: InnoDB: Lock wait timeout problem. Please help. > Hi all, > > I am using MySQL (version 3.23.51-max-log). I have a problem with locking. > Let's assume that we have 2 c

InnoDB: Lock wait timeout problem. Please help.

2002-06-27 Thread Mikhail Entaltsev
Hi all, I am using MySQL (version 3.23.51-max-log). I have a problem with locking. Let's assume that we have 2 connections (Conn1 and Conn2) and table test: CREATE TABLE `test` ( `id` int(3) NOT NULL auto_increment, `name` char(10)