svn commit - mysqldoc@docsrva: r9747 - in trunk: dynamic-docs/command-optvars refman-5.0 refman-5.1 refman-6.0

[jon]

Author: jstephens
Date: 2008-02-08 16:12:36 +0100 (Fri, 08 Feb 2008)
New Revision: 9747

Log:

engine_condition_pushdown is OFF by default in 5.0, ON by default in 
5.1+ (Thanks, Martin!)



Modified:
   trunk/dynamic-docs/command-optvars/mysqld.xml
   trunk/refman-5.0/optimization.xml
   trunk/refman-5.1/optimization.xml
   trunk/refman-6.0/optimization.xml


Modified: trunk/dynamic-docs/command-optvars/mysqld.xml
===================================================================
--- trunk/dynamic-docs/command-optvars/mysqld.xml	2008-02-08 15:10:20 UTC (rev 9746)
+++ trunk/dynamic-docs/command-optvars/mysqld.xml	2008-02-08 15:12:36 UTC (rev 9747)
Changed blocks: 2, Lines Added: 8, Lines Deleted: 3; 1033 bytes

@@ -6928,8 +6928,7 @@
     </shortdescription>
 
     <types>
-      <optype class="cmdline" format="--disconnect-slave-event-count=#"/>       
-      
+      <optype class="cmdline" format="--disconnect-slave-event-count=#"/>
       <optype class="mycnf"/>
     </types>
 

@@ -7058,12 +7057,18 @@
       <vartype class="system" scope="both" format="engine_condition_pushdown"
isdynamic="yes"/>
     </types>
 
-    <values vartype="boolean" platform="all">
+    <values vartype="boolean" platform="all" inversion="5.0.3">
 
       <value default="OFF"/>
 
     </values>
 
+    <values vartype="boolean" platform="all" inversion="5.1.0">
+
+      <value default="ON"/>
+
+    </values>
+
     <versions>
       <manual version="5.0"/>
       <introduced version="5.0.3"/>


Modified: trunk/refman-5.0/optimization.xml
===================================================================
--- trunk/refman-5.0/optimization.xml	2008-02-08 15:10:20 UTC (rev 9746)
+++ trunk/refman-5.0/optimization.xml	2008-02-08 15:12:36 UTC (rev 9747)
Changed blocks: 2, Lines Added: 9, Lines Deleted: 5; 1148 bytes

@@ -1699,12 +1699,15 @@
                     default. To enable it, you can start
                     <command>mysqld</command> with the
                     <option>--engine-condition-pushdown</option> option,
-                    or execute the following statement:
-                  </para>
-
-<programlisting>
-SET engine_condition_pushdown=On;
+                    or you can execute either of the following statements:
+                  
+                  <programlisting>
+SET engine_condition_pushdown=ON;
 </programlisting>
+                  
+                  <programlisting>
+SET engine_condition_pushdown=1;
+</programlisting>
 
                   <note>
                     <para>

@@ -1713,6 +1716,7 @@
                       <literal>TEXT</literal> types.
                     </para>
                   </note>
+                  </para>
                 </listitem>
 
               </itemizedlist>


Modified: trunk/refman-5.1/optimization.xml
===================================================================
--- trunk/refman-5.1/optimization.xml	2008-02-08 15:10:20 UTC (rev 9746)
+++ trunk/refman-5.1/optimization.xml	2008-02-08 15:12:36 UTC (rev 9747)
Changed blocks: 1, Lines Added: 19, Lines Deleted: 14; 1912 bytes

@@ -1842,24 +1842,29 @@
 
                 <listitem>
                   <para>
-                    Condition pushdown capability is not used by
-                    default. To enable it, you can start
-                    <command>mysqld</command> with the
-                    <option>--engine-condition-pushdown</option> option,
-                    or execute the following statement:
-                  </para>
+                    Condition pushdown capability is used by default. To
+                    disable it, you can start <command>mysqld</command>
+                    with either
+                    <option>--engine-condition-pushdown=OFF</option> or
+                    <option>--engine-condition-pushdown=0</option>, or
+                    you can execute either of the following statements:
 
 <programlisting>
-SET engine_condition_pushdown=On;
+SET engine_condition_pushdown=OFF;
 </programlisting>
 
-                  <note>
-                    <para>
-                      Condition pushdown is not supported for columns of
-                      any of the <literal>BLOB</literal> or
-                      <literal>TEXT</literal> types.
-                    </para>
-                  </note>
+<programlisting>
+SET engine_condition_pushdown=0;
+</programlisting>
+
+                    <note>
+                      <para>
+                        Condition pushdown is not supported for columns
+                        of any of the <literal>BLOB</literal> or
+                        <literal>TEXT</literal> types.
+                      </para>
+                    </note>
+                  </para>
                 </listitem>
 
               </itemizedlist>


Modified: trunk/refman-6.0/optimization.xml
===================================================================
--- trunk/refman-6.0/optimization.xml	2008-02-08 15:10:20 UTC (rev 9746)
+++ trunk/refman-6.0/optimization.xml	2008-02-08 15:12:36 UTC (rev 9747)
Changed blocks: 1, Lines Added: 19, Lines Deleted: 14; 1912 bytes

@@ -1840,24 +1840,29 @@
 
                 <listitem>
                   <para>
-                    Condition pushdown capability is not used by
-                    default. To enable it, you can start
-                    <command>mysqld</command> with the
-                    <option>--engine-condition-pushdown</option> option,
-                    or execute the following statement:
-                  </para>
+                    Condition pushdown capability is used by default. To
+                    disable it, you can start <command>mysqld</command>
+                    with either
+                    <option>--engine-condition-pushdown=OFF</option> or
+                    <option>--engine-condition-pushdown=0</option>, or
+                    you can execute either of the following statements:
 
 <programlisting>
-SET engine_condition_pushdown=On;
+SET engine_condition_pushdown=OFF;
 </programlisting>
 
-                  <note>
-                    <para>
-                      Condition pushdown is not supported for columns of
-                      any of the <literal>BLOB</literal> or
-                      <literal>TEXT</literal> types.
-                    </para>
-                  </note>
+<programlisting>
+SET engine_condition_pushdown=0;
+</programlisting>
+
+                    <note>
+                      <para>
+                        Condition pushdown is not supported for columns
+                        of any of the <literal>BLOB</literal> or
+                        <literal>TEXT</literal> types.
+                      </para>
+                    </note>
+                  </para>
                 </listitem>
 
               </itemizedlist>