You're right Serge, there should be a global option to allow you to set
AUTOCOMMIT to 0. InnoDB is used for transactional paradigm, so it's obvious
you watn to do yourself the "commit", this should be the default behavior
for transactional tables.
If you get the answer to this problem please put it on the list.
Calin
----- Original Message -----
From: "Serge Paquin" <[EMAIL PROTECTED]>
To: "Oliver Vecernik" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, June 12, 2002 6:46 PM
Subject: Re: Autocommit
> Hello Oliver,
>
> Thanks for the suggestion but that was not what I am looking for. I
> know about the command SET AUTOCOMMIT=0 but that is a session level
> solution.
>
> I want transactions to be on always on the database for every session.
> i.e. the default to 0 rather than the default of 1 as it is now. I have
> looked high and low but I can only find reference to the default setting
of
> mysql autocommit being 1 and no reference on how to change that default.
>
> Thanks,
> Serge.
>
> ----- Original Message -----
> From: "Oliver Vecernik" <[EMAIL PROTECTED]>
> To: "Serge Paquin" <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> Sent: Wednesday, June 12, 2002 1:59 AM
> Subject: Re: Autocommit
>
>
> > Serge Paquin wrote:
> > > Hello,
> > >
> > > I am setting up mysqld-max with InnoDB Tables. How can I set
autocommit
> to off? I want this a global option for the DBMS.
> >
> > Did you read the docs? There is even an example (chapter 7.5.8.6).
> >
> > Oliver
> >
>
>
> ---------------------------------------------------------------------
> 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
>
---------------------------------------------------------------------
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
