Re: InnoDB transactions with Connection Pooling

2002-04-21 Thread Heikki Tuuri
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

Re: InnoDB transactions with Connection Pooling

2002-04-21 Thread Jeremy Zawodny
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, <

Re: InnoDB transactions with Connection Pooling

2002-04-21 Thread Heikki Tuuri
t; <[EMAIL 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