List:Commits« Previous MessageNext Message »
From:jon.stephens Date:March 7 2011 1:24pm
Subject:svn commit - mysqldoc@oter02: r25286 - in trunk: dynamic-docs/changelog dynamic-docs/command-optvars refman-5.1
View as plain text  
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&apos;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.1jon.stephens7 Mar