MySQL Cluster Configuration Files
1575
This timeout parameter states how long the transaction coordinator waits for query execution by
another node before aborting the transaction, and is important for both node failure handling and
deadlock detection. In MySQL 5.0.20 and earlier versions, setting it too high could cause undesirable
behavior in situations involving deadlocks and node failure. Beginning with MySQL 5.0.21, active
transactions occurring during node failures are actively aborted by the MySQL Cluster Transaction
Coordinator, and so high settings are no longer an issue with this parameter.
The default timeout value is 1200 milliseconds (1.2 seconds). The effective minimum value is 100
milliseconds; it is possible to set it as low as 50 milliseconds, but any such value is treated as 100
ms. (Bug #44099)
•
NoOfDiskPagesToDiskAfterRestartTUP
Effective Version
Type/Units
Default
Range/Values
MySQL 5.0.0
8K pages/100
milliseconds
40
1 - 4G
Restart Type: N
When executing a local checkpoint, the algorithm flushes all data pages to disk. Merely doing so
as quickly as possible without any moderation is likely to impose excessive loads on processors,
networks, and disks. To control the write speed, this parameter specifies how many pages per
100 milliseconds are to be written. In this context, a “page” is defined as 8KB. This parameter is
specified in units of 80KB per second, so setting
NoOfDiskPagesToDiskAfterRestartTUP
to
a value of
20
entails writing 1.6MB in data pages to disk each second during a local checkpoint.
This value includes the writing of UNDO log records for data pages. That is, this parameter handles
the limitation of writes from data memory. UNDO log records for index pages are handled by the
parameter
NoOfDiskPagesToDiskAfterRestartACC
. (See the entry for
IndexMemory
for
information about index pages.)
In short, this parameter specifies how quickly to execute local checkpoints. It operates in conjunction
with
NoOfFragmentLogFiles
,
DataMemory
, and
IndexMemory
.
For more information about the interaction between these parameters and possible strategies
for choosing appropriate values for them, see
Section 17.3.2.11, “Configuring MySQL Cluster
Parameters for Local Checkpoints”
.
The default value is 40 (3.2MB of data pages per second).
•
NoOfDiskPagesToDiskAfterRestartACC
Effective Version
Type/Units
Default
Range/Values
MySQL 5.0.0
8K pages/100
milliseconds
20
1 - 4G
Restart Type: N
This parameter uses the same units as
NoOfDiskPagesToDiskAfterRestartTUP
and acts in a
similar fashion, but limits the speed of writing index pages from index memory.
The default value of this parameter is 20 (1.6MB of index memory pages per second).
•
NoOfDiskPagesToDiskDuringRestartTUP
Содержание 5.0
Страница 1: ...MySQL 5 0 Reference Manual ...
Страница 18: ...xviii ...
Страница 60: ...40 ...
Страница 396: ...376 ...
Страница 578: ...558 ...
Страница 636: ...616 ...
Страница 844: ...824 ...
Страница 1234: ...1214 ...
Страница 1426: ...MySQL Proxy Scripting 1406 The following diagram shows an overview of the classes exposed by MySQL Proxy ...
Страница 1427: ...MySQL Proxy Scripting 1407 ...
Страница 1734: ...1714 ...
Страница 1752: ...1732 ...
Страница 1783: ...Configuring Connector ODBC 1763 ...
Страница 1793: ...Connector ODBC Examples 1773 ...
Страница 1839: ...Connector Net Installation 1819 2 You must choose the type of installation to perform ...
Страница 1842: ...Connector Net Installation 1822 5 Once the installation has been completed click Finish to exit the installer ...
Страница 1864: ...Connector Net Visual Studio Integration 1844 Figure 20 24 Debug Stepping Figure 20 25 Function Stepping 1 of 2 ...
Страница 2850: ...2830 ...
Страница 2854: ...2834 ...
Страница 2928: ...2908 ...
Страница 3000: ...2980 ...
Страница 3122: ...3102 ...
Страница 3126: ...3106 ...
Страница 3174: ...3154 ...
Страница 3232: ...3212 ...