List:Commits« Previous MessageNext Message »
From:paul.dubois Date:January 10 2011 4:17pm
Subject: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...
View as plain text  
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.dubois10 Jan