MySQL Bugs: #1007: AUTOCOMMIT as global variable

Bug #1007	AUTOCOMMIT as global variable
Submitted:	6 Aug 2003 22:36	Modified:	8 Dec 2003 4:55
Reporter:	[ name withheld ]	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server	Severity:	S4 (Feature request)
Version:	4.1 alpha	OS:	Any (any)
Assigned to:	Sergei Glukhov	CPU Architecture:	Any

Description:
As You know we now set autocommit on session level. When we use MySQL in transactional environment will be good to make permanently autocommit set off autocommit on server startup in my.cnf (my.ini) configuration file. But we can set autocommit  unfortunatly only on session level.

When will be this feature updateted to make autocommit on global level?

How to repeat:
You cannot put autocommit in server configuration file.

An option --init-connect is presently being added to MySQl 4.1 (it should be in 4.1.1): with this you will be able to put

init-connect="SET AUTOCOMMIT=0"

in your my.cnf file.
The commands in 'init_connect' are executed for every created connection (it's a way to add a "preamble" to all connections). This option can be set on the fly (SET GLOBAL init_connect=...).

Gluh: this bug report is assigned to you. When you have finished adding the init-connect option, could you please add a SET AUTOCOMMIT=0 to init_connect-master.opt, and see if this works (just do a SELECT @@AUTOCOMMIT in the init_connect.test), then close this bug report? Thank you!