Hi
Yes, you can set the variabe per-connection.
mysql > set SESSION autocommit=0;
Check with two connections. For Transaction safe engines(such as InnoDB, BDB,
or NDB Cluster),to disable autocommit mode for a single series of statements,
use the START TRANSACTION or BEGIN statement. With STAR
Thanks!
I played a bit init_connect. I'm not sure though how can I verify the
autocommit value. You say 'by select'. Something like this?
select @@AUTOCOMMIT;
Because that still gives me a value of '1'.
More important to me: Can this variable be set per-connection? If so,
how? Specifically, how
There is no global system variable to set Autocommit; but we can achieve the
same with 'init_connect=SET AUTOCOMMIT=0'.
This variable can be set from the mysql or in the commandline or in the
option file.
Like,
mysql > SET GLOBAL init_connect='SET AUTOCOMMIT=0';
or
mysql>SET @@GLOBAL.init_connect=
This is a call for participation in the second MySQL Miniconf which will
be part of the linux.conf.au (LCA) 2007 conference in Sydney, Australia.
The Miniconf will be run on Monday, January 15th, before the conference
proper starts.
This is the first conference of its type to be held in the South
In the last episode (Nov 22), Alfred Mak said:
> Can I shutdown one of the databases in MySQL but not the whole mysqld
> process (i.e. keeping the other databases still running) ?
"shutdown" would be the wrong word then :) How about revoking
permissions (either at the mysql or the filesystem leve
