From: Martijn Tonies
Date: October 24 2003 2:40pm
Subject: Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1
List-Archive: http://lists.mysql.com/mysql/152354
Message-Id: <02f501c39a3c$cb15baa0$0a02a8c0@seal>
MIME-Version: 1.0
Content-Type: text/plain;	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Hi Chris,

> I'm not the almighty Heikki, but I might be able to fill you in to some
> extent.

:-)

> Your first and third questions I cannot answer with certainty, but I'm
> pretty
> sure the answer is "no". Regarding the first one, I'm not too sure as to
> why you'd need
> it. Looking at the output of SHOW VARIABLES might help though.

Yeah, I have been looking at SHOW VARIABLES - but it isn't
exactly what I'm looking for.

> As for the second question, AUTOCOMMIT is able to be set at any time
> without a problem. Additionally, issuing BEGIN or it's workalikes (see the
> MySQL manual or the reference manual at www.innodb.com) will act
> in the same way as having AUTOCOMMIT set to 0.

Ugh - read across that one... Woops :-) Thanks for that.


With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird & MS SQL Server.
Upscene Productions
http://www.upscene.com