Author: jstephens
Date: 2006-06-04 12:00:42 +0200 (Sun, 04 Jun 2006)
New Revision: 2270
Log:
- New Cluster chapter section - Cluster Configuration Parameters
(Commented out pending review)
(Thanks, Sergei and Jeb!)
- Reformat
- New section titles
Modified:
trunk/refman-4.1/ndbcluster.xml
trunk/refman-5.0/ndbcluster.xml
trunk/refman-5.1/ndbcluster.xml
trunk/refman-common/titles.en.ent
Modified: trunk/refman-4.1/ndbcluster.xml
===================================================================
--- trunk/refman-4.1/ndbcluster.xml 2006-06-04 05:40:02 UTC (rev 2269)
+++ trunk/refman-4.1/ndbcluster.xml 2006-06-04 10:00:42 UTC (rev 2270)
@@ -6410,6 +6410,887 @@
</section>
+ <!--<section id="mysql-cluster-config-params-overview">
+
+ <title>&title-mysql-cluster-config-params-overview;</title>
+
+ <remark role="todo">
+ [js] Uncomment links to other Cluster chapter sections before
+ deployment.
+ </remark>
+
+ <para>
+ The next three sections provide summaries of MySQL Cluster
+ configuration parameters used in the
+ <filename>config.ini</filename> file to govern the cluster's
+ functioning. Each section lists the parameters for one of the
+ Cluster node process types (<command>ndbd</command>,
+ <command>ndb_mgmd</command>, and <command>mysqld</command>), and
+ includes the parameter's type as well as its default, mimimum,
+ and maximum values as applicable. It is also stated whether a
+ restart or initial restart of the cluster is required to change
+ the value of a given configuration parameter.
+ </para>
+
+ <para>
+ Because some of these parameters can be used for configuring
+ more than one type of cluster node, they may appear in more than
+ one of these summaries.
+ </para>
+
+ <para>
+ (Note that <literal>4294967039</literal> — which often
+ appears as a maximum value in these tables — is equal to
+ <literal>2<superscript>32</superscript> −
+ 2<superscript>8</superscript> − 1</literal>.)
+ </para>
+
+ <section id="mysql-cluster-config-params-ndbd">
+
+ <title>&title-mysql-cluster-config-params-ndbd;</title>
+
+ <para>
+ The following table provides information about parameters used
+ in the <literal>[NDBD]</literal> or
+ <literal>[NDB_DEFAULT]</literal> sections of a
+ <filename>config.ini</filename> file for configuring MySQL
+ Cluster data nodes. For detailed descriptions and other
+ additional information about each of these parameters, see
+ <xref linkend="mysql-cluster-db-definition"/>.
+ </para>
+
+ <para>
+ The <emphasis role="bold">Restart Required</emphasis> column
+ can have one of 3 values, whose meanings are as follows:
+ </para>
+
+ <itemizedlist>
+
+ <listitem>
+ <para>
+ <literal>N</literal>: No restart is required to update the
+ value of the parameter.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>Y</literal>: A simple restart is needed to update
+ the parameter's value.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>I</literal>: An initial restart is necessary for
+ updating the value of the parameter.
+ </para>
+ </listitem>
+
+ </itemizedlist>
+
+ <informaltable width="95*">
+ <tgroup cols="6">
+ <colspec colwidth="30*"/>
+ <colspec colwidth="5*"/>
+ <colspec colwidth="20*"/>
+ <colspec colwidth="20*"/>
+ <colspec colwidth="20*"/>
+ <colspec colwidth="5*"/>
+ <tbody>
+ <row>
+ <entry><emphasis role="bold">Parameter Name</emphasis></entry>
+ <entry><emphasis role="bold">Type/Units</emphasis></entry>
+ <entry><emphasis role="bold">Default Value</emphasis></entry>
+ <entry><emphasis role="bold">Minimum Value</emphasis></entry>
+ <entry><emphasis role="bold">Maximum Value</emphasis></entry>
+ <entry><emphasis role="bold">Restart Required</emphasis></entry>
+ </row>
+ <row>
+ <entry><literal>ArbitrationTimeout</literal></entry>
+ <entry>milliseconds</entry>
+ <entry>1000</entry>
+ <entry>10</entry>
+ <entry>4294967039</entry>
+ <entry>?</entry>
+ </row>
+ <row>
+ <entry><literal>BackupDataBufferSize</literal></entry>
+ <entry>bytes</entry>
+ <entry>2M</entry>
+ <entry>0</entry>
+ <entry>4294967039</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>BackupDataDir</literal></entry>
+ <entry>string</entry>
+ <entry><filename><literal>FileSystemPath</literal>/BACKUP</filename></entry>
+ <entry>N/A</entry>
+ <entry>N/A</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>BackupLogBufferSize</literal></entry>
+ <entry>bytes</entry>
+ <entry>2M</entry>
+ <entry>0</entry>
+ <entry>4294967039</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>BackupMemory</literal></entry>
+ <entry>bytes</entry>
+ <entry>4M</entry>
+ <entry>0</entry>
+ <entry>4294967039</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>BackupWriteSize</literal></entry>
+ <entry>bytes</entry>
+ <entry>32K</entry>
+ <entry>2K</entry>
+ <entry>4294967039</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>BatchSizePerLocalScan</literal></entry>
+ <entry>integer</entry>
+ <entry>64</entry>
+ <entry>1</entry>
+ <entry>992</entry>
+ <entry>?</entry>
+ </row>
+ <row>
+ <entry><literal>DataDir</literal></entry>
+ <entry>string</entry>
+ <entry>?</entry>
+ <entry>N/A</entry>
+ <entry>N/A</entry>
+ <entry>N</entry>
+ </row>
+ <row>
+ <entry><literal>DataMemory</literal></entry>
+ <entry>bytes</entry>
+ <entry>80M</entry>
+ <entry>1M</entry>
+ <entry>1024G (subject to available system RAM and size of
+ <literal>IndexMemory</literal>)</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>Diskless</literal></entry>
+ <entry>true|false (<literal>1</literal>|<literal>0</literal>)</entry>
+ <entry>0</entry>
+ <entry>0</entry>
+ <entry>1</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>ExecuteOnComputer</literal> — synonym for
+ <literal>HostName</literal> (preferred)</entry>
+ <entry/>
+ <entry/>
+ <entry/>
+ <entry/>
+ <entry/>
+ </row>
+ <row>
+ <entry><literal>FileSystemPath</literal></entry>
+ <entry>string</entry>
+ <entry>value specified for <literal>DataDir</literal></entry>
+ <entry>N/A</entry>
+ <entry>N/A</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>HeartbeatIntervalDbApi</literal></entry>
+ <entry>milliseconds</entry>
+ <entry>1500</entry>
+ <entry>100</entry>
+ <entry>4294967039</entry>
+ <entry>?</entry>
+ </row>
+ <row>
+ <entry><literal>HeartbeatIntervalDbDb</literal></entry>
+ <entry>milliseconds</entry>
+ <entry>1500</entry>
+ <entry>10</entry>
+ <entry>4294967039</entry>
+ <entry>?</entry>
+ </row>
+ <row>
+ <entry><literal>HostName</literal></entry>
+ <entry>string</entry>
+ <entry><literal>localhost</literal></entry>
+ <entry>N/A</entry>
+ <entry>N/A</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>Id</literal></entry>
+ <entry>integer</entry>
+ <entry><emphasis>None</emphasis></entry>
+ <entry>1</entry>
+ <entry>63</entry>
+ <entry>Y</entry>
+ </row>
+ <row>
+ <entry><literal>IndexMemory</literal></entry>
+ <entry>bytes</entry>
+ <entry>18M</entry>
+ <entry>1M</entry>
+ <entry>1024G (subject to available system RAM and size of
+ <literal>DataMemory</literal>)</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>LockPagesInMainMemory</literal></entry>
+ <entry>true|false (<literal>1</literal>|<literal>0</literal>)</entry>
+ <entry>0</entry>
+ <entry>0</entry>
+ <entry>1</entry>
+ <entry>Y</entry>
+ </row>
+ <row>
+ <entry><literal>LogDestination</literal></entry>
+ <entry><literal>CONSOLE</literal>, <literal>SYSLOG</literal>, or
+ <literal>FILE</literal></entry>
+ <entry>See <xref linkend="mysql-cluster-mgm-definition"/>.</entry>
+ <entry>N/A</entry>
+ <entry>N/A</entry>
+ <entry>Y</entry>
+ </row>
+ <row>
+ <entry><literal>LogLevelCheckpoint</literal></entry>
+ <entry>integer</entry>
+ <entry>0</entry>
+ <entry>0</entry>
+ <entry>15</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>LogLevelConnection</literal></entry>
+ <entry>integer</entry>
+ <entry>0</entry>
+ <entry>0</entry>
+ <entry>15</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>LogLevelError</literal></entry>
+ <entry>integer</entry>
+ <entry>0</entry>
+ <entry>0</entry>
+ <entry>15</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>LogLevelInfo</literal></entry>
+ <entry>integer</entry>
+ <entry>0</entry>
+ <entry>0</entry>
+ <entry>15</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>LogLevelNodeRestart</literal></entry>
+ <entry>integer</entry>
+ <entry>0</entry>
+ <entry>0</entry>
+ <entry>15</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>LogLevelShutdown</literal></entry>
+ <entry>integer</entry>
+ <entry>0</entry>
+ <entry>0</entry>
+ <entry>15</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>LogLevelStartup</literal></entry>
+ <entry>integer</entry>
+ <entry>1</entry>
+ <entry>0</entry>
+ <entry>15</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>LogLevelStatistic</literal></entry>
+ <entry>integer</entry>
+ <entry>0</entry>
+ <entry>0</entry>
+ <entry>15</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>LongMessageBuffer</literal></entry>
+ <entry>bytes</entry>
+ <entry>1M</entry>
+ <entry>512K</entry>
+ <entry>4294967039</entry>
+ <entry>?</entry>
+ </row>
+ <row>
+ <entry><literal>MaxNoOfAttributes</literal></entry>
+ <entry>integer</entry>
+ <entry>1000</entry>
+ <entry>32</entry>
+ <entry>4294967039</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>MaxNoOfConcurrentIndexOperations</literal></entry>
+ <entry>integer</entry>
+ <entry>?</entry>
+ <entry>0</entry>
+ <entry>4294967039</entry>
+ <entry>?</entry>
+ </row>
+ <row>
+ <entry><literal>MaxNoOfConcurrentOperations</literal></entry>
+ <entry>integer</entry>
+ <entry>32768</entry>
+ <entry>32</entry>
+ <entry>4294967039</entry>
+ <entry>?</entry>
+ </row>
+ <row>
+ <entry><literal>MaxNoOfConcurrentScans</literal></entry>
+ <entry>integer</entry>
+ <entry>256</entry>
+ <entry>2</entry>
+ <entry>500</entry>
+ <entry>?</entry>
+ </row>
+ <row>
+ <entry><literal>MaxNoOfConcurrentTransactions</literal></entry>
+ <entry>integer</entry>
+ <entry>4096</entry>
+ <entry>32</entry>
+ <entry>4294967039</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>MaxNoOfFiredTriggers</literal></entry>
+ <entry>integer</entry>
+ <entry>?</entry>
+ <entry>0</entry>
+ <entry>4294967039</entry>
+ <entry>?</entry>
+ </row>
+ <row>
+ <entry><literal>MaxNoOfIndexes</literal> (<emphasis>DEPRECATED</emphasis>
+ — use <literal>MaxNoOfOrderedIndexes</literal>
+ or <literal>MaxNoOfUniqueHashIndexes</literal>
+ instead)</entry>
+ <entry>integer</entry>
+ <entry>128</entry>
+ <entry>0</entry>
+ <entry>4294967039</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>MaxNoOfLocalOperations</literal></entry>
+ <entry>integer</entry>
+ <entry>?</entry>
+ <entry>32</entry>
+ <entry>4294967039</entry>
+ <entry>?</entry>
+ </row>
+ <row>
+ <entry><literal>MaxNoOfLocalScans</literal></entry>
+ <entry>integer</entry>
+ <entry>?</entry>
+ <entry>32</entry>
+ <entry>4294967039</entry>
+ <entry>?</entry>
+ </row>
+ <row>
+ <entry><literal>MaxNoOfOrderedIndexes</literal></entry>
+ <entry>integer</entry>
+ <entry>128</entry>
+ <entry>0</entry>
+ <entry>4294967039</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>MaxNoOfSavedMessages</literal></entry>
+ <entry>integer</entry>
+ <entry>25</entry>
+ <entry>0</entry>
+ <entry>4294967039</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>MaxNoOfTables</literal></entry>
+ <entry>integer</entry>
+ <entry>128</entry>
+ <entry>8</entry>
+ <entry>4294967039</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>MaxNoOfTriggers</literal></entry>
+ <entry>integer</entry>
+ <entry>768</entry>
+ <entry>0</entry>
+ <entry>4294967039</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>MaxNoOfUniqueHashIndexes</literal></entry>
+ <entry>integer</entry>
+ <entry>64</entry>
+ <entry>0</entry>
+ <entry>4294967039</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>NoOfDiskPagesToDiskAfterRestartACC</literal></entry>
+ <entry>integer (number of 8KB pages per 100 milliseconds)</entry>
+ <entry>20 (= 20 * 80KB = 1.6MB/second)</entry>
+ <entry>1</entry>
+ <entry>4294967039</entry>
+ <entry>?</entry>
+ </row>
+ <row>
+ <entry><literal>NoOfDiskPagesToDiskAfterRestartTUP</literal></entry>
+ <entry>integer (number of 8KB pages per 100 milliseconds)</entry>
+ <entry>40 (= 40 * 80KB = 3.2MB/second)</entry>
+ <entry>1</entry>
+ <entry>4294967039</entry>
+ <entry>?</entry>
+ </row>
+ <row>
+ <entry><literal>NoOfDiskPagesToDiskDuringRestartACC</literal></entry>
+ <entry>integer (number of 8KB pages per 100 milliseconds)</entry>
+ <entry>20 (= 20 * 80KB = 1.6MB/second)</entry>
+ <entry>1</entry>
+ <entry>4294967039</entry>
+ <entry>?</entry>
+ </row>
+ <row>
+ <entry><literal>NoOfDiskPagesToDiskDuringRestartTUP</literal></entry>
+ <entry>integer (number of 8KB pages per 100 milliseconds)</entry>
+ <entry>40 (= 40 * 80KB = 3.2MB/second)</entry>
+ <entry>1</entry>
+ <entry>4294967039</entry>
+ <entry>?</entry>
+ </row>
+ <row>
+ <entry><literal>NoOfFragmentLogFiles</literal></entry>
+ <entry>integer</entry>
+ <entry>8</entry>
+ <entry>1</entry>
+ <entry>4294967039</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>NoOfReplicas</literal></entry>
+ <entry>integer</entry>
+ <entry><emphasis>None</emphasis></entry>
+ <entry>1</entry>
+ <entry>4</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>PortNumber</literal></entry>
+ <entry>integer</entry>
+ <entry>1186</entry>
+ <entry>0</entry>
+ <entry>4294967039</entry>
+ <entry>N</entry>
+ </row>
+ <row>
+ <entry><literal>RedoBuffer</literal></entry>
+ <entry>bytes</entry>
+ <entry>8M</entry>
+ <entry>1M</entry>
+ <entry>4294967039</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>RestartOnErrorInsert</literal> (<emphasis>DEBUG BUILDS
+ ONLY</emphasis>)</entry>
+ <entry>true|false (<literal>1</literal>|<literal>0</literal>)</entry>
+ <entry>0</entry>
+ <entry>0</entry>
+ <entry>1</entry>
+ <entry>Y</entry>
+ </row>
+ <row>
+ <entry><literal>StartFailureTimeout</literal></entry>
+ <entry>milliseconds</entry>
+ <entry>60000</entry>
+ <entry>0</entry>
+ <entry>4294967039</entry>
+ <entry>?</entry>
+ </row>
+ <row>
+ <entry><literal>StartPartialTimeout</literal></entry>
+ <entry>milliseconds</entry>
+ <entry>30000</entry>
+ <entry>0</entry>
+ <entry>4294967039</entry>
+ <entry>?</entry>
+ </row>
+ <row>
+ <entry><literal>StartPartitionedTimeout</literal></entry>
+ <entry>milliseconds</entry>
+ <entry>60000</entry>
+ <entry>0</entry>
+ <entry>4294967039</entry>
+ <entry>?</entry>
+ </row>
+ <row>
+ <entry><literal>StopOnError</literal></entry>
+ <entry>true|false (<literal>1</literal>|<literal>0</literal>)</entry>
+ <entry>1</entry>
+ <entry>0</entry>
+ <entry>1</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>TimeBetweenGlobalCheckpoints</literal></entry>
+ <entry>milliseconds</entry>
+ <entry>2000</entry>
+ <entry>10</entry>
+ <entry>32000</entry>
+ <entry>?</entry>
+ </row>
+ <row>
+ <entry><literal>TimeBetweenInactiveTransactionAbortCheck</literal></entry>
+ <entry>milliseconds</entry>
+ <entry>1000</entry>
+ <entry>1000</entry>
+ <entry>4294967039</entry>
+ <entry>?</entry>
+ </row>
+ <row>
+ <entry><literal>TimeBetweenLocalCheckpoints</literal></entry>
+ <entry>integer (number of 4-byte words as a base-2 logarithm)</entry>
+ <entry>20 (= <literal>4 * 2<superscript>20</superscript></literal> = 4MB write
+ operations)</entry>
+ <entry>0</entry>
+ <entry>31</entry>
+ <entry>?</entry>
+ </row>
+ <row>
+ <entry><literal>TimeBetweenWatchDogCheck</literal></entry>
+ <entry>milliseconds</entry>
+ <entry>4000</entry>
+ <entry>70</entry>
+ <entry>4294967039</entry>
+ <entry>?</entry>
+ </row>
+ <row>
+ <entry><literal>TransactionBufferMemory</literal></entry>
+ <entry>bytes</entry>
+ <entry>?</entry>
+ <entry>1K</entry>
+ <entry>4294967039</entry>
+ <entry>?</entry>
+ </row>
+ <row>
+ <entry><literal>TransactionDeadlockDetectionTimeout</literal></entry>
+ <entry>milliseconds</entry>
+ <entry>1200</entry>
+ <entry>50</entry>
+ <entry>4294967039</entry>
+ <entry>?</entry>
+ </row>
+ <row>
+ <entry><literal>TransactionInactiveTimeout</literal></entry>
+ <entry>milliseconds</entry>
+ <entry>0</entry>
+ <entry>0</entry>
+ <entry>4294967039</entry>
+ <entry>?</entry>
+ </row>
+ <row>
+ <entry><literal>UndoDataBuffer</literal></entry>
+ <entry>bytes</entry>
+ <entry>16M</entry>
+ <entry>1M</entry>
+ <entry>4294967039</entry>
+ <entry>?</entry>
+ </row>
+ <row>
+ <entry><literal>UndoIndexBuffer</literal></entry>
+ <entry>bytes</entry>
+ <entry>2M</entry>
+ <entry>1M</entry>
+ <entry>4294967039</entry>
+ <entry>?</entry>
+ </row>
+ </tbody>
+ </tgroup>
+ </informaltable>
+
+ </section>
+
+ <section id="mysql-cluster-config-params-mgm">
+
+ <title>&title-mysql-cluster-config-params-mgm;</title>
+
+ <para>
+ The following table provides information about parameters used
+ in the <literal>[NDB_MGMD]</literal> or
+ <literal>[MGM]</literal> sections of a
+ <filename>config.ini</filename> file for configuring MySQL
+ Cluster management nodes. For detailed descriptions and other
+ additional information about each of these parameters, see
+ <xref linkend="mysql-cluster-mgm-definition"/>.
+ </para>
+
+ <para>
+ The <emphasis role="bold">Restart Required</emphasis> column
+ can have one of 3 values, whose meanings are as follows:
+ </para>
+
+ <itemizedlist>
+
+ <listitem>
+ <para>
+ <literal>N</literal>: No restart is required to update the
+ value of the parameter.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>Y</literal>: A simple restart is needed to update
+ the parameter's value.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>I</literal>: An initial restart is necessary for
+ updating the value of the parameter.
+ </para>
+ </listitem>
+
+ </itemizedlist>
+
+ <informaltable width="95*">
+ <tgroup cols="6">
+ <colspec colwidth="30*"/>
+ <colspec colwidth="5*"/>
+ <colspec colwidth="20*"/>
+ <colspec colwidth="20*"/>
+ <colspec colwidth="20*"/>
+ <colspec colwidth="5*"/>
+ <tbody>
+ <row>
+ <entry><emphasis role="bold">Parameter Name</emphasis></entry>
+ <entry><emphasis role="bold">Type/Units</emphasis></entry>
+ <entry><emphasis role="bold">Default Value</emphasis></entry>
+ <entry><emphasis role="bold">Minimum Value</emphasis></entry>
+ <entry><emphasis role="bold">Maximum Value</emphasis></entry>
+ <entry><emphasis role="bold">Restart Required</emphasis></entry>
+ </row>
+ <row>
+ <entry><literal>ArbitrationDelay</literal></entry>
+ <entry>milliseconds</entry>
+ <entry>0</entry>
+ <entry>0</entry>
+ <entry>4294967039</entry>
+ <entry>N</entry>
+ </row>
+ <row>
+ <entry><literal>ArbitrationRank</literal></entry>
+ <entry>integer</entry>
+ <entry>1</entry>
+ <entry>0</entry>
+ <entry>2</entry>
+ <entry>N</entry>
+ </row>
+ <row>
+ <entry><literal>DataDir</literal></entry>
+ <entry>string</entry>
+ <entry>N/A</entry>
+ <entry>N/A</entry>
+ <entry>N/A</entry>
+ <entry>Y</entry>
+ </row>
+ <row>
+ <entry><literal>ExecuteOnComputer</literal> — synonym for
+ <literal>HostName</literal> (preferred)</entry>
+ <entry/>
+ <entry/>
+ <entry/>
+ <entry/>
+ <entry/>
+ </row>
+ <row>
+ <entry><literal>HostName</literal></entry>
+ <entry>string</entry>
+ <entry><literal>localhost</literal></entry>
+ <entry>N/A</entry>
+ <entry>N/A</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>Id</literal></entry>
+ <entry>integer</entry>
+ <entry><emphasis>None</emphasis></entry>
+ <entry>1</entry>
+ <entry>63</entry>
+ <entry>N</entry>
+ </row>
+ <row>
+ <entry><literal>LogDestination</literal></entry>
+ <entry><literal>CONSOLE</literal>, <literal>SYSLOG</literal>, or
+ <literal>FILE</literal></entry>
+ <entry>See <xref linkend="mysql-cluster-mgm-definition"/>.</entry>
+ <entry>N/A</entry>
+ <entry>N/A</entry>
+ <entry>Y</entry>
+ </row>
+ </tbody>
+ </tgroup>
+ </informaltable>
+
+ </section>
+
+ <section id="mysql-cluster-config-params-api">
+
+ <title>&title-mysql-cluster-config-params-api;</title>
+
+ <para>
+ The following table provides information about parameters used
+ in the <literal>[API]</literal> sections of a
+ <filename>config.ini</filename> file for configuring MySQL
+ Cluster SQL nodes. For detailed descriptions and other
+ additional information about each of these parameters, see
+ <xref linkend="mysql-cluster-api-definition"/>.
+ </para>
+
+ <para>
+ The <emphasis role="bold">Restart Required</emphasis> column
+ can have one of 3 values, whose meanings are as follows:
+ </para>
+
+ <itemizedlist>
+
+ <listitem>
+ <para>
+ <literal>N</literal>: No restart is required to update the
+ value of the parameter.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>Y</literal>: A simple restart is needed to update
+ the parameter's value.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>I</literal>: An initial restart is necessary for
+ updating the value of the parameter.
+ </para>
+ </listitem>
+
+ </itemizedlist>
+
+ <informaltable width="95*">
+ <tgroup cols="6">
+ <colspec colwidth="30*"/>
+ <colspec colwidth="5*"/>
+ <colspec colwidth="20*"/>
+ <colspec colwidth="20*"/>
+ <colspec colwidth="20*"/>
+ <colspec colwidth="5*"/>
+ <tbody>
+ <row>
+ <entry><emphasis role="bold">Parameter Name</emphasis></entry>
+ <entry><emphasis role="bold">Type/Units</emphasis></entry>
+ <entry><emphasis role="bold">Default Value</emphasis></entry>
+ <entry><emphasis role="bold">Minimum Value</emphasis></entry>
+ <entry><emphasis role="bold">Maximum Value</emphasis></entry>
+ <entry><emphasis role="bold">Restart Required</emphasis></entry>
+ </row>
+ <row>
+ <entry><literal>ArbitrationDelay</literal></entry>
+ <entry>milliseconds</entry>
+ <entry>0</entry>
+ <entry>0</entry>
+ <entry>4294967039</entry>
+ <entry>N</entry>
+ </row>
+ <row>
+ <entry><literal>ArbitrationRank</literal></entry>
+ <entry>integer</entry>
+ <entry>1</entry>
+ <entry>0</entry>
+ <entry>2</entry>
+ <entry>N</entry>
+ </row>
+ <row>
+ <entry><literal>BatchByteSize</literal></entry>
+ <entry>bytes</entry>
+ <entry>32K</entry>
+ <entry>1K</entry>
+ <entry>1M</entry>
+ <entry>N</entry>
+ </row>
+ <row>
+ <entry><literal>BatchSize</literal></entry>
+ <entry>integer</entry>
+ <entry>64</entry>
+ <entry>1</entry>
+ <entry>992</entry>
+ <entry>N</entry>
+ </row>
+ <row>
+ <entry><literal>ExecuteOnComputer</literal> — synonym for
+ <literal>HostName</literal> (preferred)</entry>
+ <entry/>
+ <entry/>
+ <entry/>
+ <entry/>
+ <entry/>
+ </row>
+ <row>
+ <entry><literal>HostName</literal></entry>
+ <entry>string</entry>
+ <entry><literal>localhost</literal></entry>
+ <entry>N/A</entry>
+ <entry>N/A</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>Id</literal></entry>
+ <entry>integer</entry>
+ <entry><emphasis>None</emphasis></entry>
+ <entry>1</entry>
+ <entry>63</entry>
+ <entry>N</entry>
+ </row>
+ <row>
+ <entry><literal>MaxScanBatchSize</literal></entry>
+ <entry>bytes</entry>
+ <entry>256K</entry>
+ <entry>32K</entry>
+ <entry>16M</entry>
+ <entry>N</entry>
+ </row>
+ </tbody>
+ </tgroup>
+ </informaltable>
+
+ </section>
+
+ </section>-->
+
</section>
<section id="mysql-cluster-upgrade-downgrade">
@@ -6951,7 +7832,7 @@
</imageobject>
<textobject>
<phrase lang="en">MySQL Cluster upgrade/downgrade
- compatibility, by MySQL server version</phrase>
+ compatibility, by MySQL server version</phrase>
</textobject>
</mediaobject>
Modified: trunk/refman-5.0/ndbcluster.xml
===================================================================
--- trunk/refman-5.0/ndbcluster.xml 2006-06-04 05:40:02 UTC (rev 2269)
+++ trunk/refman-5.0/ndbcluster.xml 2006-06-04 10:00:42 UTC (rev 2270)
@@ -6405,6 +6405,887 @@
</section>
+ <!--<section id="mysql-cluster-config-params-overview">
+
+ <title>&title-mysql-cluster-config-params-overview;</title>
+
+ <remark role="todo">
+ [js] Uncomment links to other Cluster chapter sections before
+ deployment.
+ </remark>
+
+ <para>
+ The next three sections provide summaries of MySQL Cluster
+ configuration parameters used in the
+ <filename>config.ini</filename> file to govern the cluster's
+ functioning. Each section lists the parameters for one of the
+ Cluster node process types (<command>ndbd</command>,
+ <command>ndb_mgmd</command>, and <command>mysqld</command>), and
+ includes the parameter's type as well as its default, mimimum,
+ and maximum values as applicable. It is also stated whether a
+ restart or initial restart of the cluster is required to change
+ the value of a given configuration parameter.
+ </para>
+
+ <para>
+ Because some of these parameters can be used for configuring
+ more than one type of cluster node, they may appear in more than
+ one of these summaries.
+ </para>
+
+ <para>
+ (Note that <literal>4294967039</literal> — which often
+ appears as a maximum value in these tables — is equal to
+ <literal>2<superscript>32</superscript> −
+ 2<superscript>8</superscript> − 1</literal>.)
+ </para>
+
+ <section id="mysql-cluster-config-params-ndbd">
+
+ <title>&title-mysql-cluster-config-params-ndbd;</title>
+
+ <para>
+ The following table provides information about parameters used
+ in the <literal>[NDBD]</literal> or
+ <literal>[NDB_DEFAULT]</literal> sections of a
+ <filename>config.ini</filename> file for configuring MySQL
+ Cluster data nodes. For detailed descriptions and other
+ additional information about each of these parameters, see
+ <xref linkend="mysql-cluster-db-definition"/>.
+ </para>
+
+ <para>
+ The <emphasis role="bold">Restart Required</emphasis> column
+ can have one of 3 values, whose meanings are as follows:
+ </para>
+
+ <itemizedlist>
+
+ <listitem>
+ <para>
+ <literal>N</literal>: No restart is required to update the
+ value of the parameter.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>Y</literal>: A simple restart is needed to update
+ the parameter's value.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>I</literal>: An initial restart is necessary for
+ updating the value of the parameter.
+ </para>
+ </listitem>
+
+ </itemizedlist>
+
+ <informaltable width="95*">
+ <tgroup cols="6">
+ <colspec colwidth="30*"/>
+ <colspec colwidth="5*"/>
+ <colspec colwidth="20*"/>
+ <colspec colwidth="20*"/>
+ <colspec colwidth="20*"/>
+ <colspec colwidth="5*"/>
+ <tbody>
+ <row>
+ <entry><emphasis role="bold">Parameter Name</emphasis></entry>
+ <entry><emphasis role="bold">Type/Units</emphasis></entry>
+ <entry><emphasis role="bold">Default Value</emphasis></entry>
+ <entry><emphasis role="bold">Minimum Value</emphasis></entry>
+ <entry><emphasis role="bold">Maximum Value</emphasis></entry>
+ <entry><emphasis role="bold">Restart Required</emphasis></entry>
+ </row>
+ <row>
+ <entry><literal>ArbitrationTimeout</literal></entry>
+ <entry>milliseconds</entry>
+ <entry>1000</entry>
+ <entry>10</entry>
+ <entry>4294967039</entry>
+ <entry>?</entry>
+ </row>
+ <row>
+ <entry><literal>BackupDataBufferSize</literal></entry>
+ <entry>bytes</entry>
+ <entry>2M</entry>
+ <entry>0</entry>
+ <entry>4294967039</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>BackupDataDir</literal></entry>
+ <entry>string</entry>
+ <entry><filename><literal>FileSystemPath</literal>/BACKUP</filename></entry>
+ <entry>N/A</entry>
+ <entry>N/A</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>BackupLogBufferSize</literal></entry>
+ <entry>bytes</entry>
+ <entry>2M</entry>
+ <entry>0</entry>
+ <entry>4294967039</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>BackupMemory</literal></entry>
+ <entry>bytes</entry>
+ <entry>4M</entry>
+ <entry>0</entry>
+ <entry>4294967039</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>BackupWriteSize</literal></entry>
+ <entry>bytes</entry>
+ <entry>32K</entry>
+ <entry>2K</entry>
+ <entry>4294967039</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>BatchSizePerLocalScan</literal></entry>
+ <entry>integer</entry>
+ <entry>64</entry>
+ <entry>1</entry>
+ <entry>992</entry>
+ <entry>?</entry>
+ </row>
+ <row>
+ <entry><literal>DataDir</literal></entry>
+ <entry>string</entry>
+ <entry>?</entry>
+ <entry>N/A</entry>
+ <entry>N/A</entry>
+ <entry>N</entry>
+ </row>
+ <row>
+ <entry><literal>DataMemory</literal></entry>
+ <entry>bytes</entry>
+ <entry>80M</entry>
+ <entry>1M</entry>
+ <entry>1024G (subject to available system RAM and size of
+ <literal>IndexMemory</literal>)</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>Diskless</literal></entry>
+ <entry>true|false (<literal>1</literal>|<literal>0</literal>)</entry>
+ <entry>0</entry>
+ <entry>0</entry>
+ <entry>1</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>ExecuteOnComputer</literal> — synonym for
+ <literal>HostName</literal> (preferred)</entry>
+ <entry/>
+ <entry/>
+ <entry/>
+ <entry/>
+ <entry/>
+ </row>
+ <row>
+ <entry><literal>FileSystemPath</literal></entry>
+ <entry>string</entry>
+ <entry>value specified for <literal>DataDir</literal></entry>
+ <entry>N/A</entry>
+ <entry>N/A</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>HeartbeatIntervalDbApi</literal></entry>
+ <entry>milliseconds</entry>
+ <entry>1500</entry>
+ <entry>100</entry>
+ <entry>4294967039</entry>
+ <entry>?</entry>
+ </row>
+ <row>
+ <entry><literal>HeartbeatIntervalDbDb</literal></entry>
+ <entry>milliseconds</entry>
+ <entry>1500</entry>
+ <entry>10</entry>
+ <entry>4294967039</entry>
+ <entry>?</entry>
+ </row>
+ <row>
+ <entry><literal>HostName</literal></entry>
+ <entry>string</entry>
+ <entry><literal>localhost</literal></entry>
+ <entry>N/A</entry>
+ <entry>N/A</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>Id</literal></entry>
+ <entry>integer</entry>
+ <entry><emphasis>None</emphasis></entry>
+ <entry>1</entry>
+ <entry>63</entry>
+ <entry>Y</entry>
+ </row>
+ <row>
+ <entry><literal>IndexMemory</literal></entry>
+ <entry>bytes</entry>
+ <entry>18M</entry>
+ <entry>1M</entry>
+ <entry>1024G (subject to available system RAM and size of
+ <literal>DataMemory</literal>)</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>LockPagesInMainMemory</literal></entry>
+ <entry>true|false (<literal>1</literal>|<literal>0</literal>)</entry>
+ <entry>0</entry>
+ <entry>0</entry>
+ <entry>1</entry>
+ <entry>Y</entry>
+ </row>
+ <row>
+ <entry><literal>LogDestination</literal></entry>
+ <entry><literal>CONSOLE</literal>, <literal>SYSLOG</literal>, or
+ <literal>FILE</literal></entry>
+ <entry>See <xref linkend="mysql-cluster-mgm-definition"/>.</entry>
+ <entry>N/A</entry>
+ <entry>N/A</entry>
+ <entry>Y</entry>
+ </row>
+ <row>
+ <entry><literal>LogLevelCheckpoint</literal></entry>
+ <entry>integer</entry>
+ <entry>0</entry>
+ <entry>0</entry>
+ <entry>15</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>LogLevelConnection</literal></entry>
+ <entry>integer</entry>
+ <entry>0</entry>
+ <entry>0</entry>
+ <entry>15</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>LogLevelError</literal></entry>
+ <entry>integer</entry>
+ <entry>0</entry>
+ <entry>0</entry>
+ <entry>15</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>LogLevelInfo</literal></entry>
+ <entry>integer</entry>
+ <entry>0</entry>
+ <entry>0</entry>
+ <entry>15</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>LogLevelNodeRestart</literal></entry>
+ <entry>integer</entry>
+ <entry>0</entry>
+ <entry>0</entry>
+ <entry>15</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>LogLevelShutdown</literal></entry>
+ <entry>integer</entry>
+ <entry>0</entry>
+ <entry>0</entry>
+ <entry>15</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>LogLevelStartup</literal></entry>
+ <entry>integer</entry>
+ <entry>1</entry>
+ <entry>0</entry>
+ <entry>15</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>LogLevelStatistic</literal></entry>
+ <entry>integer</entry>
+ <entry>0</entry>
+ <entry>0</entry>
+ <entry>15</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>LongMessageBuffer</literal></entry>
+ <entry>bytes</entry>
+ <entry>1M</entry>
+ <entry>512K</entry>
+ <entry>4294967039</entry>
+ <entry>?</entry>
+ </row>
+ <row>
+ <entry><literal>MaxNoOfAttributes</literal></entry>
+ <entry>integer</entry>
+ <entry>1000</entry>
+ <entry>32</entry>
+ <entry>4294967039</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>MaxNoOfConcurrentIndexOperations</literal></entry>
+ <entry>integer</entry>
+ <entry>?</entry>
+ <entry>0</entry>
+ <entry>4294967039</entry>
+ <entry>?</entry>
+ </row>
+ <row>
+ <entry><literal>MaxNoOfConcurrentOperations</literal></entry>
+ <entry>integer</entry>
+ <entry>32768</entry>
+ <entry>32</entry>
+ <entry>4294967039</entry>
+ <entry>?</entry>
+ </row>
+ <row>
+ <entry><literal>MaxNoOfConcurrentScans</literal></entry>
+ <entry>integer</entry>
+ <entry>256</entry>
+ <entry>2</entry>
+ <entry>500</entry>
+ <entry>?</entry>
+ </row>
+ <row>
+ <entry><literal>MaxNoOfConcurrentTransactions</literal></entry>
+ <entry>integer</entry>
+ <entry>4096</entry>
+ <entry>32</entry>
+ <entry>4294967039</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>MaxNoOfFiredTriggers</literal></entry>
+ <entry>integer</entry>
+ <entry>?</entry>
+ <entry>0</entry>
+ <entry>4294967039</entry>
+ <entry>?</entry>
+ </row>
+ <row>
+ <entry><literal>MaxNoOfIndexes</literal> (<emphasis>DEPRECATED</emphasis>
+ — use <literal>MaxNoOfOrderedIndexes</literal>
+ or <literal>MaxNoOfUniqueHashIndexes</literal>
+ instead)</entry>
+ <entry>integer</entry>
+ <entry>128</entry>
+ <entry>0</entry>
+ <entry>4294967039</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>MaxNoOfLocalOperations</literal></entry>
+ <entry>integer</entry>
+ <entry>?</entry>
+ <entry>32</entry>
+ <entry>4294967039</entry>
+ <entry>?</entry>
+ </row>
+ <row>
+ <entry><literal>MaxNoOfLocalScans</literal></entry>
+ <entry>integer</entry>
+ <entry>?</entry>
+ <entry>32</entry>
+ <entry>4294967039</entry>
+ <entry>?</entry>
+ </row>
+ <row>
+ <entry><literal>MaxNoOfOrderedIndexes</literal></entry>
+ <entry>integer</entry>
+ <entry>128</entry>
+ <entry>0</entry>
+ <entry>4294967039</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>MaxNoOfSavedMessages</literal></entry>
+ <entry>integer</entry>
+ <entry>25</entry>
+ <entry>0</entry>
+ <entry>4294967039</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>MaxNoOfTables</literal></entry>
+ <entry>integer</entry>
+ <entry>128</entry>
+ <entry>8</entry>
+ <entry>4294967039</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>MaxNoOfTriggers</literal></entry>
+ <entry>integer</entry>
+ <entry>768</entry>
+ <entry>0</entry>
+ <entry>4294967039</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>MaxNoOfUniqueHashIndexes</literal></entry>
+ <entry>integer</entry>
+ <entry>64</entry>
+ <entry>0</entry>
+ <entry>4294967039</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>NoOfDiskPagesToDiskAfterRestartACC</literal></entry>
+ <entry>integer (number of 8KB pages per 100 milliseconds)</entry>
+ <entry>20 (= 20 * 80KB = 1.6MB/second)</entry>
+ <entry>1</entry>
+ <entry>4294967039</entry>
+ <entry>?</entry>
+ </row>
+ <row>
+ <entry><literal>NoOfDiskPagesToDiskAfterRestartTUP</literal></entry>
+ <entry>integer (number of 8KB pages per 100 milliseconds)</entry>
+ <entry>40 (= 40 * 80KB = 3.2MB/second)</entry>
+ <entry>1</entry>
+ <entry>4294967039</entry>
+ <entry>?</entry>
+ </row>
+ <row>
+ <entry><literal>NoOfDiskPagesToDiskDuringRestartACC</literal></entry>
+ <entry>integer (number of 8KB pages per 100 milliseconds)</entry>
+ <entry>20 (= 20 * 80KB = 1.6MB/second)</entry>
+ <entry>1</entry>
+ <entry>4294967039</entry>
+ <entry>?</entry>
+ </row>
+ <row>
+ <entry><literal>NoOfDiskPagesToDiskDuringRestartTUP</literal></entry>
+ <entry>integer (number of 8KB pages per 100 milliseconds)</entry>
+ <entry>40 (= 40 * 80KB = 3.2MB/second)</entry>
+ <entry>1</entry>
+ <entry>4294967039</entry>
+ <entry>?</entry>
+ </row>
+ <row>
+ <entry><literal>NoOfFragmentLogFiles</literal></entry>
+ <entry>integer</entry>
+ <entry>8</entry>
+ <entry>1</entry>
+ <entry>4294967039</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>NoOfReplicas</literal></entry>
+ <entry>integer</entry>
+ <entry><emphasis>None</emphasis></entry>
+ <entry>1</entry>
+ <entry>4</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>PortNumber</literal></entry>
+ <entry>integer</entry>
+ <entry>1186</entry>
+ <entry>0</entry>
+ <entry>4294967039</entry>
+ <entry>N</entry>
+ </row>
+ <row>
+ <entry><literal>RedoBuffer</literal></entry>
+ <entry>bytes</entry>
+ <entry>8M</entry>
+ <entry>1M</entry>
+ <entry>4294967039</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>RestartOnErrorInsert</literal> (<emphasis>DEBUG BUILDS
+ ONLY</emphasis>)</entry>
+ <entry>true|false (<literal>1</literal>|<literal>0</literal>)</entry>
+ <entry>0</entry>
+ <entry>0</entry>
+ <entry>1</entry>
+ <entry>Y</entry>
+ </row>
+ <row>
+ <entry><literal>StartFailureTimeout</literal></entry>
+ <entry>milliseconds</entry>
+ <entry>60000</entry>
+ <entry>0</entry>
+ <entry>4294967039</entry>
+ <entry>?</entry>
+ </row>
+ <row>
+ <entry><literal>StartPartialTimeout</literal></entry>
+ <entry>milliseconds</entry>
+ <entry>30000</entry>
+ <entry>0</entry>
+ <entry>4294967039</entry>
+ <entry>?</entry>
+ </row>
+ <row>
+ <entry><literal>StartPartitionedTimeout</literal></entry>
+ <entry>milliseconds</entry>
+ <entry>60000</entry>
+ <entry>0</entry>
+ <entry>4294967039</entry>
+ <entry>?</entry>
+ </row>
+ <row>
+ <entry><literal>StopOnError</literal></entry>
+ <entry>true|false (<literal>1</literal>|<literal>0</literal>)</entry>
+ <entry>1</entry>
+ <entry>0</entry>
+ <entry>1</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>TimeBetweenGlobalCheckpoints</literal></entry>
+ <entry>milliseconds</entry>
+ <entry>2000</entry>
+ <entry>10</entry>
+ <entry>32000</entry>
+ <entry>?</entry>
+ </row>
+ <row>
+ <entry><literal>TimeBetweenInactiveTransactionAbortCheck</literal></entry>
+ <entry>milliseconds</entry>
+ <entry>1000</entry>
+ <entry>1000</entry>
+ <entry>4294967039</entry>
+ <entry>?</entry>
+ </row>
+ <row>
+ <entry><literal>TimeBetweenLocalCheckpoints</literal></entry>
+ <entry>integer (number of 4-byte words as a base-2 logarithm)</entry>
+ <entry>20 (= <literal>4 * 2<superscript>20</superscript></literal> = 4MB write
+ operations)</entry>
+ <entry>0</entry>
+ <entry>31</entry>
+ <entry>?</entry>
+ </row>
+ <row>
+ <entry><literal>TimeBetweenWatchDogCheck</literal></entry>
+ <entry>milliseconds</entry>
+ <entry>4000</entry>
+ <entry>70</entry>
+ <entry>4294967039</entry>
+ <entry>?</entry>
+ </row>
+ <row>
+ <entry><literal>TransactionBufferMemory</literal></entry>
+ <entry>bytes</entry>
+ <entry>?</entry>
+ <entry>1K</entry>
+ <entry>4294967039</entry>
+ <entry>?</entry>
+ </row>
+ <row>
+ <entry><literal>TransactionDeadlockDetectionTimeout</literal></entry>
+ <entry>milliseconds</entry>
+ <entry>1200</entry>
+ <entry>50</entry>
+ <entry>4294967039</entry>
+ <entry>?</entry>
+ </row>
+ <row>
+ <entry><literal>TransactionInactiveTimeout</literal></entry>
+ <entry>milliseconds</entry>
+ <entry>0</entry>
+ <entry>0</entry>
+ <entry>4294967039</entry>
+ <entry>?</entry>
+ </row>
+ <row>
+ <entry><literal>UndoDataBuffer</literal></entry>
+ <entry>bytes</entry>
+ <entry>16M</entry>
+ <entry>1M</entry>
+ <entry>4294967039</entry>
+ <entry>?</entry>
+ </row>
+ <row>
+ <entry><literal>UndoIndexBuffer</literal></entry>
+ <entry>bytes</entry>
+ <entry>2M</entry>
+ <entry>1M</entry>
+ <entry>4294967039</entry>
+ <entry>?</entry>
+ </row>
+ </tbody>
+ </tgroup>
+ </informaltable>
+
+ </section>
+
+ <section id="mysql-cluster-config-params-mgm">
+
+ <title>&title-mysql-cluster-config-params-mgm;</title>
+
+ <para>
+ The following table provides information about parameters used
+ in the <literal>[NDB_MGMD]</literal> or
+ <literal>[MGM]</literal> sections of a
+ <filename>config.ini</filename> file for configuring MySQL
+ Cluster management nodes. For detailed descriptions and other
+ additional information about each of these parameters, see
+ <xref linkend="mysql-cluster-mgm-definition"/>.
+ </para>
+
+ <para>
+ The <emphasis role="bold">Restart Required</emphasis> column
+ can have one of 3 values, whose meanings are as follows:
+ </para>
+
+ <itemizedlist>
+
+ <listitem>
+ <para>
+ <literal>N</literal>: No restart is required to update the
+ value of the parameter.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>Y</literal>: A simple restart is needed to update
+ the parameter's value.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>I</literal>: An initial restart is necessary for
+ updating the value of the parameter.
+ </para>
+ </listitem>
+
+ </itemizedlist>
+
+ <informaltable width="95*">
+ <tgroup cols="6">
+ <colspec colwidth="30*"/>
+ <colspec colwidth="5*"/>
+ <colspec colwidth="20*"/>
+ <colspec colwidth="20*"/>
+ <colspec colwidth="20*"/>
+ <colspec colwidth="5*"/>
+ <tbody>
+ <row>
+ <entry><emphasis role="bold">Parameter Name</emphasis></entry>
+ <entry><emphasis role="bold">Type/Units</emphasis></entry>
+ <entry><emphasis role="bold">Default Value</emphasis></entry>
+ <entry><emphasis role="bold">Minimum Value</emphasis></entry>
+ <entry><emphasis role="bold">Maximum Value</emphasis></entry>
+ <entry><emphasis role="bold">Restart Required</emphasis></entry>
+ </row>
+ <row>
+ <entry><literal>ArbitrationDelay</literal></entry>
+ <entry>milliseconds</entry>
+ <entry>0</entry>
+ <entry>0</entry>
+ <entry>4294967039</entry>
+ <entry>N</entry>
+ </row>
+ <row>
+ <entry><literal>ArbitrationRank</literal></entry>
+ <entry>integer</entry>
+ <entry>1</entry>
+ <entry>0</entry>
+ <entry>2</entry>
+ <entry>N</entry>
+ </row>
+ <row>
+ <entry><literal>DataDir</literal></entry>
+ <entry>string</entry>
+ <entry>N/A</entry>
+ <entry>N/A</entry>
+ <entry>N/A</entry>
+ <entry>Y</entry>
+ </row>
+ <row>
+ <entry><literal>ExecuteOnComputer</literal> — synonym for
+ <literal>HostName</literal> (preferred)</entry>
+ <entry/>
+ <entry/>
+ <entry/>
+ <entry/>
+ <entry/>
+ </row>
+ <row>
+ <entry><literal>HostName</literal></entry>
+ <entry>string</entry>
+ <entry><literal>localhost</literal></entry>
+ <entry>N/A</entry>
+ <entry>N/A</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>Id</literal></entry>
+ <entry>integer</entry>
+ <entry><emphasis>None</emphasis></entry>
+ <entry>1</entry>
+ <entry>63</entry>
+ <entry>N</entry>
+ </row>
+ <row>
+ <entry><literal>LogDestination</literal></entry>
+ <entry><literal>CONSOLE</literal>, <literal>SYSLOG</literal>, or
+ <literal>FILE</literal></entry>
+ <entry>See <xref linkend="mysql-cluster-mgm-definition"/>.</entry>
+ <entry>N/A</entry>
+ <entry>N/A</entry>
+ <entry>Y</entry>
+ </row>
+ </tbody>
+ </tgroup>
+ </informaltable>
+
+ </section>
+
+ <section id="mysql-cluster-config-params-api">
+
+ <title>&title-mysql-cluster-config-params-api;</title>
+
+ <para>
+ The following table provides information about parameters used
+ in the <literal>[API]</literal> sections of a
+ <filename>config.ini</filename> file for configuring MySQL
+ Cluster SQL nodes. For detailed descriptions and other
+ additional information about each of these parameters, see
+ <xref linkend="mysql-cluster-api-definition"/>.
+ </para>
+
+ <para>
+ The <emphasis role="bold">Restart Required</emphasis> column
+ can have one of 3 values, whose meanings are as follows:
+ </para>
+
+ <itemizedlist>
+
+ <listitem>
+ <para>
+ <literal>N</literal>: No restart is required to update the
+ value of the parameter.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>Y</literal>: A simple restart is needed to update
+ the parameter's value.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>I</literal>: An initial restart is necessary for
+ updating the value of the parameter.
+ </para>
+ </listitem>
+
+ </itemizedlist>
+
+ <informaltable width="95*">
+ <tgroup cols="6">
+ <colspec colwidth="30*"/>
+ <colspec colwidth="5*"/>
+ <colspec colwidth="20*"/>
+ <colspec colwidth="20*"/>
+ <colspec colwidth="20*"/>
+ <colspec colwidth="5*"/>
+ <tbody>
+ <row>
+ <entry><emphasis role="bold">Parameter Name</emphasis></entry>
+ <entry><emphasis role="bold">Type/Units</emphasis></entry>
+ <entry><emphasis role="bold">Default Value</emphasis></entry>
+ <entry><emphasis role="bold">Minimum Value</emphasis></entry>
+ <entry><emphasis role="bold">Maximum Value</emphasis></entry>
+ <entry><emphasis role="bold">Restart Required</emphasis></entry>
+ </row>
+ <row>
+ <entry><literal>ArbitrationDelay</literal></entry>
+ <entry>milliseconds</entry>
+ <entry>0</entry>
+ <entry>0</entry>
+ <entry>4294967039</entry>
+ <entry>N</entry>
+ </row>
+ <row>
+ <entry><literal>ArbitrationRank</literal></entry>
+ <entry>integer</entry>
+ <entry>1</entry>
+ <entry>0</entry>
+ <entry>2</entry>
+ <entry>N</entry>
+ </row>
+ <row>
+ <entry><literal>BatchByteSize</literal></entry>
+ <entry>bytes</entry>
+ <entry>32K</entry>
+ <entry>1K</entry>
+ <entry>1M</entry>
+ <entry>N</entry>
+ </row>
+ <row>
+ <entry><literal>BatchSize</literal></entry>
+ <entry>integer</entry>
+ <entry>64</entry>
+ <entry>1</entry>
+ <entry>992</entry>
+ <entry>N</entry>
+ </row>
+ <row>
+ <entry><literal>ExecuteOnComputer</literal> — synonym for
+ <literal>HostName</literal> (preferred)</entry>
+ <entry/>
+ <entry/>
+ <entry/>
+ <entry/>
+ <entry/>
+ </row>
+ <row>
+ <entry><literal>HostName</literal></entry>
+ <entry>string</entry>
+ <entry><literal>localhost</literal></entry>
+ <entry>N/A</entry>
+ <entry>N/A</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>Id</literal></entry>
+ <entry>integer</entry>
+ <entry><emphasis>None</emphasis></entry>
+ <entry>1</entry>
+ <entry>63</entry>
+ <entry>N</entry>
+ </row>
+ <row>
+ <entry><literal>MaxScanBatchSize</literal></entry>
+ <entry>bytes</entry>
+ <entry>256K</entry>
+ <entry>32K</entry>
+ <entry>16M</entry>
+ <entry>N</entry>
+ </row>
+ </tbody>
+ </tgroup>
+ </informaltable>
+
+ </section>
+
+ </section>-->
+
</section>
<section id="mysql-cluster-upgrade-downgrade">
@@ -6939,14 +7820,14 @@
The following table shows Cluster upgrade and downgrade
compatibility between different versions of the MySQL Server.
</para>
-
+
<mediaobject>
<imageobject>
<imagedata fileref="images/cluster-upgrade-downgrade-table.png" format="PNG"/>
</imageobject>
<textobject>
<phrase lang="en">MySQL Cluster upgrade/downgrade
- compatibility, by MySQL server version</phrase>
+ compatibility, by MySQL server version</phrase>
</textobject>
</mediaobject>
Modified: trunk/refman-5.1/ndbcluster.xml
===================================================================
--- trunk/refman-5.1/ndbcluster.xml 2006-06-04 05:40:02 UTC (rev 2269)
+++ trunk/refman-5.1/ndbcluster.xml 2006-06-04 10:00:42 UTC (rev 2270)
@@ -6410,6 +6410,887 @@
</section>
+ <!--<section id="mysql-cluster-config-params-overview">
+
+ <title>&title-mysql-cluster-config-params-overview;</title>
+
+ <remark role="todo">
+ [js] Uncomment links to other Cluster chapter sections before
+ deployment.
+ </remark>
+
+ <para>
+ The next three sections provide summaries of MySQL Cluster
+ configuration parameters used in the
+ <filename>config.ini</filename> file to govern the cluster's
+ functioning. Each section lists the parameters for one of the
+ Cluster node process types (<command>ndbd</command>,
+ <command>ndb_mgmd</command>, and <command>mysqld</command>), and
+ includes the parameter's type as well as its default, mimimum,
+ and maximum values as applicable. It is also stated whether a
+ restart or initial restart of the cluster is required to change
+ the value of a given configuration parameter.
+ </para>
+
+ <para>
+ Because some of these parameters can be used for configuring
+ more than one type of cluster node, they may appear in more than
+ one of these summaries.
+ </para>
+
+ <para>
+ (Note that <literal>4294967039</literal> — which often
+ appears as a maximum value in these tables — is equal to
+ <literal>2<superscript>32</superscript> −
+ 2<superscript>8</superscript> − 1</literal>.)
+ </para>
+
+ <section id="mysql-cluster-config-params-ndbd">
+
+ <title>&title-mysql-cluster-config-params-ndbd;</title>
+
+ <para>
+ The following table provides information about parameters used
+ in the <literal>[NDBD]</literal> or
+ <literal>[NDB_DEFAULT]</literal> sections of a
+ <filename>config.ini</filename> file for configuring MySQL
+ Cluster data nodes. For detailed descriptions and other
+ additional information about each of these parameters, see
+ <xref linkend="mysql-cluster-db-definition"/>.
+ </para>
+
+ <para>
+ The <emphasis role="bold">Restart Required</emphasis> column
+ can have one of 3 values, whose meanings are as follows:
+ </para>
+
+ <itemizedlist>
+
+ <listitem>
+ <para>
+ <literal>N</literal>: No restart is required to update the
+ value of the parameter.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>Y</literal>: A simple restart is needed to update
+ the parameter's value.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>I</literal>: An initial restart is necessary for
+ updating the value of the parameter.
+ </para>
+ </listitem>
+
+ </itemizedlist>
+
+ <informaltable width="95*">
+ <tgroup cols="6">
+ <colspec colwidth="30*"/>
+ <colspec colwidth="5*"/>
+ <colspec colwidth="20*"/>
+ <colspec colwidth="20*"/>
+ <colspec colwidth="20*"/>
+ <colspec colwidth="5*"/>
+ <tbody>
+ <row>
+ <entry><emphasis role="bold">Parameter Name</emphasis></entry>
+ <entry><emphasis role="bold">Type/Units</emphasis></entry>
+ <entry><emphasis role="bold">Default Value</emphasis></entry>
+ <entry><emphasis role="bold">Minimum Value</emphasis></entry>
+ <entry><emphasis role="bold">Maximum Value</emphasis></entry>
+ <entry><emphasis role="bold">Restart Required</emphasis></entry>
+ </row>
+ <row>
+ <entry><literal>ArbitrationTimeout</literal></entry>
+ <entry>milliseconds</entry>
+ <entry>1000</entry>
+ <entry>10</entry>
+ <entry>4294967039</entry>
+ <entry>?</entry>
+ </row>
+ <row>
+ <entry><literal>BackupDataBufferSize</literal></entry>
+ <entry>bytes</entry>
+ <entry>2M</entry>
+ <entry>0</entry>
+ <entry>4294967039</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>BackupDataDir</literal></entry>
+ <entry>string</entry>
+ <entry><filename><literal>FileSystemPath</literal>/BACKUP</filename></entry>
+ <entry>N/A</entry>
+ <entry>N/A</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>BackupLogBufferSize</literal></entry>
+ <entry>bytes</entry>
+ <entry>2M</entry>
+ <entry>0</entry>
+ <entry>4294967039</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>BackupMemory</literal></entry>
+ <entry>bytes</entry>
+ <entry>4M</entry>
+ <entry>0</entry>
+ <entry>4294967039</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>BackupWriteSize</literal></entry>
+ <entry>bytes</entry>
+ <entry>32K</entry>
+ <entry>2K</entry>
+ <entry>4294967039</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>BatchSizePerLocalScan</literal></entry>
+ <entry>integer</entry>
+ <entry>64</entry>
+ <entry>1</entry>
+ <entry>992</entry>
+ <entry>?</entry>
+ </row>
+ <row>
+ <entry><literal>DataDir</literal></entry>
+ <entry>string</entry>
+ <entry>?</entry>
+ <entry>N/A</entry>
+ <entry>N/A</entry>
+ <entry>N</entry>
+ </row>
+ <row>
+ <entry><literal>DataMemory</literal></entry>
+ <entry>bytes</entry>
+ <entry>80M</entry>
+ <entry>1M</entry>
+ <entry>1024G (subject to available system RAM and size of
+ <literal>IndexMemory</literal>)</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>Diskless</literal></entry>
+ <entry>true|false (<literal>1</literal>|<literal>0</literal>)</entry>
+ <entry>0</entry>
+ <entry>0</entry>
+ <entry>1</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>ExecuteOnComputer</literal> — synonym for
+ <literal>HostName</literal> (preferred)</entry>
+ <entry/>
+ <entry/>
+ <entry/>
+ <entry/>
+ <entry/>
+ </row>
+ <row>
+ <entry><literal>FileSystemPath</literal></entry>
+ <entry>string</entry>
+ <entry>value specified for <literal>DataDir</literal></entry>
+ <entry>N/A</entry>
+ <entry>N/A</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>HeartbeatIntervalDbApi</literal></entry>
+ <entry>milliseconds</entry>
+ <entry>1500</entry>
+ <entry>100</entry>
+ <entry>4294967039</entry>
+ <entry>?</entry>
+ </row>
+ <row>
+ <entry><literal>HeartbeatIntervalDbDb</literal></entry>
+ <entry>milliseconds</entry>
+ <entry>1500</entry>
+ <entry>10</entry>
+ <entry>4294967039</entry>
+ <entry>?</entry>
+ </row>
+ <row>
+ <entry><literal>HostName</literal></entry>
+ <entry>string</entry>
+ <entry><literal>localhost</literal></entry>
+ <entry>N/A</entry>
+ <entry>N/A</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>Id</literal></entry>
+ <entry>integer</entry>
+ <entry><emphasis>None</emphasis></entry>
+ <entry>1</entry>
+ <entry>63</entry>
+ <entry>Y</entry>
+ </row>
+ <row>
+ <entry><literal>IndexMemory</literal></entry>
+ <entry>bytes</entry>
+ <entry>18M</entry>
+ <entry>1M</entry>
+ <entry>1024G (subject to available system RAM and size of
+ <literal>DataMemory</literal>)</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>LockPagesInMainMemory</literal></entry>
+ <entry>true|false (<literal>1</literal>|<literal>0</literal>)</entry>
+ <entry>0</entry>
+ <entry>0</entry>
+ <entry>1</entry>
+ <entry>Y</entry>
+ </row>
+ <row>
+ <entry><literal>LogDestination</literal></entry>
+ <entry><literal>CONSOLE</literal>, <literal>SYSLOG</literal>, or
+ <literal>FILE</literal></entry>
+ <entry>See <xref linkend="mysql-cluster-mgm-definition"/>.</entry>
+ <entry>N/A</entry>
+ <entry>N/A</entry>
+ <entry>Y</entry>
+ </row>
+ <row>
+ <entry><literal>LogLevelCheckpoint</literal></entry>
+ <entry>integer</entry>
+ <entry>0</entry>
+ <entry>0</entry>
+ <entry>15</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>LogLevelConnection</literal></entry>
+ <entry>integer</entry>
+ <entry>0</entry>
+ <entry>0</entry>
+ <entry>15</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>LogLevelError</literal></entry>
+ <entry>integer</entry>
+ <entry>0</entry>
+ <entry>0</entry>
+ <entry>15</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>LogLevelInfo</literal></entry>
+ <entry>integer</entry>
+ <entry>0</entry>
+ <entry>0</entry>
+ <entry>15</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>LogLevelNodeRestart</literal></entry>
+ <entry>integer</entry>
+ <entry>0</entry>
+ <entry>0</entry>
+ <entry>15</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>LogLevelShutdown</literal></entry>
+ <entry>integer</entry>
+ <entry>0</entry>
+ <entry>0</entry>
+ <entry>15</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>LogLevelStartup</literal></entry>
+ <entry>integer</entry>
+ <entry>1</entry>
+ <entry>0</entry>
+ <entry>15</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>LogLevelStatistic</literal></entry>
+ <entry>integer</entry>
+ <entry>0</entry>
+ <entry>0</entry>
+ <entry>15</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>LongMessageBuffer</literal></entry>
+ <entry>bytes</entry>
+ <entry>1M</entry>
+ <entry>512K</entry>
+ <entry>4294967039</entry>
+ <entry>?</entry>
+ </row>
+ <row>
+ <entry><literal>MaxNoOfAttributes</literal></entry>
+ <entry>integer</entry>
+ <entry>1000</entry>
+ <entry>32</entry>
+ <entry>4294967039</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>MaxNoOfConcurrentIndexOperations</literal></entry>
+ <entry>integer</entry>
+ <entry>?</entry>
+ <entry>0</entry>
+ <entry>4294967039</entry>
+ <entry>?</entry>
+ </row>
+ <row>
+ <entry><literal>MaxNoOfConcurrentOperations</literal></entry>
+ <entry>integer</entry>
+ <entry>32768</entry>
+ <entry>32</entry>
+ <entry>4294967039</entry>
+ <entry>?</entry>
+ </row>
+ <row>
+ <entry><literal>MaxNoOfConcurrentScans</literal></entry>
+ <entry>integer</entry>
+ <entry>256</entry>
+ <entry>2</entry>
+ <entry>500</entry>
+ <entry>?</entry>
+ </row>
+ <row>
+ <entry><literal>MaxNoOfConcurrentTransactions</literal></entry>
+ <entry>integer</entry>
+ <entry>4096</entry>
+ <entry>32</entry>
+ <entry>4294967039</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>MaxNoOfFiredTriggers</literal></entry>
+ <entry>integer</entry>
+ <entry>?</entry>
+ <entry>0</entry>
+ <entry>4294967039</entry>
+ <entry>?</entry>
+ </row>
+ <row>
+ <entry><literal>MaxNoOfIndexes</literal> (<emphasis>DEPRECATED</emphasis>
+ — use <literal>MaxNoOfOrderedIndexes</literal>
+ or <literal>MaxNoOfUniqueHashIndexes</literal>
+ instead)</entry>
+ <entry>integer</entry>
+ <entry>128</entry>
+ <entry>0</entry>
+ <entry>4294967039</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>MaxNoOfLocalOperations</literal></entry>
+ <entry>integer</entry>
+ <entry>?</entry>
+ <entry>32</entry>
+ <entry>4294967039</entry>
+ <entry>?</entry>
+ </row>
+ <row>
+ <entry><literal>MaxNoOfLocalScans</literal></entry>
+ <entry>integer</entry>
+ <entry>?</entry>
+ <entry>32</entry>
+ <entry>4294967039</entry>
+ <entry>?</entry>
+ </row>
+ <row>
+ <entry><literal>MaxNoOfOrderedIndexes</literal></entry>
+ <entry>integer</entry>
+ <entry>128</entry>
+ <entry>0</entry>
+ <entry>4294967039</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>MaxNoOfSavedMessages</literal></entry>
+ <entry>integer</entry>
+ <entry>25</entry>
+ <entry>0</entry>
+ <entry>4294967039</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>MaxNoOfTables</literal></entry>
+ <entry>integer</entry>
+ <entry>128</entry>
+ <entry>8</entry>
+ <entry>4294967039</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>MaxNoOfTriggers</literal></entry>
+ <entry>integer</entry>
+ <entry>768</entry>
+ <entry>0</entry>
+ <entry>4294967039</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>MaxNoOfUniqueHashIndexes</literal></entry>
+ <entry>integer</entry>
+ <entry>64</entry>
+ <entry>0</entry>
+ <entry>4294967039</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>NoOfDiskPagesToDiskAfterRestartACC</literal></entry>
+ <entry>integer (number of 8KB pages per 100 milliseconds)</entry>
+ <entry>20 (= 20 * 80KB = 1.6MB/second)</entry>
+ <entry>1</entry>
+ <entry>4294967039</entry>
+ <entry>?</entry>
+ </row>
+ <row>
+ <entry><literal>NoOfDiskPagesToDiskAfterRestartTUP</literal></entry>
+ <entry>integer (number of 8KB pages per 100 milliseconds)</entry>
+ <entry>40 (= 40 * 80KB = 3.2MB/second)</entry>
+ <entry>1</entry>
+ <entry>4294967039</entry>
+ <entry>?</entry>
+ </row>
+ <row>
+ <entry><literal>NoOfDiskPagesToDiskDuringRestartACC</literal></entry>
+ <entry>integer (number of 8KB pages per 100 milliseconds)</entry>
+ <entry>20 (= 20 * 80KB = 1.6MB/second)</entry>
+ <entry>1</entry>
+ <entry>4294967039</entry>
+ <entry>?</entry>
+ </row>
+ <row>
+ <entry><literal>NoOfDiskPagesToDiskDuringRestartTUP</literal></entry>
+ <entry>integer (number of 8KB pages per 100 milliseconds)</entry>
+ <entry>40 (= 40 * 80KB = 3.2MB/second)</entry>
+ <entry>1</entry>
+ <entry>4294967039</entry>
+ <entry>?</entry>
+ </row>
+ <row>
+ <entry><literal>NoOfFragmentLogFiles</literal></entry>
+ <entry>integer</entry>
+ <entry>8</entry>
+ <entry>1</entry>
+ <entry>4294967039</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>NoOfReplicas</literal></entry>
+ <entry>integer</entry>
+ <entry><emphasis>None</emphasis></entry>
+ <entry>1</entry>
+ <entry>4</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>PortNumber</literal></entry>
+ <entry>integer</entry>
+ <entry>1186</entry>
+ <entry>0</entry>
+ <entry>4294967039</entry>
+ <entry>N</entry>
+ </row>
+ <row>
+ <entry><literal>RedoBuffer</literal></entry>
+ <entry>bytes</entry>
+ <entry>8M</entry>
+ <entry>1M</entry>
+ <entry>4294967039</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>RestartOnErrorInsert</literal> (<emphasis>DEBUG BUILDS
+ ONLY</emphasis>)</entry>
+ <entry>true|false (<literal>1</literal>|<literal>0</literal>)</entry>
+ <entry>0</entry>
+ <entry>0</entry>
+ <entry>1</entry>
+ <entry>Y</entry>
+ </row>
+ <row>
+ <entry><literal>StartFailureTimeout</literal></entry>
+ <entry>milliseconds</entry>
+ <entry>60000</entry>
+ <entry>0</entry>
+ <entry>4294967039</entry>
+ <entry>?</entry>
+ </row>
+ <row>
+ <entry><literal>StartPartialTimeout</literal></entry>
+ <entry>milliseconds</entry>
+ <entry>30000</entry>
+ <entry>0</entry>
+ <entry>4294967039</entry>
+ <entry>?</entry>
+ </row>
+ <row>
+ <entry><literal>StartPartitionedTimeout</literal></entry>
+ <entry>milliseconds</entry>
+ <entry>60000</entry>
+ <entry>0</entry>
+ <entry>4294967039</entry>
+ <entry>?</entry>
+ </row>
+ <row>
+ <entry><literal>StopOnError</literal></entry>
+ <entry>true|false (<literal>1</literal>|<literal>0</literal>)</entry>
+ <entry>1</entry>
+ <entry>0</entry>
+ <entry>1</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>TimeBetweenGlobalCheckpoints</literal></entry>
+ <entry>milliseconds</entry>
+ <entry>2000</entry>
+ <entry>10</entry>
+ <entry>32000</entry>
+ <entry>?</entry>
+ </row>
+ <row>
+ <entry><literal>TimeBetweenInactiveTransactionAbortCheck</literal></entry>
+ <entry>milliseconds</entry>
+ <entry>1000</entry>
+ <entry>1000</entry>
+ <entry>4294967039</entry>
+ <entry>?</entry>
+ </row>
+ <row>
+ <entry><literal>TimeBetweenLocalCheckpoints</literal></entry>
+ <entry>integer (number of 4-byte words as a base-2 logarithm)</entry>
+ <entry>20 (= <literal>4 * 2<superscript>20</superscript></literal> = 4MB write
+ operations)</entry>
+ <entry>0</entry>
+ <entry>31</entry>
+ <entry>?</entry>
+ </row>
+ <row>
+ <entry><literal>TimeBetweenWatchDogCheck</literal></entry>
+ <entry>milliseconds</entry>
+ <entry>4000</entry>
+ <entry>70</entry>
+ <entry>4294967039</entry>
+ <entry>?</entry>
+ </row>
+ <row>
+ <entry><literal>TransactionBufferMemory</literal></entry>
+ <entry>bytes</entry>
+ <entry>?</entry>
+ <entry>1K</entry>
+ <entry>4294967039</entry>
+ <entry>?</entry>
+ </row>
+ <row>
+ <entry><literal>TransactionDeadlockDetectionTimeout</literal></entry>
+ <entry>milliseconds</entry>
+ <entry>1200</entry>
+ <entry>50</entry>
+ <entry>4294967039</entry>
+ <entry>?</entry>
+ </row>
+ <row>
+ <entry><literal>TransactionInactiveTimeout</literal></entry>
+ <entry>milliseconds</entry>
+ <entry>0</entry>
+ <entry>0</entry>
+ <entry>4294967039</entry>
+ <entry>?</entry>
+ </row>
+ <row>
+ <entry><literal>UndoDataBuffer</literal></entry>
+ <entry>bytes</entry>
+ <entry>16M</entry>
+ <entry>1M</entry>
+ <entry>4294967039</entry>
+ <entry>?</entry>
+ </row>
+ <row>
+ <entry><literal>UndoIndexBuffer</literal></entry>
+ <entry>bytes</entry>
+ <entry>2M</entry>
+ <entry>1M</entry>
+ <entry>4294967039</entry>
+ <entry>?</entry>
+ </row>
+ </tbody>
+ </tgroup>
+ </informaltable>
+
+ </section>
+
+ <section id="mysql-cluster-config-params-mgm">
+
+ <title>&title-mysql-cluster-config-params-mgm;</title>
+
+ <para>
+ The following table provides information about parameters used
+ in the <literal>[NDB_MGMD]</literal> or
+ <literal>[MGM]</literal> sections of a
+ <filename>config.ini</filename> file for configuring MySQL
+ Cluster management nodes. For detailed descriptions and other
+ additional information about each of these parameters, see
+ <xref linkend="mysql-cluster-mgm-definition"/>.
+ </para>
+
+ <para>
+ The <emphasis role="bold">Restart Required</emphasis> column
+ can have one of 3 values, whose meanings are as follows:
+ </para>
+
+ <itemizedlist>
+
+ <listitem>
+ <para>
+ <literal>N</literal>: No restart is required to update the
+ value of the parameter.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>Y</literal>: A simple restart is needed to update
+ the parameter's value.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>I</literal>: An initial restart is necessary for
+ updating the value of the parameter.
+ </para>
+ </listitem>
+
+ </itemizedlist>
+
+ <informaltable width="95*">
+ <tgroup cols="6">
+ <colspec colwidth="30*"/>
+ <colspec colwidth="5*"/>
+ <colspec colwidth="20*"/>
+ <colspec colwidth="20*"/>
+ <colspec colwidth="20*"/>
+ <colspec colwidth="5*"/>
+ <tbody>
+ <row>
+ <entry><emphasis role="bold">Parameter Name</emphasis></entry>
+ <entry><emphasis role="bold">Type/Units</emphasis></entry>
+ <entry><emphasis role="bold">Default Value</emphasis></entry>
+ <entry><emphasis role="bold">Minimum Value</emphasis></entry>
+ <entry><emphasis role="bold">Maximum Value</emphasis></entry>
+ <entry><emphasis role="bold">Restart Required</emphasis></entry>
+ </row>
+ <row>
+ <entry><literal>ArbitrationDelay</literal></entry>
+ <entry>milliseconds</entry>
+ <entry>0</entry>
+ <entry>0</entry>
+ <entry>4294967039</entry>
+ <entry>N</entry>
+ </row>
+ <row>
+ <entry><literal>ArbitrationRank</literal></entry>
+ <entry>integer</entry>
+ <entry>1</entry>
+ <entry>0</entry>
+ <entry>2</entry>
+ <entry>N</entry>
+ </row>
+ <row>
+ <entry><literal>DataDir</literal></entry>
+ <entry>string</entry>
+ <entry>N/A</entry>
+ <entry>N/A</entry>
+ <entry>N/A</entry>
+ <entry>Y</entry>
+ </row>
+ <row>
+ <entry><literal>ExecuteOnComputer</literal> — synonym for
+ <literal>HostName</literal> (preferred)</entry>
+ <entry/>
+ <entry/>
+ <entry/>
+ <entry/>
+ <entry/>
+ </row>
+ <row>
+ <entry><literal>HostName</literal></entry>
+ <entry>string</entry>
+ <entry><literal>localhost</literal></entry>
+ <entry>N/A</entry>
+ <entry>N/A</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>Id</literal></entry>
+ <entry>integer</entry>
+ <entry><emphasis>None</emphasis></entry>
+ <entry>1</entry>
+ <entry>63</entry>
+ <entry>N</entry>
+ </row>
+ <row>
+ <entry><literal>LogDestination</literal></entry>
+ <entry><literal>CONSOLE</literal>, <literal>SYSLOG</literal>, or
+ <literal>FILE</literal></entry>
+ <entry>See <xref linkend="mysql-cluster-mgm-definition"/>.</entry>
+ <entry>N/A</entry>
+ <entry>N/A</entry>
+ <entry>Y</entry>
+ </row>
+ </tbody>
+ </tgroup>
+ </informaltable>
+
+ </section>
+
+ <section id="mysql-cluster-config-params-api">
+
+ <title>&title-mysql-cluster-config-params-api;</title>
+
+ <para>
+ The following table provides information about parameters used
+ in the <literal>[API]</literal> sections of a
+ <filename>config.ini</filename> file for configuring MySQL
+ Cluster SQL nodes. For detailed descriptions and other
+ additional information about each of these parameters, see
+ <xref linkend="mysql-cluster-api-definition"/>.
+ </para>
+
+ <para>
+ The <emphasis role="bold">Restart Required</emphasis> column
+ can have one of 3 values, whose meanings are as follows:
+ </para>
+
+ <itemizedlist>
+
+ <listitem>
+ <para>
+ <literal>N</literal>: No restart is required to update the
+ value of the parameter.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>Y</literal>: A simple restart is needed to update
+ the parameter's value.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>I</literal>: An initial restart is necessary for
+ updating the value of the parameter.
+ </para>
+ </listitem>
+
+ </itemizedlist>
+
+ <informaltable width="95*">
+ <tgroup cols="6">
+ <colspec colwidth="30*"/>
+ <colspec colwidth="5*"/>
+ <colspec colwidth="20*"/>
+ <colspec colwidth="20*"/>
+ <colspec colwidth="20*"/>
+ <colspec colwidth="5*"/>
+ <tbody>
+ <row>
+ <entry><emphasis role="bold">Parameter Name</emphasis></entry>
+ <entry><emphasis role="bold">Type/Units</emphasis></entry>
+ <entry><emphasis role="bold">Default Value</emphasis></entry>
+ <entry><emphasis role="bold">Minimum Value</emphasis></entry>
+ <entry><emphasis role="bold">Maximum Value</emphasis></entry>
+ <entry><emphasis role="bold">Restart Required</emphasis></entry>
+ </row>
+ <row>
+ <entry><literal>ArbitrationDelay</literal></entry>
+ <entry>milliseconds</entry>
+ <entry>0</entry>
+ <entry>0</entry>
+ <entry>4294967039</entry>
+ <entry>N</entry>
+ </row>
+ <row>
+ <entry><literal>ArbitrationRank</literal></entry>
+ <entry>integer</entry>
+ <entry>1</entry>
+ <entry>0</entry>
+ <entry>2</entry>
+ <entry>N</entry>
+ </row>
+ <row>
+ <entry><literal>BatchByteSize</literal></entry>
+ <entry>bytes</entry>
+ <entry>32K</entry>
+ <entry>1K</entry>
+ <entry>1M</entry>
+ <entry>N</entry>
+ </row>
+ <row>
+ <entry><literal>BatchSize</literal></entry>
+ <entry>integer</entry>
+ <entry>64</entry>
+ <entry>1</entry>
+ <entry>992</entry>
+ <entry>N</entry>
+ </row>
+ <row>
+ <entry><literal>ExecuteOnComputer</literal> — synonym for
+ <literal>HostName</literal> (preferred)</entry>
+ <entry/>
+ <entry/>
+ <entry/>
+ <entry/>
+ <entry/>
+ </row>
+ <row>
+ <entry><literal>HostName</literal></entry>
+ <entry>string</entry>
+ <entry><literal>localhost</literal></entry>
+ <entry>N/A</entry>
+ <entry>N/A</entry>
+ <entry>I</entry>
+ </row>
+ <row>
+ <entry><literal>Id</literal></entry>
+ <entry>integer</entry>
+ <entry><emphasis>None</emphasis></entry>
+ <entry>1</entry>
+ <entry>63</entry>
+ <entry>N</entry>
+ </row>
+ <row>
+ <entry><literal>MaxScanBatchSize</literal></entry>
+ <entry>bytes</entry>
+ <entry>256K</entry>
+ <entry>32K</entry>
+ <entry>16M</entry>
+ <entry>N</entry>
+ </row>
+ </tbody>
+ </tgroup>
+ </informaltable>
+
+ </section>
+
+ </section>-->
+
</section>
<section id="mysql-cluster-upgrade-downgrade">
@@ -6951,7 +7832,7 @@
</imageobject>
<textobject>
<phrase lang="en">MySQL Cluster upgrade/downgrade
- compatibility, by MySQL server version</phrase>
+ compatibility, by MySQL server version</phrase>
</textobject>
</mediaobject>
@@ -14019,17 +14900,17 @@
<primary>MySQL Cluster</primary>
<secondary>partitioning support</secondary>
</indexterm>
-
+
<indexterm>
<primary>partitioning</primary>
<secondary>support in MySQL Cluster</secondary>
</indexterm>
-
+
<indexterm>
<primary>MySQL Cluster limitations</primary>
<secondary>partitioning</secondary>
</indexterm>
-
+
<para>
Support for user-defined partitioning for MySQL Cluster in
MySQL ¤t-series; is restricted to
@@ -14050,7 +14931,7 @@
additional discussion of these and related issues, see
<xref linkend="partitioning-key"/>.
</para>
-
+
<para>
It is not possible to drop partitions from
<literal>NDB</literal> tables using <literal>ALTER TABLE
Modified: trunk/refman-common/titles.en.ent
===================================================================
--- trunk/refman-common/titles.en.ent 2006-06-04 05:40:02 UTC (rev 2269)
+++ trunk/refman-common/titles.en.ent 2006-06-04 10:00:42 UTC (rev 2270)
@@ -879,6 +879,10 @@
<!ENTITY title-mysql-cluster-computer-definition "Defining the Computers Making up a MySQL Cluster">
<!ENTITY title-mysql-cluster-config-example "Example Configuration for a MySQL Cluster">
<!ENTITY title-mysql-cluster-config-file "Configuration File">
+<!ENTITY title-mysql-cluster-config-params-overview "Overview of Cluster Configuration Parameters">
+<!ENTITY title-mysql-cluster-config-params-ndbd "Cluster Data Node Configuration Parameters">
+<!ENTITY title-mysql-cluster-config-params-mgm "Cluster Management Node Configuration Parameters">
+<!ENTITY title-mysql-cluster-config-params-api "Cluster SQL Node Configuration Parameters">
<!ENTITY title-mysql-cluster-configuration "MySQL Cluster Configuration">
<!ENTITY title-mysql-cluster-connectstring "The MySQL Cluster <literal>connectstring</literal>">
<!ENTITY title-mysql-cluster-db-definition "Defining MySQL Cluster Data Nodes">
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r2270 - in trunk: refman-4.1 refman-5.0 refman-5.1 refman-common | jon | 4 Jun |
