Author: paul
Date: 2011-01-10 17:17:05 +0100 (Mon, 10 Jan 2011)
New Revision: 24751
Log:
r43850@dhcp-213: paul | 2011-01-10 10:15:00 -0500
Document bug fixes:
- Bug#57316: It is not clear how to disable autocommit
Bug#57316 enables autocommit to be set globally at server startup
Modified:
trunk/dynamic-docs/changelog/mysqld-2.xml
trunk/dynamic-docs/command-optvars/mysqld.xml
trunk/refman-5.0/dba-mysqld-server-core.xml
trunk/refman-5.1/dba-mysqld-server-core.xml
trunk/refman-5.5/dba-mysqld-server-core.xml
trunk/refman-5.6/dba-mysqld-server-core.xml
trunk/refman-6.0/dba-mysqld-server-core.xml
Property changes on: trunk
___________________________________________________________________
Name: svk:merge
- 07c7e7b4-24e3-4b51-89d0-6dc09fec6bec:/mysqldoc-local/mysqldoc/trunk:35498
07c7e7b4-24e3-4b51-89d0-6dc09fec6bec:/mysqldoc-local/trunk:46087
4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:43968
4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/trunk:44480
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:66486
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:39036
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/trunk:39546
ebeeeee4-b232-4669-a521-231442eced53:/mysqldoc-local/mysqldoc/trunk:43849
+ 07c7e7b4-24e3-4b51-89d0-6dc09fec6bec:/mysqldoc-local/mysqldoc/trunk:35498
07c7e7b4-24e3-4b51-89d0-6dc09fec6bec:/mysqldoc-local/trunk:46087
4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:43968
4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/trunk:44480
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:66486
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:39036
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/trunk:39546
ebeeeee4-b232-4669-a521-231442eced53:/mysqldoc-local/mysqldoc/trunk:43850
Modified: trunk/dynamic-docs/changelog/mysqld-2.xml
===================================================================
--- trunk/dynamic-docs/changelog/mysqld-2.xml 2011-01-10 16:16:32 UTC (rev 24750)
+++ trunk/dynamic-docs/changelog/mysqld-2.xml 2011-01-10 16:17:05 UTC (rev 24751)
Changed blocks: 1, Lines Added: 44, Lines Deleted: 0; 1810 bytes
@@ -37129,4 +37129,48 @@
</logentry>
+ <logentry entrytype="feature">
+
+ <tags>
+ <manual type="autocommit"/>
+ </tags>
+
+ <bugs>
+ <fixes bugid="57316"/>
+ </bugs>
+
+ <versions>
+ <version ver="5.5.8"/>
+ </versions>
+
+ <message>
+
+ <para>
+ The <literal role="sysvar">autocommit</literal> system variable
+ is enabled by default for all user connections, and the session
+ value can be set for each new connection by setting the
+ <literal role="sysvar">init_connect</literal> system variable to
+ <literal>SET autoconnect=0</literal>. However, this has no
+ effect for users who have the
+ <literal role="priv">SUPER</literal> privilege.
+ </para>
+
+ <para>
+ Now the global <literal role="sysvar">autocommit</literal> value
+ can be set at server startup, and this value is used to
+ initialize the session value for all new connections, including
+ those for users with the <literal>SUPER</literal> privilege. The
+ variable is treated as a boolean value so it can be enabled with
+ <option role="sysvar">--autocommit</option>,
+ <option role="sysvar">--autocommit=1</option>, or
+ <option role="sysvar">--enable-autocommit</option>. It can be
+ disabled with <option role="sysvar">--autocommit=0</option>,
+ <option role="sysvar">--skip-autocommit</option>, or
+ <option role="sysvar">--disable-autocommit</option>.
+ </para>
+
+ </message>
+
+ </logentry>
+
</changelog>
Modified: trunk/dynamic-docs/command-optvars/mysqld.xml
===================================================================
--- trunk/dynamic-docs/command-optvars/mysqld.xml 2011-01-10 16:16:32 UTC (rev 24750)
+++ trunk/dynamic-docs/command-optvars/mysqld.xml 2011-01-10 16:17:05 UTC (rev 24751)
Changed blocks: 1, Lines Added: 2, Lines Deleted: 0; 741 bytes
@@ -8151,6 +8151,8 @@
</shortdescription>
<types>
+ <optype class="cmdline" format="--autocommit[=#]" setvar="autocommit" inversion="5.5.8"/>
+ <optype class="mycnf" />
<vartype isdynamic="yes" class="system" scope="session" outversion="5.5.2"/>
<vartype isdynamic="yes" class="system" scope="both" inversion="5.5.3"/>
<vartype isdynamic="yes" class="system" scope="session" inversion="6.0.0" outversion="6.0.13"/>
Modified: trunk/refman-5.0/dba-mysqld-server-core.xml
===================================================================
--- trunk/refman-5.0/dba-mysqld-server-core.xml 2011-01-10 16:16:32 UTC (rev 24750)
+++ trunk/refman-5.0/dba-mysqld-server-core.xml 2011-01-10 16:17:05 UTC (rev 24751)
Changed blocks: 1, Lines Added: 23, Lines Deleted: 3; 1431 bytes
@@ -3199,10 +3199,30 @@
By default, client connections begin with
<literal role="sysvar">autocommit</literal> set to 1. To cause
clients to begin with a default of 0, set the server's
- <literal role="sysvar">init_connect</literal> system variable.
- See the description of that variable for instructions that
- show how to do this.
+ <literal role="sysvar">init_connect</literal> system variable:
</para>
+
+<programlisting>
+SET GLOBAL init_connect='SET autocommit=0';
+</programlisting>
+
+ <para>
+ The <literal role="sysvar">init_connect</literal> variable can
+ also be set on the command line or in an option file. To set
+ the variable as just shown using an option file, include these
+ lines:
+ </para>
+
+<programlisting>
+[mysqld]
+init_connect='SET autocommit=0'
+</programlisting>
+
+ <para>
+ The content of <literal role="sysvar">init_connect</literal>
+ is not executed for users that have the
+ <literal role="priv">SUPER</literal> privilege.
+ </para>
</listitem>
<listitem>
Modified: trunk/refman-5.1/dba-mysqld-server-core.xml
===================================================================
--- trunk/refman-5.1/dba-mysqld-server-core.xml 2011-01-10 16:16:32 UTC (rev 24750)
+++ trunk/refman-5.1/dba-mysqld-server-core.xml 2011-01-10 16:17:05 UTC (rev 24751)
Changed blocks: 1, Lines Added: 23, Lines Deleted: 3; 1431 bytes
@@ -3828,10 +3828,30 @@
By default, client connections begin with
<literal role="sysvar">autocommit</literal> set to 1. To cause
clients to begin with a default of 0, set the server's
- <literal role="sysvar">init_connect</literal> system variable.
- See the description of that variable for instructions that
- show how to do this.
+ <literal role="sysvar">init_connect</literal> system variable:
</para>
+
+<programlisting>
+SET GLOBAL init_connect='SET autocommit=0';
+</programlisting>
+
+ <para>
+ The <literal role="sysvar">init_connect</literal> variable can
+ also be set on the command line or in an option file. To set
+ the variable as just shown using an option file, include these
+ lines:
+ </para>
+
+<programlisting>
+[mysqld]
+init_connect='SET autocommit=0'
+</programlisting>
+
+ <para>
+ The content of <literal role="sysvar">init_connect</literal>
+ is not executed for users that have the
+ <literal role="priv">SUPER</literal> privilege.
+ </para>
</listitem>
<listitem>
Modified: trunk/refman-5.5/dba-mysqld-server-core.xml
===================================================================
--- trunk/refman-5.5/dba-mysqld-server-core.xml 2011-01-10 16:16:32 UTC (rev 24750)
+++ trunk/refman-5.5/dba-mysqld-server-core.xml 2011-01-10 16:17:05 UTC (rev 24751)
Changed blocks: 2, Lines Added: 47, Lines Deleted: 9; 3122 bytes
@@ -3857,11 +3857,48 @@
<para>
By default, client connections begin with
<literal role="sysvar">autocommit</literal> set to 1. To cause
- clients to begin with a default of 0, set the server's
- <literal role="sysvar">init_connect</literal> system variable.
- See the description of that variable for instructions that
- show how to do this.
+ clients to begin with a default of 0, set the global
+ <literal role="sysvar">autocommit</literal> value by starting
+ the server with the
+ <option role="sysvar">--autocommit=0</option> option. To set
+ the variable using an option file, include these lines:
</para>
+
+<programlisting>
+[mysqld]
+autocommit=0
+</programlisting>
+
+ <para>
+ Before MySQL 5.5.8, the global
+ <literal role="sysvar">autocommit</literal> value cannot be
+ set at startup. As a workaround, set the
+ <literal role="sysvar">init_connect</literal> system variable:
+ </para>
+
+<programlisting>
+SET GLOBAL init_connect='SET autocommit=0';
+</programlisting>
+
+ <para>
+ The <literal role="sysvar">init_connect</literal> variable can
+ also be set on the command line or in an option file. To set
+ the variable as just shown using an option file, include these
+ lines:
+ </para>
+
+<programlisting>
+[mysqld]
+init_connect='SET autocommit=0'
+</programlisting>
+
+ <para>
+ The content of <literal role="sysvar">init_connect</literal>
+ is not executed for users that have the
+ <literal role="priv">SUPER</literal> privilege (unlike the
+ effect of setting the global
+ <literal role="sysvar">autocommit</literal> value at startup).
+ </para>
</listitem>
<listitem>
@@ -5853,11 +5890,12 @@
A string to be executed by the server for each client that
connects. The string consists of one or more SQL statements,
separated by semicolon characters. For example, each client
- session begins by default with autocommit mode enabled. There
- is no global <literal role="sysvar">autocommit</literal>
- system variable to specify that autocommit should be disabled
- by default, but <literal role="sysvar">init_connect</literal>
- can be used to achieve the same effect:
+ session begins by default with autocommit mode enabled. For
+ older servers (before MySQL 5.5.8), there is no global
+ <literal role="sysvar">autocommit</literal> system variable to
+ specify that autocommit should be disabled by default, but as
+ a workaround <literal role="sysvar">init_connect</literal> can
+ be used to achieve the same effect:
</para>
<programlisting>
Modified: trunk/refman-5.6/dba-mysqld-server-core.xml
===================================================================
--- trunk/refman-5.6/dba-mysqld-server-core.xml 2011-01-10 16:16:32 UTC (rev 24750)
+++ trunk/refman-5.6/dba-mysqld-server-core.xml 2011-01-10 16:17:05 UTC (rev 24751)
Changed blocks: 2, Lines Added: 16, Lines Deleted: 9; 2098 bytes
@@ -3646,11 +3646,17 @@
<para>
By default, client connections begin with
<literal role="sysvar">autocommit</literal> set to 1. To cause
- clients to begin with a default of 0, set the server's
- <literal role="sysvar">init_connect</literal> system variable.
- See the description of that variable for instructions that
- show how to do this.
+ clients to begin with a default of 0, set the global
+ <literal role="sysvar">autocommit</literal> value by starting
+ the server with the
+ <option role="sysvar">--autocommit=0</option> option. To set
+ the variable using an option file, include these lines:
</para>
+
+<programlisting>
+[mysqld]
+autocommit=0
+</programlisting>
</listitem>
<listitem>
@@ -5658,11 +5664,12 @@
A string to be executed by the server for each client that
connects. The string consists of one or more SQL statements,
separated by semicolon characters. For example, each client
- session begins by default with autocommit mode enabled. There
- is no global <literal role="sysvar">autocommit</literal>
- system variable to specify that autocommit should be disabled
- by default, but <literal role="sysvar">init_connect</literal>
- can be used to achieve the same effect:
+ session begins by default with autocommit mode enabled. For
+ older servers (before MySQL 5.5.8), there is no global
+ <literal role="sysvar">autocommit</literal> system variable to
+ specify that autocommit should be disabled by default, but as
+ a workaround <literal role="sysvar">init_connect</literal> can
+ be used to achieve the same effect:
</para>
<programlisting>
Modified: trunk/refman-6.0/dba-mysqld-server-core.xml
===================================================================
--- trunk/refman-6.0/dba-mysqld-server-core.xml 2011-01-10 16:16:32 UTC (rev 24750)
+++ trunk/refman-6.0/dba-mysqld-server-core.xml 2011-01-10 16:17:05 UTC (rev 24751)
Changed blocks: 1, Lines Added: 23, Lines Deleted: 3; 1431 bytes
@@ -3923,10 +3923,30 @@
By default, client connections begin with
<literal role="sysvar">autocommit</literal> set to 1. To cause
clients to begin with a default of 0, set the server's
- <literal role="sysvar">init_connect</literal> system variable.
- See the description of that variable for instructions that
- show how to do this.
+ <literal role="sysvar">init_connect</literal> system variable:
</para>
+
+<programlisting>
+SET GLOBAL init_connect='SET autocommit=0';
+</programlisting>
+
+ <para>
+ The <literal role="sysvar">init_connect</literal> variable can
+ also be set on the command line or in an option file. To set
+ the variable as just shown using an option file, include these
+ lines:
+ </para>
+
+<programlisting>
+[mysqld]
+init_connect='SET autocommit=0'
+</programlisting>
+
+ <para>
+ The content of <literal role="sysvar">init_connect</literal>
+ is not executed for users that have the
+ <literal role="priv">SUPER</literal> privilege.
+ </para>
</listitem>
<listitem>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r24751 - in trunk: . dynamic-docs/changelog dynamic-docs/command-optvars refman-5.0 refman-5.1 refman-5.5 refman-5.6 re... | paul.dubois | 10 Jan |
