Versions Compared

Version Old Version 1 New Version Current
Changes made by

Ryan Park

Grey Shim

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Section


Column

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

Column
width30%
Ui text box
Table of Contents
maxLevel3
indent20px
exclude목차
classtoc


Info

Available in 5.7 and after

...

(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

...

(usec)Value

Minimum

0

Maximum

2^64 - 1

Default

1000000


...

(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


...

(usec)Value

Minimum

0

Maximum

2^64 - 1

Default

30000000


...

(usec)Value

Minimum

0

Maximum

2^64 - 1

Default

60000000


...

(usec)Value

Minimum

0

Maximum

2^64 - 1

Default

30000000


...

(usec)Value

Minimum

0

Maximum

2^64 - 1

Default

3600000000


...

CLUSTER_QUERY_STAT_LOG_ENABLE

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

(boolean)Value

Minimum

0

Maximum

1

Default

0

...

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

...

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.

Ui text box
type
Note

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.

...

(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

...

(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

...

(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

...

(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

...

(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.

...

(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.

Ui text box
type
Note

When the corresponding function is turned on, the Group receiving data is limited. This  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.

...

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