Parameter Values

Command

Description

Example

SET<flag_name>

Used for modifying flag attributes.

SET enableLogDebug=false

SHOW <flag-name> / ALL

Used to preset either a specific flag value or all flag values.

SHOW <heartbeatInterval>

SHOW ALL LIKE

Used as a wildcard character for flag names.

SHOW <heartbeat*>

SELECT show_conf() ;

Used to print all flags with the following attributes:

  • Flag name

  • Default value

  • Is Developer Mode (Boolean)

  • Flag category

  • Flag type

rechunkThreshold,90,true,RND,regular

SELECT show_conf_extended();

Used to print all information output by the show_conf UF command, in addition to description, usage, data type, default value and range.

rechunkThreshold,90,true,RND,regular

show_md_flag UF

Used to show a specific flag/all flags stored in the metadata.

  • Example 1: * master=> ALTER SYSTEM SET heartbeatTimeout=111;

  • Example 2: * master=> select show_md_flag(‘all’); heartbeatTimeout,111

  • Example 3: * master=> select show_md_flag(‘heartbeatTimeout’); heartbeatTimeout,111

ALTER SYSTEM SET <flag-name>

Used for storing or modifying flag attributes in the metadata.

ALTER SYSTEM SET <heartbeatInterval=12;>

ALTER SYSTEM RESET <flag-name / ALL>

Used to remove a flag or all flag attributes from the metadata.

ALTER SYSTEM RESET <heartbeatInterval ALTER SYSTEM RESET ALL>