RE: Start up MySQL in Transaction Mode

[Mehalick, Richard RE SSI-GRAX]

It is my understanding that if AUTOCOMMIT=1 then as long as you don't start
a transaction with BEGIN, all SQL statements act as if BDB was not being
used.  Of course you can't ROLLBACK a transaction either.

Rick

-----------------------------------------
/ Rick Mehalick       Senior Consultant        
/ Shell Services International SSI-GPAX
/ Phone:  281-544-5092(WCK) 
/ Fax:    281-544-2646(WCK)
/ email:  [EMAIL PROTECTED] 
-----------------------------------------



-----Original Message-----
From: Xin Li [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 29, 2001 2:37 PM
To: [EMAIL PROTECTED]
Subject: Start up MySQL in Transaction Mode


Hi,

MySQL supports transaction since 3.23, but we have to create BDB table
to benefit transaction. My question is,

Can we start up MySQL in transaction mode for a while rather than all of
time?

Because we're concerned about performance about BDB, do you guys
experiment any positive or negative feedback on that?

Thank you in advance.

--lix


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php