List:Commits« Previous MessageNext Message »
From:jon.stephens Date:March 28 2011 3:11pm
Subject:svn commit - mysqldoc@oter02: r25587 - in trunk: dynamic-docs/changelog dynamic-docs/command-optvars refman-5.1
View as plain text  
Author: js221926
Date: 2011-03-28 17:11:20 +0200 (Mon, 28 Mar 2011)
New Revision: 25587

Log:

Cluster BUG#11769048

  Changelog entry
  Documented new MaxParallelScansPerFragment config param

Fixed typo in option name



Modified:
   trunk/dynamic-docs/changelog/mysqld-2.xml
   trunk/dynamic-docs/command-optvars/ndb-config-params.xml
   trunk/refman-5.1/mysql-cluster-configuration-core.xml


Modified: trunk/dynamic-docs/changelog/mysqld-2.xml
===================================================================
--- trunk/dynamic-docs/changelog/mysqld-2.xml	2011-03-28 14:04:03 UTC (rev 25586)
+++ trunk/dynamic-docs/changelog/mysqld-2.xml	2011-03-28 15:11:20 UTC (rev 25587)
Changed blocks: 2, Lines Added: 32, Lines Deleted: 1; 1562 bytes

@@ -9,6 +9,37 @@
   <logentry entrytype="feature">
 
     <tags>
+      <highlight type="cluster"/>
+      <manual type="ALTER TABLE"/>
+    </tags>
+
+    <bugs>
+      <fixes bugid="11769048"/>
+    </bugs>
+
+    <versions>
+      <version ver="5.1.51-ndb-7.0.23"/>
+      <version ver="5.1.51-ndb-7.1.12"/>
+    </versions>
+
+    <message>
+
+      <para>
+        Improved scaling of ordered index scans performance by removing
+        a hard-coded limit MAX_PARALLEL_INDEX_SCANS_PER_FRAG and making
+        the number of <literal>TUP</literal> or <literal>TUX</literal>
+        scans per fragment configurable by adding the
+        <literal role="ndbparam:ndbd">MaxParallelScansPerFragment</literal>
+        data node configuration parameter.
+      </para>
+
+    </message>
+
+  </logentry>
+
+  <logentry entrytype="feature">
+
+    <tags>
       <highlight type="partitioning"/>
       <manual type="partition selection"/>
       <manual type="SELECT"/>

@@ -106,7 +137,7 @@
 
       <para>
         A GCI value inserted by <command>ndb_restore</command>
-        <option role="ndb_restore">--restore-epoch</option> into the
+        <option role="ndb_restore">--restore_epoch</option> into the
         <literal>ndb_apply_status</literal> table was actually 1 less
         than the correct value.
       </para>


Modified: trunk/dynamic-docs/command-optvars/ndb-config-params.xml
===================================================================
--- trunk/dynamic-docs/command-optvars/ndb-config-params.xml	2011-03-28 14:04:03 UTC (rev 25586)
+++ trunk/dynamic-docs/command-optvars/ndb-config-params.xml	2011-03-28 15:11:20 UTC (rev 25587)
Changed blocks: 1, Lines Added: 29, Lines Deleted: 0; 1382 bytes

@@ -2792,6 +2792,35 @@
 
   </mysqloption>
 
+  <mysqloption id="maxparallelscansperfragment-ndbd" section="cluster" subsection="ndbd">
+
+    <xrefto id="ndbparam-ndbd-maxparallelscansperfragment"/>
+
+    <name>MaxParallelScansPerFragment</name>
+
+    <shortdescription>
+      Maximum number of parallel scans per fragment. Once this limit is
+      reached, scans are serialized.
+    </shortdescription>
+
+    <values vartype="numeric" platform="all" units="bytes" inversion="5.1.51-ndb-7.0.23">
+      <value default="32" minimum="1" maximum="1G"/>
+    </values>
+
+    <values vartype="numeric" platform="all" units="bytes" inversion="5.1.51-ndb-7.1.12">
+      <value default="32" minimum="1" maximum="1G"/>
+    </values>
+
+    <versions>
+      <manual version="5.1"/>
+      <introduced version="5.1.51-ndb-7.0.23"/>
+      <introduced version="5.1.51-ndb-7.1.21"/>
+    </versions>
+
+    <restart type="node" initial="no"/>
+
+  </mysqloption>
+
   <mysqloption id="maxscanbatchsize-api" section="cluster" subsection="api">
 
     <xrefto id="ndbparam-api-maxscanbatchsize"/>


Modified: trunk/refman-5.1/mysql-cluster-configuration-core.xml
===================================================================
--- trunk/refman-5.1/mysql-cluster-configuration-core.xml	2011-03-28 14:04:03 UTC (rev 25586)
+++ trunk/refman-5.1/mysql-cluster-configuration-core.xml	2011-03-28 15:11:20 UTC (rev 25587)
Changed blocks: 1, Lines Added: 27, Lines Deleted: 0; 1535 bytes

@@ -3346,6 +3346,33 @@
           </para>
         </listitem>
 
+        <listitem>
+          <para id="ndbparam-ndbd-maxparallelscansperfragment">
+            <indexterm>
+              <primary>MaxParallelScansPerFragment</primary>
+            </indexterm>
+
+            <literal role="ndbparam:ndbd">MaxParallelScansPerFragment</literal>
+          </para>
+
+          <para condition="dynamic:optvar:item" role="5.1:ndb-config-params:maxparallelscansperfragment-ndbd"/>
+
+          <para>
+            Beginning with MySQL Cluster NDB 7.0.23 and MySQL Cluster
+            NDB 7.1.12, it is possible to copnfigure the maximum number
+            of parallel scans (<literal>TUP</literal> scans and
+            <literal>TUX</literal> scans) allowed before they begin
+            queuing for serial handling. You can increase this to take
+            advantage of any unused CPU when performing large number of
+            scans in parallel and improve their performance.
+          </para>
+
+          <para>
+            Previously, the maximum number of parallel scans per
+            fragment was fixed at 32.
+          </para>
+        </listitem>
+
       </itemizedlist>
 
       <bridgehead id="mysql-cluster-memory-allocation">


Thread
svn commit - mysqldoc@oter02: r25587 - in trunk: dynamic-docs/changelog dynamic-docs/command-optvars refman-5.1jon.stephens28 Mar