Reference: magma (GUC)

The magma special configuration item is saved in the magma-site.xml file, which is located in the directory /usr/local/hawq/etc.

The configuration takes effect in the following three ways:

  • initdb: It takes effect on initdb, and cannot be changed later.

  • restart: It takes effect on restart, and the changes will not be detected after start.

  • autocheck: Automatically reload the changes when the configuration file is updated.

blacklist_log_threashold

Set the maximum gap of an offline node measured by number of raft log items behind its corresponding leaders before moving it into blacklist, with B.

Value Range

Default

Set Classifications

integer

85899345920

autocheck

compact_cleanup_worker_limit_perrg

Set the limit of runnings concurrent compact workers for cleaning up jobs in one range group.

Value Range

Default

Set Classifications

integer

16

autocheck

compact_data_worker_limit_pernode

Set the limit of running concurrent compact workers in one node.

Value Range

Default

Set Classifications

integer

4

autocheck

compact_data_worker_limit_perrg

Set the limit of running concurrent compact workers in one range group.

Value Range

Default

Set Classifications

integer

1

autocheck

compact_trigger_ap_ratio_limit

Set the invalid rate as threshold of triggering compact in MagmaAP format.

Value Range

Default

Set Classifications

floating point < 1.0

0.5

autocheck

compact_trigger_tp_ratio_limit

Set the invalid rate as threshold of triggering compact in Magma catalog format.

Value Range

Default

Set Classifications

floating point < 1.0

0.5

autocheck

fts_node_timeout

Set the timeout in second of a live node.

Value Range

Default

Set Classifications

integer

60

autocheck

nbuffers

Set the number of buffer pages reserved by buffer manager at range group level,Default number is 10240(×16K=160MB).

Value Range

Default

Set Classifications

integer

10240

restart

raft_election_timeout

Set the timeout of raft election in second.

Value Range

Default

Set Classifications

integer

120

autocheck

rg_checkpoint_threshold

Set the minimum size in KB of accumulated raft log items should be flushed by checkpoint in one range group.

Value Range

Default

Set Classifications

integer

204800

autocheck