Separate from Property, Property (Cluster) organizes the Property only available in Cluster Edition.

Timeout until receiving Handshake message after Accept when connecting to a specific Node Failure to receive within the timeout will cause the connection to fail. 
The default value is 5 seconds.

(usec)Value

Minimum

0

Maximum

2^64 - 1

Default

5000000

Check interval of the Timeout Thread that checks the Sockets connected to a specific Node
There is a Timeout Thread that checks RECEIVE_TIMEOUT and SESSION_TIMEOUT. 
The shorter the cycle is, the more frequently it is checked, but the Timeout determination is made according to the following values.
The default value is 1 second.

(usec)Value

Minimum

0

Maximum

2^64 - 1

Default

1000000

Timeout to repeat reconnection attempt after connection failure with a specific Node
If it is not connected within the timeout, it is determined to be completely disconnected.
The default value is 1 minute.

(usec)Value

Minimum

0

Maximum

2^64 - 1

Default

60000000

Time to wait when trying to connect to a specific Node
If it does not connect within the Timeout, it will try to reconnect until CLUSTER_LINK_CONNECT_RETRY_TIMEOUT has passed.
The default value is 5 seconds.

(usec)Value

Minimum

0

Maximum

2^64 - 1

Default

5000000

You can choose whether to add an errored host name to error messages that occur during communication between the Cluster.
If you want to display a detailed error message, set the property to 1. 
The default value is 0, which means the host name is not displayed.

(boolean)Value

Minimum

0

Maximum

1
Default0

Timeout until receiving a Handshake message while connected to a specific Node and Cluster Socket
Two Nodes that have just finished connecting exchange small size Handshake messages to check the connection status. 
The Accept Node sends the Handshake message first, and the time to wait for the response is set here.
The default value is 5 seconds.

(usec)Value

Minimum

0

Maximum

2^64 - 1

Default

5000000

Index


Available in 5.7 and after

The size of the send / receive buffer.

If this size is insufficient, the transmission will retry until the buffer is empty.

The default value is 32M.

(byte)Value
Minimum1024768
Maximum2^32 - 1
Default33554432 (32M)



Available in 5.7 and after

Number of times to retry sending until the send buffer is empty.

Every retry will take 1ms off. If you retry beyond this number, you will be disconnected.

The default value is 5000 (msec).

(count)Value
Minimum0
Maximum2^32 - 1
Default5000


Host name of the current Node to connect to a specific Node and Cluster Socket

(string)Value

Default

localhost


If the execution time of Receive Callback to process a message received on Cluster Socket exceeds the set value, it is recognized as Long-Term Callback. 
Since the number of receive Threads is limited, Receive Callback should not process messages for a long time. 
If Receive Callback processes the message after this time, it recognizes it as Long-Term Callback and records it in Trace Log.
The default value is 1 second.

(usec)Value

Minimum

0

Maximum

2^64 - 1

Default

1000000


If the time until the arrival of a message received on Cluster Socket exceeds the set value, it is recognized as Long-Wait Message.
If the time from receiving start to receiving end is long, it can be regarded as a problem of the network environment. 
If the received message does not arrive after this time, it is recognized as a Long-Wait Message and recorded in the Trace Log.
The default value is 1 second.

(usec)Value

Minimum

0

Maximum

2^64 - 1

Default

1000000


The maximum number of Socket's Accept Queue when connecting to a specific Node

(count)Value

Minimum

1

Maximum

2^32 - 1

Default

512


The maximum number of Events that can be retrieved at a time by Poll when communicating with a specific node

(count)Value

Minimum

1

Maximum

2^32 - 1

Default

4096


The port number of the current Node for connecting the specific Node to the Cluster Socket

(port)Value

Minimum

1024

Maximum

65535

Default

3868


Timeout until the Timeout Thread determines that the connection has been disconnected since the last reception
Connections that exist in the 'Linked List' should be continuously receiving because the connection between Cluster Nodes is terminated when the reception is complete.
If the last received time is not updated after the set time has elapsed, the Timeout Thread records its contents in the Trace Log and closes the Socket.

(usec)Value

Minimum

0

Maximum

2^64 - 1

Default

30000000


Timeout from when a request message is sent from the Cluster Socket to when a response to the request is received
For specific messages, specify the time to wait for a response after the request. 
If the response message does not arrive at this time, write to the Trace Log and close the Socket.
The default value is 60 seconds,  and the Timeout is long because it is not known what kind of message and receive processing will happen.

(usec)Value

Minimum

0

Maximum

2^64 - 1

Default

60000000


Timeout to set when sending messages through Cluster Socket
Set the corresponding timeout when transmitting 
If transmission is not completed until Timeout,  it is recorded in the Trace Log.

(usec)Value

Minimum

0

Maximum

2^64 - 1

Default

30000000


Timeout until the Timeout thread determines that the connection has been disconnected since the last receive in a specific session.
Cluster connection manages the session of all messages internally, which is a necessary property in case the session can suddenly not be fixed. 
If the last receive time for the session is not updated after this time, the Timeout Thread writes to the Trace Log and closes the session.
The default value is 1 hour.

(usec)Value

Minimum

0

Maximum

2^64 - 1

Default

3600000000


The number of Threads to process the received messages when communicating with a specific Node
If the size of the Cluster grows or the number of operations to be processed increases, the number of Threads that can be received increases.

(count)Value

Minimum

1

Maximum

4096

Default

8


CLUSTER_QUERY_STAT_LOG_ENABLE

Outputs statistical information about the executed query to the trace log.

(boolean)Value

Minimum

0

Maximum

1

Default

0


CLUSTER_REPLICATION_BLOCK_SIZE

The size of the data to be sent at once when the Replication for adding Node is performed in the Cluster Edition
The Property must be applied directly to the warehouse (=Transmitting Warehouse) that becomes the Replication Active.
The default value is 640 KB.

(size)Value

Minimum

64 * 1024

Maximum

100 * 1024 * 1024

Default

640 * 1024 (655360)


CLUSTER_WAREHOUSE_DIRECT_DML_ENABLE

It is made possible to connect directly to the Warehouse to perform DML in Cluster Edition.

  • 1: Executable
  • 2: Not executable. An error is returned.

When directly performing the DML in Warehouse, there are performance advantages over Brokers but  there is an issue where the DML is not propagated to the same Group. 
Therefore, it is used only for emergency recovery due to data discrepancies, or if the data discrepancies of the Group can be taken into account.
You must apply Properties directly to the specific Warehouse you want.
The default value is 0.

The Coordinator does not check for data discrepancies, even if there is a data difference between the Warehouses in the Group with the corresponding Property turned on.


(boolean)Value

Minimum

0

Maximum

1

Default

0


COORDINATOR_DBS_PATH

Specifies the directory where the Coordinator data file will be created
The default value is set to ?/dbs, and ? is replaced with the $ MACHBASE_COORDINATOR_HOME environment variable. 
This is an environment variable $MACHBASE_COORDINATOR_HOME/dbs directory.
It must be applied to the Coordinator, and it has no effect on other Nodes.

(path)Value

Default

?/dbs


COORDINATOR_DDL_REQUEST_TIMEOUT

Timeout until the Coordinator waits after requesting the Node to execute DDL
This value refers to the time the Coordinator waits after requesting each Node to perform DDL.

(usec)Value

Minimum

0

Maximum

2^64 - 1

Default

300000000


COORDINATOR_DDL_TIMEOUT

Timeout until the Broker waits after requesting Coordinator to perform DDL through CC
This value refers to the time that the Broker waits after requesting the Coordinator to perform DDL for the entire Cluster.

(usec)Value

Minimum

0

Maximum

2^64 - 1

Default

3600000000


COORDINATOR_DECISION_DELAY

Timeout until the Coordinator requests the status change and effectively reflects it.
If the status does not actually change over this time, disable the cluster status. 
If the status of the Warehouse Active is not changed but the connected Standby exists, the Fail-Over operation starts.

(usec)Value

Minimum

0

Maximum

2^64 - 1

Default

1000000


COORDINATOR_DECISION_INTERVAL

Time to determine how often the Coordinator changes status

(usec)Value

Minimum

0

Maximum

2^64 - 1

Default

1000000


COORDINATOR_HOST_RESOURCE_COLLECT_INTERVAL

Interval at which Cluster Nodes collect Host Resources

(usec)Value

Minimum

0

Maximum

2^64 - 1

Default

1000000


COORDINATOR_HOST_RESOURCE_INTERVAL

Interval at which the Coordinator exchanges Host Resources with Nodes

(usec)Value

Minimum

0

Maximum

2^64 - 1

Default

1000000


COORDINATOR_HOST_RESOURCE_REQUEST_TIMEOUT

Time that the Coordinator waits after requesting the Host Resource information from the Nodes

(usec)Value

Minimum

0

Maximum

2^64 - 1

Default

10000000


COORDINATOR_NODE_REQUEST_TIMEOUT

Timeout until the Coordinator waits after requesting the Node to execute the command
Because the Add/Remove-node and Add/Remove-Package includes the Node command execution, if it is caught in a short time, the command processing may not be completed.

(usec)Value

Minimum

0

Maximum

2^64 - 1

Default

600000000


COORDINATOR_NODE_TIMEOUT

Time the Coordinator waits before determining that the Node has failed

(usec)Value
Minimum0
Maximum2^64 - 1
Default30000000


COORDINATOR_STARTUP_DELAY

Grace time until activating the Decision Thread immediately after Coordinator startup
If it takes a long time to run the entire Cluster, you can start the Node control of Coordinator later by setting a larger value. 
If the Decision Thread runs before the entire drive, there is a high likelihood that the Coordinator will be misplaced.

(usec)Value

Minimum

0

Maximum

2^64 - 1

Default

3000000


COORDINATOR_STATUS_NODE_INTERVAL

Interval in which the Coordinator exchanges status inquiry messages with the Node

(usec)Value

Minimum

0

Maximum

2^64 - 1

Default

1000000


COORDINATOR_STATUS_NODE_REQUEST_TIMEOUT

Time the Coordinator waits after requesting status inquiries from Nodes.
If there is no status inquiry response during that time, the Coordinator proceeds without updating the status of the corresponding Node. 
If the network situation is not good and you need to update the state, you could consider increasing the value. 
Instead, if there is no status query response, the Coordinator will wait for as much as the value was increased.

(usec)Value

Minimum

0

Maximum

2^64 - 1

Default

3000000


DEPLOYER_DBS_PATH

Specifies the directory where the Deployer's data files will be created.
The default value is set to?/dbs, and ? is replaced with the $ MACHBASE_DEPLOYER_HOME environment variable. 
This is an environment variable $MACHBASE_DEPLOYER_HOME /dbs directory.
It must be applied to Deployer, and it has no effect on other Nodes.

(path)Value

Default

?/dbs


EXECUTION_STAGE_MEMORY_MAX

The maximum amount of Memory used by the Stage Thread performing the SELECT query in Cluster Edition
Because it is the maximum size of each Stage, the complexity of the SELECT query with an increase in the number of Stages can lead to a larger memory requirement. 
If there is a Stage that exceeds the maximum size, the Stage is canceled and the Query is canceled with an error.
You must apply Properties directly to the specific Warehouse you want.
The default value is 1GB.

(size)Value

Minimum

1024

Maximum

2^64 - 1

Default

1024 *1024 * 1024


HTTP_ADMIN_PORT

Port number to receive requests from MWA or machcoordinatoradmin

(port)Value

Minimum

1024

Maximum

65535

Default

5779


HTTP_CONNECT_TIMEOUT

Timeout used when connecting to machcoordinatoradmin

(usec)Value

Minimum

0

Maximum

2^64 - 1

Default

30000000


HTTP_RECEIVE_TIMEOUT

Timeout used when communicating with machcoordinatoradmin

(usec)Value

Minimum

0

Maximum

2^64 - 1

Default

3600000000


HTTP_SEND_TIMEOUT

Timeout used when communicating with machcoordinatoradmin

(usec)Value

Minimum

0

Maximum

2^64 - 1

Default

60000000


INSERT_BALANCE_MODE

When append or INSERT-SELECT is executed, it is instructed to input uniformly to each group.
If it is 0, it turns off the feature. If it is 1, it turns on the feature.

When the corresponding function is turned on, the Group receiving data is limited. This is because the input to the disk scarce Warehouse will not be completed.
Therefore, the overall property of the input may seem to be degraded, so the default value of that Property is zero.

(mode)Value

Minimum

0

Maximum

1

Default

0


INSERT_BULK_DATA_MAX_SIZE

Maximum size of input data block when executing Append or INSERT-SELECT

(size)Value

Minimum

1024

Maximum

10 * 1024 * 1024

Default

1024 * 1024


INSERT_RECORD_COUNT_PER_NODE

Number of data inputs that lead to the warehouse group conversion when performing the input

(count)Value

Minimum

1

Maximum

2^64 - 1

Default

10000


STAGE_RESULT_BLOCK_SIZE

Maximum block size created in one stage

(size)Value

Minimum

1024

Maximum

2^64 - 1

Default

1024 * 1024












  • No labels