Sagewire Logo

No AUTOCOMMIT by default?

3 Message(s) by 3 Author(s) originally posted in mysql discussion


From: Cloink Date:   Saturday, October 20, 2007
Hi,

I'd like to make a MySQL user session always be in transactional-mode,
i.e. have autocommit OFF always.

I have not found a way of doing this - is it possible, or do I just
always have to type
SET AUTOCOMMIT=0;
every time I logon?

There does not appear to be an option in the config file to set this;
neither does there appear to be any way of running a standard script
at logon.

I'm on Windows - I thought I might be able to pass in a login-file on
the command line (using a shortcut) as though running in batch mode,
but then it just runs the script and exits straight away!

No more ideas.

Help appreciated,
Cheers,
Clark.


From: ZeldorBlat Date:   Saturday, October 20, 2007
wrote in message:
Hi,
I'd like to make a MySQL user session always be in transactional-mode,
i.e. have autocommit OFF always.
I have not found a way of doing this - is it possible, or do I just
always have to type
SET AUTOCOMMIT=0;
every time I logon?
There does not appear to be an option in the config file to set this;
neither does there appear to be any way of running a standard script
at logon.
I'm on Windows - I thought I might be able to pass in a login-file on
the command line (using a shortcut) as though running in batch mode,
but then it just runs the script and exits straight away!
No more ideas.
Help appreciated,
Cheers,
Clark.



According to the manual (which you probably have access to as well)
you can set the default behavior by adding this to your my.cnf or
my.ini:

[mysqld]
init_connect='set autocommit=0'


From: Paul Lautman Date:   Saturday, October 20, 2007
wrote in message:
According to the manual (which you probably have access to as well)



Manual, surely you know that our purpose is to look all this stuff up for
the lazy posters!



Next Message: Detect not exitistant


Blogs related to No AUTOCOMMIT by default?

hyperion and mysql server on remote host - possible?
129 98 Query UPDATE configdb_sequence SET id=id+1 130 98 Query SELECT id FROM configdb_sequence 131 98 Query commit 132 98 Query SET autocommit=1 133 98 Query INSERT INTO db_pool VALUES (4,'jdbc:mysql://lo­calhost/?useUnicode=­ ...

Hey I have a fairly large and complicated MySQL database running a ...
how can I do if I have to perform more than one update and I want to perform all of them or no one? I remember something about autocommit but I don't know exactly… can somebody give me a clue, please? ...

autocommit was set to 0 for a database and the database is 13 GB ...
i have installed the mysql hosting odbc driver ( never worked with it before ). No trying to export a table from access directly through a odbc connection. But he asks me to choose a ODBC connection in a directory. What does that mean ? ...

hi all i have mysql 5027 running on a hosted FC5 web server for ...
sorry for the english im from pt. it probably runs in autocommit=0, arash. no transactions of its own. Use the mysql command line client or some similar tool -or- talk to the authors of the application you're trying to install. ...

Nontransactional data access Many more issues must be
Our recommendation is to not use the autocommit mode in an application, and to apply read-only transactions only when there is an obvious performance benefit or when future code changes are highly unlikely. Always prefer regular ACID ...

Creating a Job queue in Innodb
Parent, let the child have the old connection and reconnect to # the db. $dbh->{InactiveDestroy} = 1; $dbh = DBI->connect( 'DBI:mysql:database=test;host=127.0.0.1;port=3306', 'test', 'test', { RaiseError => 1, AutoCommit => 0 } ...


Programming | Sports | Autos

copyright 2006
Valid XHTML 1.0 Transitional