-
Id
The Id value is used to identify the
node in all cluster internal messages. It must be an
integer in the range 1 to 63 inclusive, and must be unique
among all node IDs within the cluster.
-
ExecuteOnComputer
This refers to one of the computers (hosts) defined in a
[COMPUTER] section of the configuration
file.
-
ArbitrationRank
This parameter defines which nodes can act as arbitrators.
Both MGM nodes and SQL nodes can be arbitrators. A value
of 0 means that the given node is never used as an
arbitrator, a value of 1 gives the node high priority as
an arbitrator, and a value of 2 gives it low priority. A
normal configuration uses the management server as
arbitrator, setting its ArbitrationRank
to 1 (the default) and those for all SQL nodes to 0.
-
ArbitrationDelay
Setting this parameter to any other value than 0 (the
default) means that responses by the arbitrator to
arbitration requests will be delayed by the stated number
of milliseconds. It is usually not necessary to change
this value.
-
BatchByteSize
For queries that are translated into full table scans or
range scans on indexes, it is important for best
performance to fetch records in properly sized batches. It
is possible to set the proper size both in terms of number
of records (BatchSize) and in terms of
bytes (BatchByteSize). The actual batch
size is limited by both parameters.
The speed at which queries are performed can vary by more
than 40% depending upon how this parameter is set. In
future releases, MySQL Server will make educated guesses
on how to set parameters relating to batch size, based on
the query type.
This parameter is measured in bytes and by default is
equal to 32KB.
-
BatchSize
This parameter is measured in number of records and is by
default set to 64. The maximum size is 992.
-
MaxScanBatchSize
The batch size is the size of each batch sent from each
data node. Most scans are performed in parallel to protect
the MySQL Server from receiving too much data from many
nodes in parallel; this parameter sets a limit to the
total batch size over all nodes.
The default value of this parameter is set to 256KB. Its
maximum size is 16MB.
