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.1 | jon.stephens | 28 Mar |
