On Mon, Apr 22, 2002 at 09:02:54AM +0300, Heikki Tuuri wrote:
Mark,
if you do not explicitly do
SET AUTOCOMMIT=0
then MySQL automatically calls COMMIT after every SQL statement.
Make that:
SET AUTOCOMMIT=1
Heikki is probably low on coffee. :-)
Jeremy
--
Jeremy D. Zawodny, [EMAIL
Jeremy,
- Original Message -
From: Jeremy Zawodny [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, April 22, 2002 9:37 AM
Subject: Re: InnoDB transactions with Connection Pooling
On Mon, Apr 22, 2002 at 09:02:54AM +0300, Heikki Tuuri wrote
PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Monday, April 22, 2002 3:35 AM
Subject: InnoDB transactions with Connection Pooling
Fellow MySQL gurus,
I am using Apache::DBI to accomplish connection pooling. I am working
with
an InnoDB table that gets updated very frequently. My question