Oracle 5.0, Справочное руководство

Страница: 1596 / 3232

MySQL Cluster Configuration Files
1576
Effective Version Type/Units Default Range/Values
MySQL 5.0.0 8K pages/100
milliseconds 40 1 - 4G
Restart Type: N
This parameter is used in a fashion similar to
NoOfDiskPagesToDiskAfterRestartTUP
and
NoOfDiskPagesToDiskAfterRestartACC
, only it does so with regard to local checkpoints
executed in the node when a node is restarting. A local checkpoint is always performed as part of
all node restarts. During a node restart it is possible to write to disk at a higher speed than at other
times, because fewer activities are being performed in the node.
This parameter covers pages written from data memory.
The default value is 40 (3.2MB per second).
•
NoOfDiskPagesToDiskDuringRestartACC
Effective Version Type/Units Default Range/Values
MySQL 5.0.0 8K pages/100
milliseconds 20 1 - 4G
Restart Type: N
Controls the number of index memory pages that can be written to disk during the local checkpoint
phase of a node restart.
As with
NoOfDiskPagesToDiskAfterRestartTUP
and
NoOfDiskPagesToDiskAfterRestartACC
, values for this parameter are expressed in terms of
8KB pages written per 100 milliseconds (80KB/second).
The default value is 20 (1.6MB per second).
•
ArbitrationTimeout
Effective Version Type/Units Default Range/Values
MySQL 5.0.0 milliseconds 3000 10 - 4G
Restart Type: N
This parameter specifies how long data nodes wait for a response from the arbitrator to an arbitration
message. If this is exceeded, the network is assumed to have split.
The default value is 1000 milliseconds (1 second).
Buffering and logging. Several
[ndbd]
configuration parameters corresponding to former
compile-time parameters were introduced in MySQL 4.1.5. These enable the advanced user to have
more control over the resources used by node processes and to adjust various buffer sizes at need.
These buffers are used as front ends to the file system when writing log records to disk. If the node is
running in diskless mode, these parameters can be set to their minimum values without penalty due to
the fact that disk writes are “faked” by the
NDB
storage engine's file system abstraction layer.
•
UndoIndexBuffer
Effective Version Type/Units Default Range/Values
MySQL 5.0.0 unsigned 2M 1M - 4G