svn commit - mysqldoc@oter02: r25820 - trunk/dynamic-docs/changelog

[jon.stephens]

Author: js221926
Date: 2011-04-11 09:59:55 +0200 (Mon, 11 Apr 2011)
New Revision: 25820

Log:

Added changelog entry for Cluster SPJ (oops)

Fixed bad XML tag



Modified:
   trunk/dynamic-docs/changelog/mysqld-2.xml


Modified: trunk/dynamic-docs/changelog/mysqld-2.xml
===================================================================
--- trunk/dynamic-docs/changelog/mysqld-2.xml	2011-04-11 04:53:38 UTC (rev 25819)
+++ trunk/dynamic-docs/changelog/mysqld-2.xml	2011-04-11 07:59:55 UTC (rev 25820)
Changed blocks: 2, Lines Added: 56, Lines Deleted: 1; 2815 bytes

@@ -10,6 +10,61 @@
 
     <tags>
       <highlight type="cluster"/>
+      <highlight type="performance"/>
+      <manual type="joins"/>
+      <manual type="ndb_join_pushdown"/>
+    </tags>
+
+    <bugs>
+      <fixes wlid="3258"/>
+    </bugs>
+
+    <versions>
+      <version ver="5.1.51-ndb-7.2.0"/>
+    </versions>
+
+    <message>
+
+      <para>
+        Added support for pushing down joins to the NDB kernel for
+        parallel execution across the data nodes, which can speed up
+        execution of joins across <literal role="se">NDB</literal>
+        tables by a factor of 20 or more in some cases. Some
+        restrictions apply on the types of joins that can be optimized
+        in this way; in particular, columns to be joined must use
+        exactly the same data type, and cannot be any of the
+        <literal role="type">BLOB</literal> or
+        <literal role="type">TEXT</literal> types. In addition, columns
+        to be joined must be part of a table index or primary key.
+        Support for this feature can be enabled or diabled using the
+        <literal role="sysvar">ndb_join_pushdown</literal> server system
+        variable (enabled by default); see the description of this
+        variable for more information and examples.
+      </para>
+
+      <para>
+        As part of this improvement, the status variables
+        <literal role="statvar">Ndb_pushed_queries_defined</literal>,
+        <literal role="statvar">Ndb_pushed_queries_dropped</literal>,
+        <literal role="statvar">Ndb_pushed_queries_executed</literal>,
+        and <literal role="statvar">Ndb_pushed_reads</literal> also been
+        introduced for monitoring purposes. You can also see whether a
+        given join is pushed down using
+        <literal role="stmt">EXPLAIN</literal>. In addition, several new
+        counters relating to push-down join performance have been added
+        to the <literal>ndbinfo.counters</literal> table. For more
+        information, see the descriptions of these status variables, as
+        well as <xref linkend="mysql-cluster-ndbinfo-counters"/>.
+      </para>
+
+    </message>
+
+  </logentry>
+
+  <logentry entrytype="feature">
+
+    <tags>
+      <highlight type="cluster"/>
       <highlight type="importantchange"/>
       <manual type="privileges"/>
       <manual type="grant tables"/>

@@ -17144,7 +17199,7 @@
       <fixes bugid="51021"/>
       <seealsobug bugid="49132"/>
       <seealsobug bugid="39934"/>
-      <seealslbug bugid="11749859"/>
+      <seealsobug bugid="11749859"/>
     </bugs>
 
     <versions>