Re: Transaction problems using InnoDB, "not locked with LOCKTABLES"

2003-02-13 Thread Steff
AIL PROTECTED] Subject: Re: Transaction problems using InnoDB, "not locked with LOCKTABLES" > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > [EMAIL PROTECTED] wrote: > > Heikki, > > The application which is having this problem is used to

Re: Transaction problems using InnoDB, "not locked with LOCKTABLES"

2003-02-13 Thread Mark Matthews
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 [EMAIL PROTECTED] wrote: Heikki, The application which is having this problem is used to read an XML document and update a database. The application is part of a website, so there are always other interactions with the database while the "loa

Re: Transaction problems using InnoDB, "not locked with LOCKTABLES"

2003-02-13 Thread Steff
<[EMAIL PROTECTED]> Copies to: <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]> Subject: Re: Transaction problems using InnoDB, "not locked with LOCKTABLES" Date sent: Thu, 13 Feb 2003 21:59:22

Re: Transaction problems using InnoDB, "not locked with LOCKTABLES"

2003-02-13 Thread Heikki Tuuri
7; AND SecondaryID = 'CKCBSBF2994311' 7 Query COMMIT 7 Query SET autocommit=1 - Original Message - From: <[EMAIL PROTECTED]> To: "Heikki Tuuri" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]>; <[EMAIL

Re: Transaction problems using InnoDB, "not locked with LOCKTABLES"

2003-02-13 Thread Steff
g client connections in the right way, not mixing them? > > Can you create a repeatable test case? > > > > Thanks in advance for your guidance. > > > > Steff > > Regards, > > Heikki > > sql query > > > > > On 13 Feb 2003 at 1

Re: Transaction problems using InnoDB, "not locked with LOCKTABLES"

2003-02-13 Thread Heikki Tuuri
Steff, - Original Message - From: <[EMAIL PROTECTED]> To: "Heikki Tuuri" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, February 13, 2003 7:21 PM Subject: Re: Transaction problems using InnoDB, "not locked with LOCKTABLES" > Heik

Re: Transaction problems using InnoDB, "not locked with LOCKTABLES"

2003-02-13 Thread Steff
: "Heikki Tuuri" <[EMAIL PROTECTED]> To: "Mark Matthews" <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]> Copies to: <[EMAIL PROTECTED]> Subject: Re: Transaction problems using InnoDB, "not lo

Re: Transaction problems using InnoDB, "not locked with LOCKTABLES"

2003-02-13 Thread Heikki Tuuri
Mark, Steff, - Original Message - From: "Mark Matthews" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, February 12, 2003 3:09 AM Subject: Re: Transaction problems using InnoDB, "not loc

Re: Transaction problems using InnoDB, "not locked with LOCKTABLES"

2003-02-11 Thread Steff
hews wrote: Date sent: Tue, 11 Feb 2003 19:09:16 -0600 From: Mark Matthews <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Copies to: [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: Transaction problems using InnoDB, &

Re: Transaction problems using InnoDB, "not locked with LOCKTABLES"

2003-02-11 Thread Mark Matthews
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 [EMAIL PROTECTED] wrote: Hello, We are experiencing severe problems when running MySql with INNODB in a production environment. Applications which work fine under light load fail when under production load. Our MySql environment is as follows

Transaction problems using InnoDB, "not locked with LOCKTABLES"

2003-02-11 Thread Steff
Hello, We are experiencing severe problems when running MySql with INNODB in a production environment. Applications which work fine under light load fail when under production load. Our MySql environment is as follows: OS Platform: Windows 2000 Service Pack 2 Machine description: C