MySQL Lists: commits: svn commit - mysqldoc@docsrva: r3755

List:	Commits	« Previous Message Next Message »
From:	jon	Date:	October 26 2006 3:46pm
Subject:	svn commit - mysqldoc@docsrva: r3755 - trunk/refman-5.1
View as plain text
Author: jstephens
Date: 2006-10-26 15:46:18 +0200 (Thu, 26 Oct 2006)
New Revision: 3755

Log:

Preliminary documentation for new DiskSyncSize, DiskCheckpointSpeed,
DiskCheckpointSpeedInRestart config parameters (Mikael)



Modified:
   trunk/refman-5.1/mysql-cluster.xml


Modified: trunk/refman-5.1/mysql-cluster.xml
===================================================================
--- trunk/refman-5.1/mysql-cluster.xml	2006-10-26 10:42:06 UTC (rev 3754)
+++ trunk/refman-5.1/mysql-cluster.xml	2006-10-26 13:46:18 UTC (rev 3755)
Changed blocks: 11, Lines Added: 153, Lines Deleted: 14; 12011 bytes

@@ -5164,10 +5164,69 @@
 
           <listitem>
             <indexterm>
-             
<primary><literal>NoOfDiskPagesToDiskAfterRestartTUP</literal> (MySQL
Cluster
-                configuration parameter)</primary>
+              <primary><literal>DiskSyncSize</literal></primary>
             </indexterm>
 
+            <para id="mysql-cluster-param-ndbd-definition-disksyncsize">
+              <literal>DiskSyncSize</literal>
+            </para>
+
+            <para>
+              This is the maximum number of bytes to store before
+              flushing data to a local checkpoint file.
+            </para>
+
+            <para>
+              This parameter was added in MySQL 5.1.12.
+            </para>
+          </listitem>
+
+          <listitem>
+            <indexterm>
+             
<primary><literal>DiskCheckpointSpeed</literal></primary>
+            </indexterm>
+
+            <para id="mysql-cluster-param-ndbd-definition-diskcheckpointspeed">
+              <literal>DiskCheckpointSpeed</literal>
+            </para>
+
+            <para>
+              The amount of data,in bytes per second, that is sent to
+              disk during a local checkpoint.
+            </para>
+
+            <para>
+              This parameter was added in MySQL 5.1.12.
+            </para>
+          </listitem>
+
+          <listitem>
+            <indexterm>
+             
<primary><literal>DiskCheckpointSpeedInRestart</literal></primary>
+            </indexterm>
+
+            <para
+              id="mysql-cluster-param-ndbd-definition-diskcheckpointspeedinrestart">
+              <literal>DiskCheckpointSpeedInRestart</literal>
+            </para>
+
+            <para>
+              The amount of data,in bytes per second, that is sent to
+              disk during a local checkpoint as part of a restart
+              operation.
+            </para>
+
+            <para>
+              This parameter was added in MySQL 5.1.12.
+            </para>
+          </listitem>
+
+          <listitem>
+            <indexterm>
+             
<primary><literal>NoOfDiskPagesToDiskAfterRestartTUP</literal>
+                (<emphasis>DEPRECATED</emphasis>)</primary>
+            </indexterm>
+
             <para
id="mysql-cluster-param-ndbd-definition-noofdiskpagestodiskafterrestarttup">
               <literal>NoOfDiskPagesToDiskAfterRestartTUP</literal>
             </para>

@@ -5212,12 +5271,21 @@
             <para>
               The default value is 40 (3.2MB of data pages per second).
             </para>
+
+            <para>
+              <emphasis role="bold">Note</emphasis>: This parameter is
+              deprecated as of MySQL 5.1.6. For MySQL 5.1.12 and later
+              versions, use
+              <link
linkend="mysql-cluster-param-ndbd-definition-diskcheckpointspeed">DiskCheckpointSpeed</link>
+              and
+              <link
linkend="mysql-cluster-param-ndbd-definition-disksyncsize">DiskSyncSize</link>.
+            </para>
           </listitem>
 
           <listitem>
             <indexterm>
-             
<primary><literal>NoOfDiskPagesToDiskAfterRestartACC</literal> (MySQL
Cluster
-                configuration parameter)</primary>
+             
<primary><literal>NoOfDiskPagesToDiskAfterRestartACC</literal>
+                (<emphasis>DEPRECATED</emphasis>)</primary>
             </indexterm>
 
             <para
id="mysql-cluster-param-ndbd-definition-noofdiskpagestodiskafterrestartacc">

@@ -5235,12 +5303,21 @@
               The default value of this parameter is 20 (1.6MB of index
               memory pages per second).
             </para>
+
+            <para>
+              <emphasis role="bold">Note</emphasis>: This parameter is
+              deprecated as of MySQL 5.1.6. For MySQL 5.1.12 and later
+              versions, use
+              <link
linkend="mysql-cluster-param-ndbd-definition-diskcheckpointspeed">DiskCheckpointSpeed</link>
+              and
+              <link
linkend="mysql-cluster-param-ndbd-definition-disksyncsize">DiskSyncSize</link>.
+            </para>
           </listitem>
 
           <listitem>
             <indexterm>
-             
<primary><literal>NoOfDiskPagesToDiskDuringRestartTUP</literal> (MySQL
Cluster
-                configuration parameter)</primary>
+             
<primary><literal>NoOfDiskPagesToDiskDuringRestartTUP</literal>
+                (<emphasis>DEPRECATED</emphasis>)</primary>
             </indexterm>
 
             <para
id="mysql-cluster-param-ndbd-definition-noofdiskpagestodiskduringrestarttup">

@@ -5266,12 +5343,21 @@
             <para>
               The default value is 40 (3.2MB per second).
             </para>
+
+            <para>
+              <emphasis role="bold">Note</emphasis>: This parameter is
+              deprecated as of MySQL 5.1.6. For MySQL 5.1.12 and later
+              versions, use
+              <link
linkend="mysql-cluster-param-ndbd-definition-diskcheckpointspeedinrestart">DiskCheckpointSpeedInRestart</link>
+              and
+              <link
linkend="mysql-cluster-param-ndbd-definition-disksyncsize">DiskSyncSize</link>.
+            </para>
           </listitem>
 
           <listitem>
             <indexterm>
-             
<primary><literal>NoOfDiskPagesToDiskDuringRestartACC</literal> (MySQL
Cluster
-                configuration parameter)</primary>
+             
<primary><literal>NoOfDiskPagesToDiskDuringRestartACC</literal>
+                (<emphasis>DEPRECATED</emphasis>)</primary>
             </indexterm>
 
             <para
id="mysql-cluster-param-ndbd-definition-noofdiskpagestodiskduringrestartacc">

@@ -5295,12 +5381,20 @@
             <para>
               The default value is 20 (1.6MB per second).
             </para>
+
+            <para>
+              <emphasis role="bold">Note</emphasis>: This parameter is
+              deprecated as of MySQL 5.1.6. For MySQL 5.1.12 and later
+              versions, use
+              <link
linkend="mysql-cluster-param-ndbd-definition-diskcheckpointspeedinrestart">DiskCheckpointSpeedInRestart</link>
+              and
+              <link
linkend="mysql-cluster-param-ndbd-definition-disksyncsize">DiskSyncSize</link>.
+            </para>
           </listitem>
 
           <listitem>
             <indexterm>
-              <primary><literal>ArbitrationTimeout</literal> (MySQL
Cluster configuration
-                parameter)</primary>
+              <primary><literal>ArbitrationTimeout</literal>
(<emphasis>DEPRECATED</emphasis>)</primary>
             </indexterm>
 
             <para id="mysql-cluster-param-ndbd-definition-arbitrationtimeout">

@@ -7146,7 +7240,8 @@
                 <entry>N</entry>
               </row>
               <row>
-                <entry><literal><link
linkend="mysql-cluster-param-ndbd-definition-noofdiskpagestodiskafterrestartacc">NoOfDiskPagesToDiskAfterRestartACC</link></literal></entry>
+                <entry><literal><link
linkend="mysql-cluster-param-ndbd-definition-noofdiskpagestodiskafterrestartacc">NoOfDiskPagesToDiskAfterRestartACC</link></literal>
+                  (<emphasis>DEPRECATED</emphasis> as of MySQL
5.1.6)</entry>
                 <entry>integer (number of 8KB pages per 100
milliseconds)</entry>
                 <entry>20 (= 20 * 80KB = 1.6MB/second)</entry>
                 <entry>1</entry>

@@ -7154,7 +7249,8 @@
                 <entry>N</entry>
               </row>
               <row>
-                <entry><literal><link
linkend="mysql-cluster-param-ndbd-definition-noofdiskpagestodiskafterrestarttup">NoOfDiskPagesToDiskAfterRestartTUP</link></literal></entry>
+                <entry><literal><link
linkend="mysql-cluster-param-ndbd-definition-noofdiskpagestodiskafterrestarttup">NoOfDiskPagesToDiskAfterRestartTUP</link></literal>
+                  (<emphasis>DEPRECATED</emphasis> as of MySQL
5.1.6)</entry>
                 <entry>integer (number of 8KB pages per 100
milliseconds)</entry>
                 <entry>40 (= 40 * 80KB = 3.2MB/second)</entry>
                 <entry>1</entry>

@@ -7162,7 +7258,8 @@
                 <entry>N</entry>
               </row>
               <row>
-                <entry><literal><link
linkend="mysql-cluster-param-ndbd-definition-noofdiskpagestodiskduringrestartacc">NoOfDiskPagesToDiskDuringRestartACC</link></literal></entry>
+                <entry><literal><link
linkend="mysql-cluster-param-ndbd-definition-noofdiskpagestodiskduringrestartacc">NoOfDiskPagesToDiskDuringRestartACC</link></literal>
+                  (<emphasis>DEPRECATED</emphasis> as of MySQL
5.1.6)</entry>
                 <entry>integer (number of 8KB pages per 100
milliseconds)</entry>
                 <entry>20 (= 20 * 80KB = 1.6MB/second)</entry>
                 <entry>1</entry>

@@ -7170,7 +7267,8 @@
                 <entry>N</entry>
               </row>
               <row>
-                <entry><literal><link
linkend="mysql-cluster-param-ndbd-definition-noofdiskpagestodiskduringrestarttup">NoOfDiskPagesToDiskDuringRestartTUP</link></literal></entry>
+                <entry><literal><link
linkend="mysql-cluster-param-ndbd-definition-noofdiskpagestodiskduringrestarttup">NoOfDiskPagesToDiskDuringRestartTUP</link></literal>
+                  (<emphasis>DEPRECATED</emphasis> as of MySQL
5.1.6)</entry>
                 <entry>integer (number of 8KB pages per 100
milliseconds)</entry>
                 <entry>40 (= 40 * 80KB = 3.2MB/second)</entry>
                 <entry>1</entry>

@@ -7178,6 +7276,33 @@
                 <entry>N</entry>
               </row>
               <row>
+                <entry><literal><link
linkend="mysql-cluster-param-ndbd-definition-diskcheckpointspeed">DiskCheckpointSpeed</link></literal>
+                  (added in MySQL 5.1.12)</entry>
+                <entry>integer (number of bytes)</entry>
+                <entry></entry>
+                <entry></entry>
+                <entry></entry>
+                <entry>N</entry>
+              </row>
+              <row>
+                <entry><literal><link
linkend="mysql-cluster-param-ndbd-definition-diskcheckpointspeedinrestart">DiskCheckpointSpeedInRestart</link></literal>
+                  (added in MySQL 5.1.12)</entry>
+                <entry>integer (number of bytes)</entry>
+                <entry></entry>
+                <entry></entry>
+                <entry></entry>
+                <entry>N</entry>
+              </row>
+              <row>
+                <entry><literal><link
linkend="mysql-cluster-param-ndbd-definition-disksyncsize">DiskSyncSize</link></literal>
+                  (added in MySQL 5.1.12)</entry>
+                <entry>integer (number of bytes)</entry>
+                <entry></entry>
+                <entry></entry>
+                <entry></entry>
+                <entry>N</entry>
+              </row>
+              <row>
                 <entry><literal><link
linkend="mysql-cluster-param-ndbd-definition-nooffragmentlogfiles">NoOfFragmentLogFiles</link></literal></entry>
                 <entry>integer</entry>
                 <entry>8</entry>

@@ -7672,6 +7797,20 @@
       </para>
 
       <para>
+        <emphasis>Important</emphasis>: The parameters
+        <literal>NoOfDiskPagesToDiskAfterRestartTUP</literal> and
+        <literal>NoOfDiskPagesToDiskAfterRestartACC</literal> were
+        deprecated in MySQL 5.1.6. From MySQL 5.1.6 through 5.1.11, disk
+        writes during LCPs took place at the maximum speed possible.
+        Beginning with MySQL 5.1.12, the speed and throughput for LCPs
+        are controlled using the parameters
+        <literal>DiskSyncSize</literal>,
+        <literal>DiskCheckpointSpeed</literal>, and
+        <literal>DiskCheckpointSpeedInRestart</literal>. See
+        <xref linkend="mysql-cluster-ndbd-definition"/>.
+      </para>
+
+      <para>
         In this example, we assume that our application performs the
         following numbers of types of operations per hour:
       </para>
Thread
• svn commit - mysqldoc@docsrva: r3755 - trunk/refman-5.1	jon	26 Oct