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 level)
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
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
mysqlSET
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
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