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 2
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, <
Mark,
if you do not explicitly do
SET AUTOCOMMIT=0
then MySQL automatically calls COMMIT after every SQL statement.
If you set AUTOCOMMIT=0, then you should yourself call COMMIT after each
SELECT so that you do not leave a dangling transaction open in the database
and that you get a fresh snap
