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>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r9747 - in trunk: dynamic-docs/command-optvars refman-5.0 refman-5.1 refman-6.0 | jon | 8 Feb |
