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