Author: js221926
Date: 2011-03-07 14:24:40 +0100 (Mon, 07 Mar 2011)
New Revision: 25286
Log:
Documented fixes for Cluster bugs (BUG#53106, BUG#60119, no Oracle bug #s)
Changelog entries
Update --ndb-cluster-connection-pool docs
Fix SharedGlobalMemory/InitialLogFilegroup/{ALTER|CREATE} LOGFILE GROUP docs
Re-enable NDB-6.3.42/7.0.23/7.1.12 changelogs, now that we have some changelog
entries to go in them
Modified:
trunk/dynamic-docs/changelog/mysqld-2.xml
trunk/dynamic-docs/command-optvars/mysqld.xml
trunk/refman-5.1/mysql-cluster-configuration-core.xml
trunk/refman-5.1/mysql-cluster-news-core.xml
trunk/refman-5.1/sql-syntax-data-definition.xml
Modified: trunk/dynamic-docs/changelog/mysqld-2.xml
===================================================================
--- trunk/dynamic-docs/changelog/mysqld-2.xml 2011-03-07 13:01:30 UTC (rev 25285)
+++ trunk/dynamic-docs/changelog/mysqld-2.xml 2011-03-07 13:24:40 UTC (rev 25286)
Changed blocks: 1, Lines Added: 69, Lines Deleted: 0; 2125 bytes
@@ -6,6 +6,75 @@
]>
<changelog>
+ <logentry entrytype="bug">
+
+ <tags>
+ <highlight type="diskdata"/>
+ <manual type="SharedGlobalMemory"/>
+ <manual type="log file groups"/>
+ </tags>
+
+ <bugs>
+ <fixes bugid="57317"/>
+ </bugs>
+
+ <versions>
+ <version ver="5.1.51-ndb-6.3.42"/>
+ <version ver="5.1.51-ndb-7.0.23"/>
+ <version ver="5.1.51-ndb-7.1.12"/>
+ </versions>
+
+ <message>
+
+ <para>
+ Limits imposed by the size of
+ <literal role="ndbparam:ndbd">SharedGlobalMemory</literal> were
+ not always enforced consistently with regard to Disk Data undo
+ buffers and log files. This could sometimes cause a
+ <literal role="stmt">CREATE LOGFILE GROUP</literal> or
+ <literal role="stmt">ALTER LOGFILE GROUP</literal> statement to
+ fail for no apparent reason, or cause the log file group
+ specified by
+ <literal role="ndbparam:ndbd">InitialLogFileGroup</literal> not
+ to be created when starting the cluster.
+ </para>
+
+ </message>
+
+ </logentry>
+
+ <logentry entrytype="bug">
+
+ <tags>
+ <highlight type="cluster"/>
+ <highlight type="importantchange"/>
+ <manual type="--ndb-cluster-connection-pool"/>
+ <manual type="system variables"/>
+ <manual type="status variables"/>
+ </tags>
+
+ <bugs>
+ <fixes bugid="60119"/>
+ </bugs>
+
+ <versions>
+ <version ver="5.1.51-ndb-7.0.23"/>
+ <version ver="5.1.51-ndb-7.1.12"/>
+ </versions>
+
+ <message>
+
+ <para>
+ Formerly, the
+ <literal role="mysqld">--ndb-cluster-connection-pool</literal>
+ server option set a status variable as well as as a system
+ variable. The status variable has been removed as redundant.
+ </para>
+
+ </message>
+
+ </logentry>
+
<logentry entrytype="feature">
<tags>
Modified: trunk/dynamic-docs/command-optvars/mysqld.xml
===================================================================
--- trunk/dynamic-docs/command-optvars/mysqld.xml 2011-03-07 13:01:30 UTC (rev 25285)
+++ trunk/dynamic-docs/command-optvars/mysqld.xml 2011-03-07 13:24:40 UTC (rev 25286)
Changed blocks: 1, Lines Added: 4, Lines Deleted: 2; 1325 bytes
@@ -17628,8 +17628,10 @@
<types>
<optype class="cmdline" format="--ndb-cluster-connection-pool"/>
<optype class="mycnf"/>
- <vartype class="status" format="Ndb_cluster_connection_pool" isdynamic="no" scope="global" inversion="5.1.24-ndb-6.2.16"/>
- <vartype class="status" format="Ndb_cluster_connection_pool" isdynamic="no" scope="global" inversion="5.1.24-ndb-6.3.13"/>
+ <vartype class="system" format="ndb_cluster_connection_pool" isdynamic="no" scope="global" inversion="5.1.24-ndb-6.2.16"/>
+ <vartype class="system" format="ndb_cluster_connection_pool" isdynamic="no" scope="global" inversion="5.1.24-ndb-6.3.13"/>
+ <vartype class="status" format="Ndb_cluster_connection_pool" isdynamic="no" scope="global" inversion="5.1.24-ndb-6.2.16" outversion="5.1.51-ndb-7.0.23"/>
+ <vartype class="status" format="Ndb_cluster_connection_pool" isdynamic="no" scope="global" inversion="5.1.24-ndb-6.3.13" outversion="5.1.51-ndb-7.1.12"/>
</types>
<values vartype="numeric" platform="all">
Modified: trunk/refman-5.1/mysql-cluster-configuration-core.xml
===================================================================
--- trunk/refman-5.1/mysql-cluster-configuration-core.xml 2011-03-07 13:01:30 UTC (rev 25285)
+++ trunk/refman-5.1/mysql-cluster-configuration-core.xml 2011-03-07 13:24:40 UTC (rev 25286)
Changed blocks: 3, Lines Added: 37, Lines Deleted: 6; 3599 bytes
@@ -6591,11 +6591,22 @@
<para condition="dynamic:optvar:item" role="5.1:ndb-config-params:sharedglobalmemory-ndbd"/>
<para>
- This determines the amount of memory that is used for log
- buffers, disk operations (such as page requests and wait
- queues), and metadata for tablespaces, log file groups,
- <literal>UNDO</literal> files, and data files. It can be set
- in the <literal>[ndbd]</literal> or <literal>[ndbd
+ This parameter determines the amount of memory that is used
+ for log buffers, disk operations (such as page requests and
+ wait queues), and metadata for tablespaces, log file groups,
+ <literal>UNDO</literal> files, and data files. The shared
+ global memory pool also provides memory used for satisfying
+ the memory requirements of the
+ <literal>INITIAL_SIZE</literal> and
+ <literal>UNDO_BUFFER_SIZE</literal> options used with
+ <literal role="stmt">CREATE LOGFILE GROUP</literal> and
+ <literal role="stmt">ALTER LOGFILE GROUP</literal>
+ statements, including any default value implied for these
+ options by the setting of the
+ <literal role="ndbparam:ndbd">InitialLogFileGroup</literal>
+ data node configuration parameter.
+ <literal>SharedGlobalMemory</literal> can be set in the
+ <literal>[ndbd]</literal> or <literal>[ndbd
default]</literal> section of the
<filename>config.ini</filename> configuration file, and is
measured in bytes.
@@ -6955,6 +6966,19 @@
</para>
<para>
+ Resources for the initial log file group are taken from
+ the global memory pool whose size is determined by the
+ value of the
+ <literal role="ndbparam:ndbd">SharedGlobalMemory</literal>
+ data node configuration parameter; if this parameter is
+ set too low and the values set in
+ <literal>InitialLogFileGroup</literal> for the logfile
+ group's initial size or undo buffer size are too
+ high, the cluster may fail to create the default log
+ file group when starting, or fail to start altogether.
+ </para>
+
+ <para>
This parameter, if used, should always be set in the
<literal>[ndbd default]</literal> section of the
<filename>config.ini</filename> file. The behavior of a
@@ -10070,8 +10094,15 @@
This option was introduced in MySQL Cluster NDB 6.2.2.
Beginning with MySQL Cluster NDB 6.2.16 and MySQL Cluster
NDB 6.3.13, the value used for this option is available as a
- global status variable (Bug#35573).
+ system variable (Bug#35573).
</para>
+
+ <para>
+ Prior to MySQL Cluster NDB 7.0.23 and MySQL Cluster NDB
+ 7.1.12, there was also a status variable corresponding to
+ this option; however, the status variable was removed as
+ redundant as of these versions. (Bug#60119)
+ </para>
</listitem>
<listitem>
Modified: trunk/refman-5.1/mysql-cluster-news-core.xml
===================================================================
--- trunk/refman-5.1/mysql-cluster-news-core.xml 2011-03-07 13:01:30 UTC (rev 25285)
+++ trunk/refman-5.1/mysql-cluster-news-core.xml 2011-03-07 13:24:40 UTC (rev 25286)
Changed blocks: 6, Lines Added: 0, Lines Deleted: 6; 1549 bytes
@@ -124,7 +124,6 @@
see <xref linkend="mysql-cluster-development-5-1-ndb-7-1"/>.
</para>
-<!--
<section id="mysql-cluster-news-5-1-51-ndb-7-1-12">
<title condition="dynamic:changelog:vertitle" role="5.1.51-ndb-7.1.12:mysqld:all"/>
@@ -161,7 +160,6 @@
<para condition="dynamic:changelog:entrylist" role="5.1.51-ndb-7.1.12:mysqld:all"/>
</section>
--->
<section id="mysql-cluster-news-5-1-51-ndb-7-1-11">
@@ -788,7 +786,6 @@
</itemizedlist>
-<!--
<section id="mysql-cluster-news-5-1-51-ndb-7-0-23">
<title condition="dynamic:changelog:vertitle" role="5.1.51-ndb-7.0.23:mysqld:all"/>
@@ -834,7 +831,6 @@
<para condition="dynamic:changelog:entrylist" role="5.1.51-ndb-7.0.23:mysqld:all"/>
</section>
--->
<section id="mysql-cluster-news-5-1-51-ndb-7-0-22">
@@ -2392,7 +2388,6 @@
see <xref linkend="mysql-cluster-development-5-1-ndb-6-3"/>.
</para>
-<!--
<section id="mysql-cluster-news-5-1-51-ndb-6-3-42">
<title condition="dynamic:changelog:vertitle" role="5.1.51-ndb-6.3.42:mysqld:all"/>
@@ -2436,7 +2431,6 @@
<para condition="dynamic:changelog:entrylist" role="5.1.51-ndb-6.3.42:mysqld:all"/>
</section>
--->
<section id="mysql-cluster-news-5-1-51-ndb-6-3-41">
Modified: trunk/refman-5.1/sql-syntax-data-definition.xml
===================================================================
--- trunk/refman-5.1/sql-syntax-data-definition.xml 2011-03-07 13:01:30 UTC (rev 25285)
+++ trunk/refman-5.1/sql-syntax-data-definition.xml 2011-03-07 13:24:40 UTC (rev 25286)
Changed blocks: 2, Lines Added: 21, Lines Deleted: 0; 1723 bytes
@@ -533,6 +533,16 @@
</para>
<para>
+ Memory used for <literal>UNDO_BUFFER_SIZE</literal> comes from the
+ global pool whose size is determined by the value of the
+ <literal role="ndbparam:ndbd">SharedGlobalMemory</literal> data
+ node configuration parameter. This includes any default value
+ implied for this option by the setting of the
+ <literal role="ndbparam:ndbd">InitialLogFileGroup</literal> data
+ node configuration parameter.
+ </para>
+
+ <para>
<literal role="stmt">ALTER LOGFILE GROUP</literal> was added in
MySQL 5.1.6. It is useful only with Disk Data storage for MySQL
Cluster. For more information, see
@@ -4312,6 +4322,17 @@
</para>
<para>
+ The memory used for both <literal>INITIAL_SIZE</literal> and
+ <literal>UNDO_BUFFER_SIZE</literal> comes from the global pool
+ whose size is determined by the value of the
+ <literal role="ndbparam:ndbd">SharedGlobalMemory</literal> data
+ node configruation parameter. This includes any default value
+ implied for these options by the setting of the
+ <literal role="ndbparam:ndbd">InitialLogFileGroup</literal> data
+ node configuration parameter.
+ </para>
+
+ <para>
Beginning with MySQL Cluster NDB 6.2.17, 6.3.23, and 6.4.3, the
maximum permitted for <literal>UNDO_BUFFER_SIZE</literal> is
<literal>600M</literal>; previously, it was
| Thread |
|---|
| • svn commit - mysqldoc@oter02: r25286 - in trunk: dynamic-docs/changelog dynamic-docs/command-optvars refman-5.1 | jon.stephens | 7 Mar |
