Bug #37568 autocommit wronly documented to work in option files and command line
Submitted: 22 Jun 2008 13:49 Modified: 22 Jun 2008 23:28
Reporter: Geert Vanderkelen Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:5.0,5.1,6.0 bzr OS:Any
Assigned to: Paul DuBois CPU Architecture:Any
Tags: autocommit

[22 Jun 2008 13:49] Geert Vanderkelen 
Description:
The autocommit system variable is wrongly documented to work in option files and the command line on:
 http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html

Also in the 5.0 manual..

How to repeat:
[mysqld]
autocommit = 0

080622 15:26:23 [ERROR] /usr/local/mysql-5.1.24-rc-osx10.5-x86/bin/mysqld: unknown variable 'autocommit=0'

air:mysql geert$ sudo ./bin/mysqld --help --verbose | grep auto
  --auto-increment-increment[=#] 
  --auto-increment-offset[=#] 
                      auto-increment-increment != 1
 ...

Suggested fix:
Document that it can't be changed in option files and on the command line.
[22 Jun 2008 13:59] Sveta Smirnova 
Thank you for the report.

Verified as described.
[22 Jun 2008 23:28] Paul DuBois 
Thank you for your bug report. This issue has been addressed in the documentation. The updated documentation will appear on our website shortly, and will be included in the next release of the relevant products.