List:General Discussion« Previous MessageNext Message »
From:Chris Nolan Date:October 24 2003 2:30pm
Subject:Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1
View as plain text  
Hi!

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.

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.

Hope this helps!

Regards,

Chris

Martijn Tonies wrote:

>Hi Heikki,
>
>As you know - I'm a transaction zealot :-)
>
>Is there a way to get a signal back to the client when a
>transaction has started? Or perhaps something like
>@@trancount in MSSQL?
>
>Is there a way to turn ON/OFF auto-commit?
>
>And, are metadata operations under transaction control?
>
>
>With regards,
>
>Martijn Tonies
>Database Workbench - developer tool for InterBase, Firebird & MS SQL Server.
>Upscene Productions
>http://www.upscene.com
>
>
>  
>


Thread
MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1Heikki Tuuri22 Oct
  • Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1Chris Nolan22 Oct
  • 2 Query with same criteria giving different number of rowsHector Del Curto22 Oct
    • Re: 2 Query with same criteria giving different number of rowsChris Tucker22 Oct
    • Re: 2 Query with same criteria giving different number of rowsIllyes Laszlo23 Oct
  • Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1Eduardo D Piovesam23 Oct
  • Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1Eduardo D Piovesam23 Oct
Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1Heikki Tuuri24 Oct
Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1Heikki Tuuri24 Oct
  • Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1Martijn Tonies24 Oct
    • Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1Chris Nolan24 Oct
  • Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1Eduardo D Piovesam24 Oct
    • MySQL/InnoDB-4.0.16 +Optimizer behaviourSergey S. Kostyliov29 Oct
  • Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1Heikki Tuuri24 Oct
  • Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1Eduardo D Piovesam24 Oct
  • Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1Martijn Tonies24 Oct
  • Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1Heikki Tuuri27 Oct
Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1Heikki Tuuri26 Oct
Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1Martijn Tonies26 Oct
Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1Jon Hancock27 Oct
  • Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1Chris Nolan27 Oct
    • InnoDB on Raw partitions in OSX (was Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1)Gabriel Ricard27 Oct
  • Partial replicate InnoDB -> MyISAMJon Hancock28 Oct
    • Re: Partial replicate InnoDB -> MyISAMChris Nolan28 Oct
  • Re: Partial replicate InnoDB -> MyISAMJon Hancock28 Oct
Re: InnoDB on Raw partitions in OSX (was Re: MySQL/InnoDB-4.0.16 is released + sneak peek of 4.1.1)Heikki Tuuri27 Oct