obclient > show variables like 'version_comment'; +-----------------+------------------------------------------------------------------------------------------------------------------+ | Variable_name | Value | +=================+==================================================================================================================+ | version_comment | OceanBase_CE 4.2.1.7 (r107000162024060611-69b64b84b656a4cfa126dab60b4e66dc1bc156ca) (Built Jun 6 2024 11:51:48) | +-----------------+------------------------------------------------------------------------------------------------------------------+ obclient > SELECT * FROM oceanbase.DBA_OB_ZONES; +--------+----------------------------+----------------------------+----------+-------------+------------+-----------+ | ZONE | CREATE_TIME | MODIFY_TIME | STATUS | IDC | REGION | TYPE | +========+============================+============================+==========+=============+============+===========+ | zone1 | 2024-06-25 12:34:35.442274 | 2024-06-25 12:35:02.427521 | ACTIVE | default_idc | sys_region | ReadWrite | +--------+----------------------------+----------------------------+----------+-------------+------------+-----------+ | zone2 | 2024-06-25 12:34:35.442274 | 2024-06-25 12:35:02.435977 | ACTIVE | default_idc | sys_region | ReadWrite | +--------+----------------------------+----------------------------+----------+-------------+------------+-----------+ | zone3 | 2024-06-25 12:34:35.442274 | 2024-06-25 12:35:02.442494 | ACTIVE | default_idc | sys_region | ReadWrite | +--------+----------------------------+----------------------------+----------+-------------+------------+-----------+ obclient > SELECT * FROM oceanbase.DBA_OB_SERVERS; +---------------+------------+------+--------+------------+-------------------+----------+----------------------------+-------------+-------------------------+----------------------------+----------------------------+-------------------------------------------------------------------------------------------+---------------------+ | SVR_IP | SVR_PORT | ID | ZONE | SQL_PORT | WITH_ROOTSERVER | STATUS | START_SERVICE_TIME | STOP_TIME | BLOCK_MIGRATE_IN_TIME | CREATE_TIME | MODIFY_TIME | BUILD_VERSION | LAST_OFFLINE_TIME | +===============+============+======+========+============+===================+==========+============================+=============+=========================+============================+============================+===========================================================================================+=====================+ | 172.31.32.214 | 2882 | 12 | zone2 | 2881 | NO | ACTIVE | 2024-07-17 23:50:53.746702 | | | 2024-07-17 13:22:46.519217 | 2024-07-17 23:51:03.226552 | 4.2.1.7_107000162024060611-69b64b84b656a4cfa126dab60b4e66dc1bc156ca(Jun 6 2024 11:51:48) | | +---------------+------------+------+--------+------------+-------------------+----------+----------------------------+-------------+-------------------------+----------------------------+----------------------------+-------------------------------------------------------------------------------------------+---------------------+ | 172.31.35.128 | 2882 | 14 | zone1 | 2881 | YES | ACTIVE | 2024-07-17 22:16:49.754463 | | | 2024-07-17 22:14:16.480209 | 2024-07-17 23:30:52.975013 | 4.2.1.7_107000162024060611-69b64b84b656a4cfa126dab60b4e66dc1bc156ca(Jun 6 2024 11:51:48) | | +---------------+------------+------+--------+------------+-------------------+----------+----------------------------+-------------+-------------------------+----------------------------+----------------------------+-------------------------------------------------------------------------------------------+---------------------+ | 172.31.44.197 | 2882 | 13 | zone3 | 2881 | NO | ACTIVE | 2024-07-17 17:54:37.752520 | | | 2024-07-17 17:52:04.229269 | 2024-07-17 17:54:39.516303 | 4.2.1.7_107000162024060611-69b64b84b656a4cfa126dab60b4e66dc1bc156ca(Jun 6 2024 11:51:48) | | +---------------+------------+------+--------+------------+-------------------+----------+----------------------------+-------------+-------------------------+----------------------------+----------------------------+-------------------------------------------------------------------------------------------+---------------------+ obclient > SELECT * FROM oceanbase.GV$OB_SERVERS; +---------------+------------+--------+------------+----------------+--------------------+----------------+--------------------+----------------+----------------+---------------------+---------------------+-------------------+----------------------+--------------------+---------------------------+----------------+-----------------------+---------------------------+-------------------------+ | SVR_IP | SVR_PORT | ZONE | SQL_PORT | CPU_CAPACITY | CPU_CAPACITY_MAX | CPU_ASSIGNED | CPU_ASSIGNED_MAX | MEM_CAPACITY | MEM_ASSIGNED | LOG_DISK_CAPACITY | LOG_DISK_ASSIGNED | LOG_DISK_IN_USE | DATA_DISK_CAPACITY | DATA_DISK_IN_USE | DATA_DISK_HEALTH_STATUS | MEMORY_LIMIT | DATA_DISK_ALLOCATED | DATA_DISK_ABNORMAL_TIME | SSL_CERT_EXPIRED_TIME | +===============+============+========+============+================+====================+================+====================+================+================+=====================+=====================+===================+======================+====================+===========================+================+=======================+===========================+=========================+ | 172.31.44.197 | 2882 | zone3 | 2881 | 20 | 20 | 19 | 19 | 96671514624 | 91268055040 | 451172892672 | 267361714176 | 202735878144 | 1434202406912 | 839877918720 | NORMAL | 106335191040 | 1434202406912 | | | +---------------+------------+--------+------------+----------------+--------------------+----------------+--------------------+----------------+----------------+---------------------+---------------------+-------------------+----------------------+--------------------+---------------------------+----------------+-----------------------+---------------------------+-------------------------+ | 172.31.35.128 | 2882 | zone1 | 2881 | 20 | 20 | 19 | 19 | 96671514624 | 91268055040 | 451172892672 | 267361714176 | 201460809728 | 1434202406912 | 813999063040 | NORMAL | 106335191040 | 1434202406912 | | | +---------------+------------+--------+------------+----------------+--------------------+----------------+--------------------+----------------+----------------+---------------------+---------------------+-------------------+----------------------+--------------------+---------------------------+----------------+-----------------------+---------------------------+-------------------------+ | 172.31.32.214 | 2882 | zone2 | 2881 | 20 | 20 | 19 | 19 | 96671514624 | 91268055040 | 451172892672 | 267361714176 | 201393700864 | 1434202406912 | 811304222720 | NORMAL | 106335191040 | 1434202406912 | | | +---------------+------------+--------+------------+----------------+--------------------+----------------+--------------------+----------------+----------------+---------------------+---------------------+-------------------+----------------------+--------------------+---------------------------+----------------+-----------------------+---------------------------+-------------------------+ obclient > SELECT * FROM oceanbase.DBA_OB_UNIT_CONFIGS; +------------------+----------------------------+----------------------------+----------------------------+-----------+-----------+---------------+-----------------+---------------------+---------------------+---------------+ | UNIT_CONFIG_ID | NAME | CREATE_TIME | MODIFY_TIME | MAX_CPU | MIN_CPU | MEMORY_SIZE | LOG_DISK_SIZE | MAX_IOPS | MIN_IOPS | IOPS_WEIGHT | +==================+============================+============================+============================+===========+===========+===============+=================+=====================+=====================+===============+ | 1006 | config_game_zone2_unit_coh | 2024-07-17 13:27:23.552675 | 2024-07-17 13:27:23.552675 | 16 | 16 | 85899345920 | 257698037760 | 9223372036854775807 | 9223372036854775807 | 16 | +------------------+----------------------------+----------------------------+----------------------------+-----------+-----------+---------------+-----------------+---------------------+---------------------+---------------+ | 1007 | config_sys_zone2_sys_irr | 2024-07-17 13:27:42.549644 | 2024-07-17 13:27:42.549644 | 3 | 3 | 5368709120 | 9663676416 | 9223372036854775807 | 9223372036854775807 | 3 | +------------------+----------------------------+----------------------------+----------------------------+-----------+-----------+---------------+-----------------+---------------------+---------------------+---------------+ | 1008 | config_game_zone3_unit_rma | 2024-07-17 17:57:07.897172 | 2024-07-17 17:57:07.897172 | 16 | 16 | 85899345920 | 257698037760 | 9223372036854775807 | 9223372036854775807 | 16 | +------------------+----------------------------+----------------------------+----------------------------+-----------+-----------+---------------+-----------------+---------------------+---------------------+---------------+ | 1009 | config_sys_zone3_sys_skd | 2024-07-17 17:57:23.566774 | 2024-07-17 17:57:23.566774 | 3 | 3 | 5368709120 | 9663676416 | 9223372036854775807 | 9223372036854775807 | 3 | +------------------+----------------------------+----------------------------+----------------------------+-----------+-----------+---------------+-----------------+---------------------+---------------------+---------------+ | 1010 | config_game_zone1_unit_hsa | 2024-07-17 22:20:02.901263 | 2024-07-17 22:20:02.901263 | 16 | 16 | 85899345920 | 257698037760 | 9223372036854775807 | 9223372036854775807 | 16 | +------------------+----------------------------+----------------------------+----------------------------+-----------+-----------+---------------+-----------------+---------------------+---------------------+---------------+ | 1011 | config_sys_zone1_sys_kji | 2024-07-17 22:20:13.401132 | 2024-07-17 22:20:13.401132 | 3 | 3 | 5368709120 | 9663676416 | 9223372036854775807 | 9223372036854775807 | 3 | +------------------+----------------------------+----------------------------+----------------------------+-----------+-----------+---------------+-----------------+---------------------+---------------------+---------------+ | 1012 | box_16c96g | 2024-07-19 17:06:08.977337 | 2024-07-19 17:06:08.977337 | 4 | 4 | 8589934592 | 25769803776 | 10240 | 10240 | 0 | +------------------+----------------------------+----------------------------+----------------------------+-----------+-----------+---------------+-----------------+---------------------+---------------------+---------------+ | 1013 | box_4c8g | 2024-07-19 17:09:27.913946 | 2024-07-19 17:09:27.913946 | 4 | 4 | 8589934592 | 25769803776 | 10240 | 10240 | 0 | +------------------+----------------------------+----------------------------+----------------------------+-----------+-----------+---------------+-----------------+---------------------+---------------------+---------------+ obclient > SELECT * FROM oceanbase.DBA_OB_RESOURCE_POOLS; +--------------------+---------------------+-------------+----------------------------+----------------------------+--------------+------------------+-------------+----------------+ | RESOURCE_POOL_ID | NAME | TENANT_ID | CREATE_TIME | MODIFY_TIME | UNIT_COUNT | UNIT_CONFIG_ID | ZONE_LIST | REPLICA_TYPE | +====================+=====================+=============+============================+============================+==============+==================+=============+================+ | 1009 | pool_game_zone2_coh | 1002 | 2024-07-17 13:27:23.566078 | 2024-07-17 13:27:23.581927 | 1 | 1006 | zone2 | FULL | +--------------------+---------------------+-------------+----------------------------+----------------------------+--------------+------------------+-------------+----------------+ | 1010 | pool_sys_zone2_irr | 1 | 2024-07-17 13:27:42.563385 | 2024-07-17 13:27:42.578206 | 1 | 1007 | zone2 | FULL | +--------------------+---------------------+-------------+----------------------------+----------------------------+--------------+------------------+-------------+----------------+ | 1011 | pool_game_zone3_rma | 1002 | 2024-07-17 17:57:07.933006 | 2024-07-17 17:57:07.948742 | 1 | 1008 | zone3 | FULL | +--------------------+---------------------+-------------+----------------------------+----------------------------+--------------+------------------+-------------+----------------+ | 1012 | pool_sys_zone3_skd | 1 | 2024-07-17 17:57:23.586484 | 2024-07-17 17:57:23.615088 | 1 | 1009 | zone3 | FULL | +--------------------+---------------------+-------------+----------------------------+----------------------------+--------------+------------------+-------------+----------------+ | 1013 | pool_game_zone1_hsa | 1002 | 2024-07-17 22:20:02.915888 | 2024-07-17 22:20:02.932778 | 1 | 1010 | zone1 | FULL | +--------------------+---------------------+-------------+----------------------------+----------------------------+--------------+------------------+-------------+----------------+ | 1014 | pool_sys_zone1_kji | 1 | 2024-07-17 22:20:13.412726 | 2024-07-17 22:20:13.429576 | 1 | 1011 | zone1 | FULL | +--------------------+---------------------+-------------+----------------------------+----------------------------+--------------+------------------+-------------+----------------+ obclient > SELECT * FROM oceanbase.DBA_OB_TENANTS; +-------------+---------------+---------------+----------------------------+----------------------------+----------------+---------------------------------------------+---------------------+----------------------+----------+-----------------+----------+---------------+---------------------+--------------------+---------------------+---------------------+---------------------+----------------------+--------------+------------------------------+------------+--------------+-------------+ | TENANT_ID | TENANT_NAME | TENANT_TYPE | CREATE_TIME | MODIFY_TIME | PRIMARY_ZONE | LOCALITY | PREVIOUS_LOCALITY | COMPATIBILITY_MODE | STATUS | IN_RECYCLEBIN | LOCKED | TENANT_ROLE | SWITCHOVER_STATUS | SWITCHOVER_EPOCH | SYNC_SCN | REPLAYABLE_SCN | READABLE_SCN | RECOVERY_UNTIL_SCN | LOG_MODE | ARBITRATION_SERVICE_STATUS | UNIT_NUM | COMPATIBLE | MAX_LS_ID | +=============+===============+===============+============================+============================+================+=============================================+=====================+======================+==========+=================+==========+===============+=====================+====================+=====================+=====================+=====================+======================+==============+==============================+============+==============+=============+ | 1 | sys | SYS | 2024-06-25 12:34:35.373303 | 2024-07-17 22:20:33.780723 | RANDOM | FULL{1}@zone1, FULL{1}@zone2, FULL{1}@zone3 | | MYSQL | NORMAL | NO | NO | PRIMARY | NORMAL | 0 | | | | | NOARCHIVELOG | DISABLED | 1 | 4.2.1.7 | 1 | +-------------+---------------+---------------+----------------------------+----------------------------+----------------+---------------------------------------------+---------------------+----------------------+----------+-----------------+----------+---------------+---------------------+--------------------+---------------------+---------------------+---------------------+----------------------+--------------+------------------------------+------------+--------------+-------------+ | 1001 | META$1002 | META | 2024-06-25 13:05:00.249859 | 2024-07-17 23:26:50.276640 | RANDOM | FULL{1}@zone1, FULL{1}@zone2, FULL{1}@zone3 | | MYSQL | NORMAL | NO | NO | PRIMARY | NORMAL | 0 | | | | | NOARCHIVELOG | DISABLED | 1 | 4.2.1.7 | 1 | +-------------+---------------+---------------+----------------------------+----------------------------+----------------+---------------------------------------------+---------------------+----------------------+----------+-----------------+----------+---------------+---------------------+--------------------+---------------------+---------------------+---------------------+----------------------+--------------+------------------------------+------------+--------------+-------------+ | 1002 | game | USER | 2024-06-25 13:05:00.252854 | 2024-07-17 23:26:50.275582 | RANDOM | FULL{1}@zone1, FULL{1}@zone2, FULL{1}@zone3 | | MYSQL | NORMAL | NO | NO | PRIMARY | NORMAL | 0 | 1721715023882578783 | 1721715023882578783 | 1721715023875393044 | 4611686018427387903 | NOARCHIVELOG | DISABLED | 1 | 4.2.1.7 | 1011 | +-------------+---------------+---------------+----------------------------+----------------------------+----------------+---------------------------------------------+---------------------+----------------------+----------+-----------------+----------+---------------+---------------------+--------------------+---------------------+---------------------+---------------------+----------------------+--------------+------------------------------+------------+--------------+-------------+ obclient > SELECT c.TENANT_ID, e.TENANT_NAME, concat(c.NAME, ': ', d.NAME) `pool:conf`,concat(c.UNIT_COUNT, ' unit: ', d.min_cpu, 'C/', ROUND(d.MEMORY_SIZE/1024/1024/1024,0), 'G') unit_info FROM oceanbase.DBA_OB_RESOURCE_POOLS c, oceanbase.DBA_OB_UNIT_CONFIGS d, oceanbase.DBA_OB_TENANTS e WHERE c.UNIT_CONFIG_ID=d.UNIT_CONFIG_ID AND c.TENANT_ID=e.TENANT_ID AND c.TENANT_ID>1000 ORDER BY c.TENANT_ID; +-------------+---------------+-------------------------------------------------+-----------------+ | TENANT_ID | TENANT_NAME | pool:conf | unit_info | +=============+===============+=================================================+=================+ | 1002 | game | pool_game_zone2_coh: config_game_zone2_unit_coh | 1 unit: 16C/80G | +-------------+---------------+-------------------------------------------------+-----------------+ | 1002 | game | pool_game_zone3_rma: config_game_zone3_unit_rma | 1 unit: 16C/80G | +-------------+---------------+-------------------------------------------------+-----------------+ | 1002 | game | pool_game_zone1_hsa: config_game_zone1_unit_hsa | 1 unit: 16C/80G | +-------------+---------------+-------------------------------------------------+-----------------+ obclient > SELECT a.TENANT_NAME,a.TENANT_ID,b.SVR_IP FROM oceanbase.DBA_OB_TENANTS a, oceanbase.GV$OB_UNITS b WHERE a.TENANT_ID=b.TENANT_ID; +---------------+-------------+---------------+ | TENANT_NAME | TENANT_ID | SVR_IP | +===============+=============+===============+ | sys | 1 | 172.31.32.214 | +---------------+-------------+---------------+ | META$1002 | 1001 | 172.31.32.214 | +---------------+-------------+---------------+ | game | 1002 | 172.31.32.214 | +---------------+-------------+---------------+ | sys | 1 | 172.31.35.128 | +---------------+-------------+---------------+ | META$1002 | 1001 | 172.31.35.128 | +---------------+-------------+---------------+ | game | 1002 | 172.31.35.128 | +---------------+-------------+---------------+ | sys | 1 | 172.31.44.197 | +---------------+-------------+---------------+ | META$1002 | 1001 | 172.31.44.197 | +---------------+-------------+---------------+ | game | 1002 | 172.31.44.197 | +---------------+-------------+---------------+ obclient > show parameters +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone | svr_type | svr_ip | svr_port | name | data_type | value | info | section | scope | source | edit_level | +========+============+===============+============+=================================================+=============+===========================================================================================================+==============================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================+================+=========+==========+===================+ | zone3 | observer | 172.31.44.197 | 2882 | sql_protocol_min_tls_version | | none | SQL SSL control options, used to specify the minimum SSL/TLS version number. values: none, TLSv1, TLSv1.1, TLSv1.2, TLSv1.3 | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | rpc_server_authentication_method | | ALL | specifies rpc server authentication method. ALL: support all authentication methods. NONE: without authentication. SSL_NO_ENCRYPT: authentication by SSL handshake but not encrypt the communication channel. SSL_IO: authentication by SSL handshake and encrypt the communication channel | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | rpc_client_authentication_method | | NONE | specifies rpc client authentication method. NONE: without authentication. SSL_NO_ENCRYPT: authentication by SSL handshake but not encrypt the communication channel. SSL_IO: authentication by SSL handshake and encrypt the communication channel | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | observer_id | | 13 | the unique id that been assigned by rootservice for each observer in cluster, default: 0 (invalid id), Range: [1, 18446744073709551615] | OBSERVER | CLUSTER | DEFAULT | READONLY | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | local_ip | | 172.31.44.197 | the IP address of the machine on which the ObServer will be installed | OBSERVER | CLUSTER | DEFAULT | READONLY | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | enable_dblink | | True | Enable or disable dblink | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | global_background_cpu_quota | | -1 | When enable_global_background_resource_isolation is True, specify the number of vCPUs allocated to the background tasks-1 for the CPU is not limited by the cgroup | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | enable_global_background_resource_isolation | | False | When set to false, foreground and background tasks are isolated within the tenant; When set to true, isolate background tasks individually upon tenant-level | OBSERVER | CLUSTER | DEFAULT | STATIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | enable_cgroup | | True | when set to false, cgroup will not init; when set to true but cgroup root dir is not ready, print ERROR | OBSERVER | CLUSTER | DEFAULT | STATIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | sql_net_thread_count | | 0 | the number of global mysql I/O threads. Range: [0, 64] in integer, default value is 0, 0 stands for old value GCONF.net_thread_count | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | sql_login_thread_count | | 0 | the number of threads for sql login request. Range: [0, 32] in integer, 0 stands for use default thread count defined in TG.the default thread count for login request in TG is normal:6 mini-mode:2 | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | tcp_keepcnt | | 10 | The maximum number of keepalive probes TCP should send before dropping the connection. Take effect for new established connections. Range: [1,+∞) | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | tcp_keepintvl | | 6s | The time (in seconds) between individual keepalive probes. Take effect for new established connections. Range: [1s, +∞] | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | tcp_keepidle | | 7200s | The time (in seconds) the connection needs to remain idle before TCP starts sending keepalive probe. Take effect for new established connections. Range: [1s, +∞] | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | enable_tcp_keepalive | | True | enable TCP keepalive for the TCP connection of sql protocol. Take effect for new established connections. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | ob_ratelimit_stat_period | | 1s | the time interval to update observer's maximum bandwidth to a certain region. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | enable_ob_ratelimit | | False | enable ratelimit between regions for RPC connection. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | ssl_external_kms_info | | | when using the external key management center for ssl, this parameter will store some key management information | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | use_large_pages | | false | used to manage the database's use of large pages, values: false, true, only | OBSERVER | CLUSTER | DEFAULT | STATIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | schema_history_recycle_interval | | 10m | the time interval between the schedules of schema history recyle task. Range: [0s, +∞) | LOAD_BALANCE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | use_ipv6 | | False | Whether this server uses ipv6 address | OBSERVER | CLUSTER | DEFAULT | STATIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | ssl_client_authentication | | False | enable server SSL support. Takes effect after ca/cert/key file is configured correctly. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | stack_size | | 512K | the size of routine execution stackRange: [512K, 20M] | OBSERVER | CLUSTER | DEFAULT | STATIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | px_task_size | | 2M | to be removed | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | dtl_buffer_size | | 64K | to be removed | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | micro_block_merge_verify_level | | 2 | specify what kind of verification should be done when merging micro block. 0 : no verification will be done 1 : verify encoding algorithm, encoded micro block will be read to ensure data is correct 2 : verify encoding and compression algorithm, besides encoding verification, compressed block will be decompressed to ensure data is correct3 : verify encoding, compression algorithm and lost write protect | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | builtin_db_data_verify_cycle | | 20 | check cycle of db data. Range: [0, 360] in integer. Unit: day. 0: check nothing. 1-360: check all data every specified days. The default value is 20. The real check cycle maybe longer than the specified value for insuring performance. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | tablet_size | | 128M | default tablet size, has to be a multiple of 2M | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | sys_bkgd_migration_change_member_list_timeout | | 20s | the timeout for migration change member list retry. The default value is 20s. Range: [0s,24h] | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | sys_bkgd_migration_retry_num | | 3 | retry num limit during migration. Range: [3, 100] in integer | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | disk_io_thread_count | | 8 | The number of io threads on each disk. The default value is 8. Range: [2,32] in even integer | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | sys_bkgd_net_percentage | | 60 | the net percentage of sys background net. Range: [0, 100] in integer | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | data_disk_usage_limit_percentage | | 98 | the safe use percentage of data diskRange: [50,100] in integer | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | data_storage_error_tolerance_time | | 300s | time to tolerate disk read failure, after that, the disk status will be set error. Range [10s,7200s]. The default value is 300s | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | data_storage_warning_tolerance_time | | 5s | time to tolerate disk read failure, after that, the disk status will be set warning. Range [1s,300s]. The default value is 5s | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | storage_meta_cache_priority | | 10 | storage meta cache priority. Range:[1, ) | CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | fuse_row_cache_priority | | 1 | fuse row cache priority. Range:[1, ) | CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | bf_cache_miss_count_threshold | | 100 | bf cache miss count threshold, 0 means disable bf cache. Range:[0, ) | CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | bf_cache_priority | | 1 | bf cache priority. Range:[1, ) | CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | user_row_cache_priority | | 1 | user row cache priority. Range:[1, ) | CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | user_block_cache_priority | | 1 | user block cache priority. Range:[1, ) | CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | index_block_cache_priority | | 10 | index cache priority. Range:[1, ) | CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | opt_tab_stat_cache_priority | | 1 | tab stat cache priority. Range:[1, ) | CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | tablet_ls_cache_priority | | 1000 | tablet ls cache priority. Range:[1, ) | CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | location_cache_refresh_sql_timeout | | 1s | The timeout used for refreshing location cache by SQL. Range: [1ms, +∞) | LOCATION_CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | location_cache_refresh_rpc_timeout | | 500ms | The timeout used for refreshing location cache by RPC. Range: [1ms, +∞) | LOCATION_CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | all_server_list | | 172.31.32.214:2882,172.31.35.128:2882,172.31.44.197:2882 | all server addr in cluster | LOCATION_CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | location_cache_refresh_min_interval | | 100ms | the time interval in which no request for location cache renewal will be executed. The default value is 100 milliseconds. [0s, +∞) | LOCATION_CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | location_fetch_concurrency | | 20 | the maximum number of the tasks for fetching location cache concurrently. Range: [1, 1000] | LOCATION_CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | location_refresh_thread_count | | 2 | the number of threads for fetching location cache in the background. Range: (1, 64] | LOCATION_CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | virtual_table_location_cache_expire_time | | 8s | expiration time for virtual table location info in partition location cache. Range: [1s, +∞) | LOCATION_CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | standby_fetch_log_bandwidth_limit | | 0MB | the max bandwidth in bytes per second that can be occupied by the sum of the synchronizing log from primary cluster of all servers in the standby cluster | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | rpc_timeout | | 2s | the time during which a RPC request is permitted to execute before it is terminated | RPC | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | ignore_replay_checksum_error | | False | specifies whether error raised from the memtable replay checksum validation can be ignored. Value: True:ignored; False: not ignored | TRANS | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | row_compaction_update_limit | | 6 | maximum update count before trigger row compaction. Range: [1, 6400] | TRANS | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | clog_sync_time_warn_threshold | | 100ms | the time given to the commit log synchronization between a leader and its followers before a \'warning\' message is printed in the log file. Range: [1ms,1000ms] | TRANS | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | trx_2pc_retry_interval | | 100ms | the time interval between the retries in case of failure during a transaction\'s two-phase commit phase. Range: [1ms,5000ms] | TRANS | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | enable_sys_unit_standalone | | False | specifies whether sys unit standalone deployment is turned on. Value: True:turned on False: turned off | LOAD_BALANCE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | server_balance_cpu_mem_tolerance_percent | | 5 | specifies the tolerance (in percentage) of the unbalance of the cpu/memory utilization among all servers. The average cpu/memory utilization is calculated by dividing the total cpu/memory by the number of servers. server balancer will start a rebalancing task when the deviation between the average usage and some server load is greater than this tolerance Range: [1, 100] in percentage | LOAD_BALANCE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | server_balance_disk_tolerance_percent | | 1 | specifies the tolerance (in percentage) of the unbalance of the disk space utilization among all servers. The average disk space utilization is calculated by dividing the total space by the number of servers. server balancer will start a rebalancing task when the deviation between the average usage and some server load is greater than this tolerance Range: [1, 100] in percentage | LOAD_BALANCE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | server_balance_critical_disk_waterlevel | | 80 | disk water level to determine server balance strategy | LOAD_BALANCE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | balancer_log_interval | | 1m | the time interval between logging the load-balancing task\'s statistics. Range: [1s, +∞) | LOAD_BALANCE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | balancer_task_timeout | | 20m | the time to execute the load-balancing task before it is terminated. Range: [1s, +∞) | LOAD_BALANCE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | balancer_tolerance_percentage | | 10 | specifies the tolerance (in percentage) of the unbalance of the disk space utilization among all units. The average disk space utilization is calculated by dividing the total space by the number of units. For example, say balancer_tolerance_percentage is set to 10 and a tenant has two units in the system, the average disk use for each unit should be about the same, thus 50% of the total value. Therefore, the system will start a rebalancing task when any unit\'s disk space goes beyond +-10% of the average usage. Range: [1, 100) in percentage | LOAD_BALANCE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | enable_rereplication | | True | specifies whether the auto-replication is turned on. Value: True:turned on False: turned off | LOAD_BALANCE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | resource_hard_limit | | 100 | system utilization should not be large than resource_hard_limit | LOAD_BALANCE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | log_storage_warning_trigger_percentage | | 0 | The performance decrease percentage threshold that may trigger a log disk failure. The higher the value, the more sensitive it is. The default value is 0, Range: [0,50].The default value is 0, which means the log disk will be considered to have failure only if any IO RT exceeds log_storage_warning_tolerance_time. If the value is greater than 0, which means the log disk will be considered to have failure only if current IO throughput < (normal throughput * log_storage_warning_trigger_percentage / 100) and performance degradation has been ongoing for log_storage_warning_tolerance_time seconds. If the parameter needs to be set, it is recommended to set a value less than 10 to avoid misjudgment. | LOGSERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | log_storage_warning_tolerance_time | | 5s | time to tolerate log disk io delay, after that, the disk status will be set warning. Range: [1s,300s] | LOGSERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | log_disk_percentage | | 0 | the percentage of disk space used by the log files. Range: [0,99] in integer;only effective when parameter log_disk_size is 0;when log_disk_percentage is 0: a) if the data and the log are on the same disk, means log_disk_percentage = 30 b) if the data and the log are on the different disks, means log_disk_perecentage = 90 | LOGSERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | log_disk_size | | 0M | the size of disk space used by the log files. Range: [0, +∞) | LOGSERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | recyclebin_object_expire_time | | 0s | recyclebin object expire time, default 0 that means auto purge recyclebin off. Range: [0s, +∞) | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | ob_event_history_recycle_interval | | 7d | the time to recycle event history. Range: [1d, 180d] | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | enable_major_freeze | | True | specifies whether major_freeze function is turned on. Value: True:turned on; False: turned off | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | enable_ddl | | True | specifies whether DDL operation is turned on. Value: True:turned on; False: turned off | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | min_observer_version | | 4.2.1.7 | the min observer version | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | tablet_meta_table_check_interval | | 30m | the time interval that observer compares tablet meta table with local ls replica info and make adjustments to ensure the correctness of tablet meta table. Range: [1m,+∞) | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | ls_meta_table_check_interval | | 1s | the time interval that observer compares ls meta table with local ls replica info and make adjustments to ensure the correctness of ls meta table. Range: [1ms,+∞) | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | tablet_meta_table_scan_batch_count | | 999 | the number of tablet replica info that will be read by each request on the tablet-related system tables during procedures such as load-balancing, daily merge, election and etc. Range:(0,65536] | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | rootservice_ready_check_interval | | 3s | the interval between the schedule of the rootservice restart task while restart failed Range: [100000us, 1m] | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | server_check_interval | | 30s | the time interval between schedules of a task that examines the __all_server table. Range: [1s, +∞) | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | migration_disable_time | | 3600s | the duration in which the observer stays in the \'block_migrate_in\' status, which means it is not allowed to migrate into the server. Range: [1s, +∞) | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | server_permanent_offline_time | | 60s | the time interval between any two heartbeats beyond which a server is considered to be \'permanently\' offline. Range: [20s,+∞) | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | enable_sys_table_ddl | | False | specifies whether a \'system\' table is allowed be to created manually. Value: True: allowed; False: not allowed | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | rootservice_async_task_queue_size | | 16384 | the size of the queue for all asynchronous tasks at rootserver. Range: [8, 131072] in integer | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | rootservice_async_task_thread_count | | 4 | maximum of threads allowed for executing asynchronous task at rootserver. Range: [1, 10] | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | lease_time | | 10s | Lease for current heartbeat. If the root server does not received any heartbeat from an observer in lease_time seconds, that observer is considered to be offline. Not recommended for modification. Range: [1s, 5m] | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | plan_cache_evict_interval | | 5s | time interval for periodic plan cache eviction. Range: [0s, +∞) | TENANT | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | memstore_limit_percentage | | 50 | used in calculating the value of MEMSTORE_LIMIT parameter: memstore_limit_percentage = memstore_limit / memory_size,memory_size, where MEMORY_SIZE is determined when the tenant is created. Range: (0, 100) | TENANT | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | large_query_threshold | | 5s | threshold for execution time beyond which a request may be paused and rescheduled as a \'large request\'. Range: [1ms, +∞) | TENANT | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | large_query_worker_percentage | | 30 | the percentage of the workers reserved to serve large query request. Range: [0, 100] in percentage | TENANT | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | workers_per_cpu_quota | | 10 | the ratio(integer) between the number of system allocated workers vs the maximum number of threads that can be scheduled concurrently. Range: [2, 20] | TENANT | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | location_cache_cpu_quota | | 5 | the number of vCPUs allocated for the requests regarding location info of the core tables. Range: [0,10] in integer | TENANT | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | server_cpu_quota_max | | 0 | the number of maximal vCPUs allocated to the server tenant(a special internal tenant that exists on every observer). 0 stands for adaptive. Range: [0, 16] | TENANT | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | server_cpu_quota_min | | 0 | the number of minimal vCPUs allocated to the server tenant(a special internal tenant that exists on every observer). 0 stands for adaptive. Range: [0, 16] | TENANT | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | enable_sql_operator_dump | | True | specifies whether sql operators (sort/hash join/material/window function/interm result/...) allowed to write to disk | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | autoinc_cache_refresh_interval | | 3600s | auto-increment service cache refresh sync_value in this interval, with default 3600s. Range: [100ms, +∞) | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | memory_chunk_cache_size | | 0M | the maximum size of memory cached by memory chunk cache. Range: [0M,], 0 stands for adaptive | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | cache_wash_threshold | | 4GB | size of remaining memory at which cache eviction will be triggered. Range: [0,+∞) | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | memory_limit_percentage | | 80 | the size of the memory reserved for internal use(for testing purpose). Range: [10, 95] | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | enable_syslog_recycle | | False | specifies whether log file recycling is turned on. Value: True：turned on; False: turned off | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | enable_syslog_wf | | True | specifies whether any log message with a log level higher than \'WARN\' would be printed into a separate file with a suffix of \'wf\' | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | enable_async_syslog | | True | specifies whether use async log for observer.log, elec.log and rs.log | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | max_syslog_file_count | | 0 | specifies the maximum number of the log files that can co-exist before the log file recycling kicks in. Each log file can occupy at most 256MB disk space. When this value is set to 0, no log file will be removed. Range: [0, +∞) in integer | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | diag_syslog_per_error_limit | | 200 | DIAG syslog limitation for each error per second, exceeding syslog would be truncated | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | syslog_io_bandwidth_limit | | 30MB | Syslog IO bandwidth limitation, exceeding syslog would be truncated. Use 0 to disable ERROR log. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | syslog_level | | WDIAG | specifies the current level of logging. There are DEBUG, TRACE, WDIAG, EDIAG, INFO, WARN, ERROR, seven different log levels. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | obconfig_url | | http://172.31.46.60:8080/services?Action=ObRootServiceInfo&User_ID=alibaba&UID=ocpmaster&ObRegion=release | URL for OBConfig service | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | cluster_id | | 1719287282 | ID of the cluster | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | cluster | | release | Name of the cluster | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | rootservice_list | | 172.31.35.128:2882:2881;172.31.44.197:2882:2881;172.31.32.214:2882:2881 | a list of servers against which election candidate is checked for validation | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | weak_read_version_refresh_interval | | 100ms | the time interval to refresh cluster weak read version Range: [50ms, +∞) | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | default_compress | | archive | default compress strategy for create new table within oracle mode | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | default_row_format | | dynamic | default row format in mysql mode | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | default_compress_func | | zstd_1.3.8 | default compress function name for create new table, values: none, lz4_1.0, snappy_1.0, zlib_1.0, zstd_1.0, zstd_1.3.8 | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | schema_history_expire_time | | 7d | the hour of expire time for schema history, from 1hour to 30days, with default 7days. Range: [1h, 30d] | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | enable_upgrade_mode | | False | specifies whether upgrade mode is turned on. If turned on, daily merger and balancer will be disabled. Value: True: turned on; False: turned off; | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | enable_perf_event | | True | specifies whether to enable perf event feature. The default value is True. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | dead_socket_detection_timeout | | 3s | specify a tcp_user_timeout for RFC5482. A zero value makes the option disabled, Range: [0, 2h] | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | debug_sync_timeout | | 0 | Enable the debug sync facility and optionally specify a default wait timeout in micro seconds. A zero value keeps the facility disabled, Range: [0, +∞] | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | enable_rich_error_msg | | False | specifies whether add ip:port, time and trace id to user error message. The default value is FALSE. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | enable_record_trace_id | | False | specifies whether record app trace id is turned on. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | enable_sql_audit | | True | specifies whether SQL audit is turned on. The default value is TRUE. Value: TRUE: turned on FALSE: turned off | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | max_string_print_length | | 500 | truncate very long string when printing to log file. Range:[0,] | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | enable_record_trace_log | | True | specifies whether to always record the trace log. The default value is True. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | trace_log_slow_query_watermark | | 1s | the threshold of execution time (in milliseconds) of a query beyond which it is considered to be a \'slow query\'. Range: [1ms,+∞) | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | cpu_count | | 20 | the number of CPU\'s in the system. If this parameter is set to zero, the number will be set according to sysconf; otherwise, this parameter is used. Range: [0,+∞) in integer | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | system_memory | | 0M | the memory reserved for internal use which cannot be allocated to any outer-tenant, and should be determined to guarantee every server functions normally. Range: [0M,) | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | memory_limit | | 0M | the size of the memory reserved for internal use(for testing purpose), 0 means follow memory_limit_percentage. Range: 0, [1G,). | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | tenant_task_queue_size | | 16384 | the size of the task queue for each tenant. Range: [1024,+∞) | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | high_priority_net_thread_count | | 0 | the number of rpc I/O threads for high priority messages, 0 means set off. Range: [0, 64] in integer | OBSERVER | CLUSTER | DEFAULT | STATIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | net_thread_count | | 0 | the number of rpc/mysql I/O threads for Libeasy. Range: [0, 64] in integer, 0 stands for max(6, CPU_NUM/8) | OBSERVER | CLUSTER | DEFAULT | STATIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | internal_sql_execute_timeout | | 30s | the number of microseconds an internal DML request is permitted to execute before it is terminated. Range: [1000us, 1h] | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | ob_startup_mode | | NORMAL | specifies the observer startup mode | OBSERVER | CLUSTER | DEFAULT | READONLY | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | zone | | zone3 | specifies the zone name | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | devname | | eth0 | name of network adapter | OBSERVER | CLUSTER | DEFAULT | READONLY | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | mysql_port | | 2881 | port number for mysql connection. Range: (1024, 65536) in integer | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | rpc_port | | 2882 | the port number for RPC protocol. Range: (1024, 65536) in integer | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | leak_mod_to_check | | NONE | the name of the module under memory leak checks | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | config_additional_dir | | /data/log1/release/etc2;/data/1/release/etc3 | additional directories of configure file | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | memory_reserved | | 500M | the size of the system memory reserved for emergency internal use. Range: [10M, total size of memory] | SSTABLE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | datafile_disk_percentage | | 95 | the percentage of disk space used by the data files. Range: [0,99] in integer | SSTABLE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | datafile_maxsize | | 0M | the auto extend max size. Range: [0, +∞) | SSTABLE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | datafile_next | | 0 | the auto extend step. Range: [0, +∞) | SSTABLE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | datafile_size | | 0M | size of the data file. Range: [0, +∞) | SSTABLE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | redundancy_level | | NORMAL | EXTERNAL: use extrernal redundancyNORMAL: tolerate one disk failureHIGH: tolerate two disk failure if disk count is enough | SSTABLE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | data_dir | | /data/oceanbase/store/release | the directory for the data file | SSTABLE | CLUSTER | DEFAULT | READONLY | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | sql_plan_management_mode | | Disable | Specifies how spm work."Disable" represent disable spm (default value)."OnlineEvolve" represent evolve plan online. | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | choose_migration_source_policy | | idc | the policy of choose source in migration and add replica. 'idc' means firstly choose follower replica of the same idc as source, 'region' means firstly choose follower replica of the same region as source | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | lob_enable_block_cache_threshold | | 256K | For outrow-stored LOBs, if the length is less than or equal to that threshold, they can be admitted into the block cache to speed up the next query. | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | json_document_max_depth | | 100 | maximum nesting depth allowed in a JSON document | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | max_partition_num | | 8192 | set max partition num in mysql mode | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | optimizer_index_cost_adj | | 0 | adjust costing of index scan | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | ttl_thread_score | | 0 | the current work thread score of ttl thread. Range: [0,100] in integer. Especially, 0 means default value | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | enable_kv_ttl | | False | specifies whether ttl task is enbled | ROOT_SERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | kv_ttl_history_recycle_interval | | 7d | the time to recycle ttl history. Range: [1d, 180d] | ROOT_SERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | kv_ttl_duty_duration | | | ttl background task working time durationbegin_time or end_time in Range, e.g., [23:00:00, 24:00:00] | ROOT_SERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | range_optimizer_max_mem_size | | 128M | to limit the memory consumption for the query range optimizer. Range: [0M,+∞), 0 stands for unlimited | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | enable_user_defined_rewrite_rules | | False | specify whether the user defined rewrite rules are enabled. Value: True: enable False: disable | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | dump_data_dictionary_to_log_interval | | 24h | data dictionary dump to log(SYS LS) intervalRange: (0s,+∞) | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | tenant_sql_net_thread_count | | 0 | the number of mysql I/O threads for a tenant. Range: [0, 64] in integer, 0 stands for unit_min_cpu | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | tenant_sql_login_thread_count | | 0 | the number of threads for sql login request of each tenant. Range: [0, 32] in integer, 0 stands for unit_min_cpu | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | arbitration_timeout | | 5s | The timeout before automatically degrading when arbitration member exists. Range: [3s,+∞] | TRANS | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | query_response_time_range_base | | 10 | Select base of log for QUERY_RESPONSE_TIME ranges. WARNING: variable change takes affect only after flush.The default value is 10. Range: [2,10000]. | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | query_response_time_flush | | False | Flush QUERY_RESPONSE_TIME table and re-read query_response_time_range_baseThe default value is False. Value: TRUE: trigger flush FALSE: do not trigger | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | query_response_time_stats | | True | Enable or disable QUERY_RESPONSE_TIME statistics collecting, and need enable_sql_audit is True.The default value is True. Value: TRUE: turned on FALSE: turned off | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | default_enable_extended_rowid | | False | specifies whether to create table as extended rowid mode or not | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | ob_query_switch_leader_retry_timeout | | 0ms | max time spend on retry caused by leader swith or network disconnectionRange: [0ms, +∞) | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | default_auto_increment_mode | | order | specifies default auto-increment mode, default is 'order' | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | enable_sql_extension | | False | specifies whether to allow use some oracle mode features in mysql mode | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | job_queue_processes | | 1000 | specifies the maximum number of job slaves per instance that can be created for the execution of DBMS_JOB jobs and Oracle Scheduler (DBMS_SCHEDULER) jobs. | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | ob_proxy_readonly_transaction_routing_policy | | False | Proxy route policy for readonly sql: whether regard begining read only stmts as in transaction | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | connection_control_max_connection_delay | | 2147483647 | The maximum delay in milliseconds for server response to failed connection attempts, if connection_control_failed_connections_threshold is greater than zero | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | connection_control_min_connection_delay | | 1000 | The minimum delay in milliseconds for server response to failed connection attempts, if connection_control_failed_connections_threshold is greater than zero. | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | connection_control_failed_connections_threshold | | 0 | The number of consecutive failed connection attempts permitted to accountsbefore the server adds a delay for subsequent connection attempts | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | open_cursors | | 50 | specifies the maximum number of open cursors a session can have at once.can use this parameter to prevent a session from opening an excessive number of cursors.Range: [0, 65535] in integer | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | ob_ssl_invited_common_names | | NONE | when server use ssl, use it to control client identity with ssl subject common name. default NONE | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | plsql_warnings | | DISABLE::ALL | enables or disables the reporting of warning messages by thePL/SQL compiler, and specifies which warning messages to show as errors | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | plsql_v2_compatibility | | False | allows some abnormal behavior that Version 8 disallows, not available | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | plsql_optimize_level | | 1 | specifies the optimization level that will be used tocompile PL/SQL library units. The higher the setting of this parameter, the more effortthe compiler makes to optimize PL/SQL library units | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | plsql_debug | | False | specifies whether or not PL/SQL library units will be compiled for debugging | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | plsql_code_type | | native | specifies the compilation mode for PL/SQL library units | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | plsql_ccflags | | | provides a mechanism that allows PL/SQL programmers to controlconditional compilation of each PL/SQL library unit independently | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | tde_method | | none | none : transparent encryption is none, none means cannot use tde, internal : transparent encryption is in the form of internal tables, bkmi : transparent encryption is in the form of external bkmi | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | external_kms_info | | | when using the external key management center, this parameter will store some key management information | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | ob_enable_batched_multi_statement | | False | enable use of batched multi statement | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | backup_data_file_size | | 4G | backup data file size. Range: [512M, 4G] in integer | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | audit_trail | | None | enables or disables database auditing, support NONE;OS;DB;DB,EXTENDED;DB_EXTENDED | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | audit_sys_operations | | False | whether trace sys user operations | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | sql_work_area | | 1G | Work area memory limitation for tenant | OBSERVER | TENANT | DEFAULT | STATIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | ob_compaction_schedule_interval | | 120s | the time interval to schedule compaction, Range: [3s,5m]Range: [3s, 5m] | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | major_compact_trigger | | 0 | specifies how many minor freeze should be triggered between two major freeze, Range: [0,65535] in integer | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | minor_compact_trigger | | 2 | minor_compact_trigger, Range: [0,16] in integer | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | ddl_thread_score | | 0 | the current work thread score of ddl thread. Range: [0,100] in integer. Especially, 0 means default value | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | ha_low_thread_score | | 0 | the current work thread score of high availability low thread. Range: [0,100] in integer. Especially, 0 means default value | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | ha_mid_thread_score | | 0 | the current work thread score of high availability mid thread. Range: [0,100] in integer. Especially, 0 means default value | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | ha_high_thread_score | | 0 | the current work thread score of high availability high thread. Range: [0,100] in integer. Especially, 0 means default value | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | compaction_high_thread_score | | 0 | the current work thread score of high priority compaction. Range: [0,100] in integer. Especially, 0 means default value | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | compaction_mid_thread_score | | 0 | the current work thread score of middle priority compaction. Range: [0,100] in integer. Especially, 0 means default value | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | compaction_low_thread_score | | 0 | the current work thread score of low priority compaction. Range: [0,100] in integer. Especially, 0 means default value | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | compaction_schedule_tablet_batch_cnt | | 50000 | the batch size when scheduling tablet to execute compaction task. Range: [10000,200000] in integer. default value is 50000 | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | compaction_dag_cnt_limit | | 15000 | the compaction dag count limit. Range: [10000,200000] in integer. default value is 15000 | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | rpc_memory_limit_percentage | | 0 | maximum memory for rpc in a tenant, as a percentage of total tenant memory, and 0 means no limit to rpc memory | RPC | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | enable_early_lock_release | | True | enable early lock release | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | merger_check_interval | | 10m | the time interval between the schedules of the task that checks on the progress of MERGE for each zone. Range: [10s, 60m] | DAILY_MERGE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | major_freeze_duty_time | | 02:00 | the start time of system daily merge procedure. Range: [00:00, 24:00) | DAILY_MERGE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | partition_balance_schedule_interval | | 2h | the time interval between generate partition balance task. The value should be no less than balancer_idle_time to enable partition balance. Default value 2h and the value 0s means disable partition balance. Range: [0s, +∞) | LOAD_BALANCE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | balancer_idle_time | | 10s | the time interval between the schedules of the tenant load-balancing task. Range: [10s, +∞) | LOAD_BALANCE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | enable_transfer | | True | controls whether transfers are allowed in the tenant. This config does not take effect when enable_rebalance is disabled. Value: True:turned on False:turned off | LOAD_BALANCE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | enable_rebalance | | True | specifies whether the tenant load-balancing is turned on. Value: True:turned on False: turned off | LOAD_BALANCE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | standby_db_preferred_upstream_log_region | | | The preferred upstream log region for Standby db. The Standby db will give priority to the preferred upstream log region to fetch log. For high availability，the Standby db will also switch to the other region when the preferred upstream log region can not fetch log because of exception etc. | LOGSERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | archive_lag_target | | 120s | The lag target of the log archive. The log archive target affects not only the backup availability, but also the lag of the standby database based on archive. Values larger than 7200s are not reasonable lag. The typical value is 120s. Extremely low values can result in high IOPS, which is not optimal for object storage; such values can also affect the performance of the database. The value 0ms means to archive as soon as possible. Range: [0ms,7200s] | LOGSERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | standby_db_fetch_log_rpc_timeout | | 15s | The threshold for detecting the RPC timeout for the standby tenant to fetch log from the log restore source tenant. When the rpc timeout, the log transport service switches to another server of the log restore source tenant to fetch logs. Range: [2s, +∞) | LOGSERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | ls_gc_delay_time | | 0s | The max delay time for ls gc when log archive is off. The default value is 0s. Range: [0s, +∞). The ls delay deletion mechanism will no longer take effect when the tenant is dropped. | LOGSERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | log_disk_throttling_maximum_duration | | 2h | maximum duration of log disk throttling, that is the time remaining until the log disk space is exhausted after log disk throttling triggered. | LOGSERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | log_disk_throttling_percentage | | 60 | the threshold of the size of the log disk when writing_limit will be triggered. Rang:[40,100]. setting 100 means turn off writing limit | LOGSERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | log_disk_utilization_threshold | | 80 | log disk utilization threshold before reuse log files, should be smaller than log_disk_utilization_limit_threshold. Range: [10, 100) | LOGSERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | log_disk_utilization_limit_threshold | | 95 | maximum of log disk usage percentage before stop submitting or receiving logs, should be bigger than log_disk_utilization_threshold. Range: [80, 100] | LOGSERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | log_archive_concurrency | | 0 | log archive concurrency, for both archive fetcher and sender. If the value is default 0, the database will automatically calculate the number of archive worker threads based on the tenant specification, which is tenant max_cpu divided by 4; otherwise set the the worker count equals to the value.Range: [0, 100] in integer | LOGSERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | log_restore_concurrency | | 0 | log restore concurrency, for both the restore tenant and standby tenant. If the value is default 0, the database will automatically calculate the number of restore worker threads based on the tenant specification, which is tenant max_cpu; otherwise set the the worker count equals to the value.Range: [0, 100] in integer | LOGSERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | log_storage_compress_func | | lz4_1.0 | specifies the algorithms used for log storage compression. Values: lz4_1.0, zstd_1.0, zstd_1.3.8 | LOGSERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | log_storage_compress_all | | False | specifies whether to compress logs before storing. The default is false(no compression) | LOGSERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | log_transport_compress_func | | lz4_1.0 | compressor used for log transport. Values: none, lz4_1.0, zstd_1.0, zstd_1.3.8 | LOGSERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | log_transport_compress_all | | False | If this option is set to true, use compression for log transport. The default is false(no compression) | LOGSERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | compatible | | 4.2.1.7 | compatible version for persisted data | ROOT_SERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | workarea_size_policy | | AUTO | policy used to size SQL working areas (MANUAL/AUTO) | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | default_progressive_merge_num | | 0 | default progressive_merge_num when tenant create tableRange:[0,) | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | writing_throttling_maximum_duration | | 2h | maximum duration of writting throttling(in minutes), max value is 3 days | TRANS | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | writing_throttling_trigger_percentage | | 60 | the threshold of the size of the mem store when writing_limit will be triggered. Rang:(0,100]. setting 100 means turn off writing limit | TRANS | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | freeze_trigger_percentage | | 20 | the threshold of the size of the mem store when freeze will be triggered. Rang:(0,100) | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | undo_retention | | 1800 | the low threshold value of undo retention. The system retains undo for at least the time specified in this config when active txn protection is banned. Range: [0, 4294967295] | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | px_workers_per_cpu_quota | | 10 | the ratio(integer) between the number of system allocated px workers vs the maximum number of threads that can be scheduled concurrently. Range: [0, 20] | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | cpu_quota_concurrency | | 10 | max allowed concurrency for 1 CPU quota. Range: [1,20] | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | enable_monotonic_weak_read | | False | specifies observer supportting atomicity and monotonic order read | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | max_stale_time_for_weak_consistency | | 5s | the max data stale time that cluster weak read version behind current timestamp,no smaller than weak_read_version_refresh_interval, range: [5s, +∞) | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | kv_transport_compress_threshold | | 10K | Together with the configuration item kv_transport_compress_func, it is used to specify the minimum threshold size of the OBKV query result set that needs to be compressed. Range: [0, +∞) | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone3 | observer | 172.31.44.197 | 2882 | kv_transport_compress_func | | none | compressor used for tableAPI query result. Values: none, lz4_1.0, snappy_1.0, zlib_1.0, zstd_1.0 zstd 1.3.8 | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | sql_protocol_min_tls_version | | none | SQL SSL control options, used to specify the minimum SSL/TLS version number. values: none, TLSv1, TLSv1.1, TLSv1.2, TLSv1.3 | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | rpc_server_authentication_method | | ALL | specifies rpc server authentication method. ALL: support all authentication methods. NONE: without authentication. SSL_NO_ENCRYPT: authentication by SSL handshake but not encrypt the communication channel. SSL_IO: authentication by SSL handshake and encrypt the communication channel | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | rpc_client_authentication_method | | NONE | specifies rpc client authentication method. NONE: without authentication. SSL_NO_ENCRYPT: authentication by SSL handshake but not encrypt the communication channel. SSL_IO: authentication by SSL handshake and encrypt the communication channel | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | observer_id | | 12 | the unique id that been assigned by rootservice for each observer in cluster, default: 0 (invalid id), Range: [1, 18446744073709551615] | OBSERVER | CLUSTER | DEFAULT | READONLY | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | local_ip | | 172.31.32.214 | the IP address of the machine on which the ObServer will be installed | OBSERVER | CLUSTER | DEFAULT | READONLY | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | enable_dblink | | True | Enable or disable dblink | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | global_background_cpu_quota | | -1 | When enable_global_background_resource_isolation is True, specify the number of vCPUs allocated to the background tasks-1 for the CPU is not limited by the cgroup | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | enable_global_background_resource_isolation | | False | When set to false, foreground and background tasks are isolated within the tenant; When set to true, isolate background tasks individually upon tenant-level | OBSERVER | CLUSTER | DEFAULT | STATIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | enable_cgroup | | True | when set to false, cgroup will not init; when set to true but cgroup root dir is not ready, print ERROR | OBSERVER | CLUSTER | DEFAULT | STATIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | sql_net_thread_count | | 0 | the number of global mysql I/O threads. Range: [0, 64] in integer, default value is 0, 0 stands for old value GCONF.net_thread_count | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | sql_login_thread_count | | 0 | the number of threads for sql login request. Range: [0, 32] in integer, 0 stands for use default thread count defined in TG.the default thread count for login request in TG is normal:6 mini-mode:2 | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | tcp_keepcnt | | 10 | The maximum number of keepalive probes TCP should send before dropping the connection. Take effect for new established connections. Range: [1,+∞) | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | tcp_keepintvl | | 6s | The time (in seconds) between individual keepalive probes. Take effect for new established connections. Range: [1s, +∞] | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | tcp_keepidle | | 7200s | The time (in seconds) the connection needs to remain idle before TCP starts sending keepalive probe. Take effect for new established connections. Range: [1s, +∞] | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | enable_tcp_keepalive | | True | enable TCP keepalive for the TCP connection of sql protocol. Take effect for new established connections. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | ob_ratelimit_stat_period | | 1s | the time interval to update observer's maximum bandwidth to a certain region. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | enable_ob_ratelimit | | False | enable ratelimit between regions for RPC connection. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | ssl_external_kms_info | | | when using the external key management center for ssl, this parameter will store some key management information | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | use_large_pages | | false | used to manage the database's use of large pages, values: false, true, only | OBSERVER | CLUSTER | DEFAULT | STATIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | schema_history_recycle_interval | | 10m | the time interval between the schedules of schema history recyle task. Range: [0s, +∞) | LOAD_BALANCE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | use_ipv6 | | False | Whether this server uses ipv6 address | OBSERVER | CLUSTER | DEFAULT | STATIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | ssl_client_authentication | | False | enable server SSL support. Takes effect after ca/cert/key file is configured correctly. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | stack_size | | 512K | the size of routine execution stackRange: [512K, 20M] | OBSERVER | CLUSTER | DEFAULT | STATIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | px_task_size | | 2M | to be removed | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | dtl_buffer_size | | 64K | to be removed | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | micro_block_merge_verify_level | | 2 | specify what kind of verification should be done when merging micro block. 0 : no verification will be done 1 : verify encoding algorithm, encoded micro block will be read to ensure data is correct 2 : verify encoding and compression algorithm, besides encoding verification, compressed block will be decompressed to ensure data is correct3 : verify encoding, compression algorithm and lost write protect | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | builtin_db_data_verify_cycle | | 20 | check cycle of db data. Range: [0, 360] in integer. Unit: day. 0: check nothing. 1-360: check all data every specified days. The default value is 20. The real check cycle maybe longer than the specified value for insuring performance. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | tablet_size | | 128M | default tablet size, has to be a multiple of 2M | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | sys_bkgd_migration_change_member_list_timeout | | 20s | the timeout for migration change member list retry. The default value is 20s. Range: [0s,24h] | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | sys_bkgd_migration_retry_num | | 3 | retry num limit during migration. Range: [3, 100] in integer | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | disk_io_thread_count | | 8 | The number of io threads on each disk. The default value is 8. Range: [2,32] in even integer | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | sys_bkgd_net_percentage | | 60 | the net percentage of sys background net. Range: [0, 100] in integer | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | data_disk_usage_limit_percentage | | 98 | the safe use percentage of data diskRange: [50,100] in integer | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | data_storage_error_tolerance_time | | 300s | time to tolerate disk read failure, after that, the disk status will be set error. Range [10s,7200s]. The default value is 300s | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | data_storage_warning_tolerance_time | | 5s | time to tolerate disk read failure, after that, the disk status will be set warning. Range [1s,300s]. The default value is 5s | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | storage_meta_cache_priority | | 10 | storage meta cache priority. Range:[1, ) | CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | fuse_row_cache_priority | | 1 | fuse row cache priority. Range:[1, ) | CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | bf_cache_miss_count_threshold | | 100 | bf cache miss count threshold, 0 means disable bf cache. Range:[0, ) | CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | bf_cache_priority | | 1 | bf cache priority. Range:[1, ) | CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | user_row_cache_priority | | 1 | user row cache priority. Range:[1, ) | CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | user_block_cache_priority | | 1 | user block cache priority. Range:[1, ) | CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | index_block_cache_priority | | 10 | index cache priority. Range:[1, ) | CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | opt_tab_stat_cache_priority | | 1 | tab stat cache priority. Range:[1, ) | CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | tablet_ls_cache_priority | | 1000 | tablet ls cache priority. Range:[1, ) | CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | location_cache_refresh_sql_timeout | | 1s | The timeout used for refreshing location cache by SQL. Range: [1ms, +∞) | LOCATION_CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | location_cache_refresh_rpc_timeout | | 500ms | The timeout used for refreshing location cache by RPC. Range: [1ms, +∞) | LOCATION_CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | all_server_list | | 172.31.32.214:2882,172.31.35.128:2882,172.31.44.197:2882 | all server addr in cluster | LOCATION_CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | location_cache_refresh_min_interval | | 100ms | the time interval in which no request for location cache renewal will be executed. The default value is 100 milliseconds. [0s, +∞) | LOCATION_CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | location_fetch_concurrency | | 20 | the maximum number of the tasks for fetching location cache concurrently. Range: [1, 1000] | LOCATION_CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | location_refresh_thread_count | | 2 | the number of threads for fetching location cache in the background. Range: (1, 64] | LOCATION_CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | virtual_table_location_cache_expire_time | | 8s | expiration time for virtual table location info in partition location cache. Range: [1s, +∞) | LOCATION_CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | standby_fetch_log_bandwidth_limit | | 0MB | the max bandwidth in bytes per second that can be occupied by the sum of the synchronizing log from primary cluster of all servers in the standby cluster | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | rpc_timeout | | 2s | the time during which a RPC request is permitted to execute before it is terminated | RPC | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | ignore_replay_checksum_error | | False | specifies whether error raised from the memtable replay checksum validation can be ignored. Value: True:ignored; False: not ignored | TRANS | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | row_compaction_update_limit | | 6 | maximum update count before trigger row compaction. Range: [1, 6400] | TRANS | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | clog_sync_time_warn_threshold | | 100ms | the time given to the commit log synchronization between a leader and its followers before a \'warning\' message is printed in the log file. Range: [1ms,1000ms] | TRANS | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | trx_2pc_retry_interval | | 100ms | the time interval between the retries in case of failure during a transaction\'s two-phase commit phase. Range: [1ms,5000ms] | TRANS | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | enable_sys_unit_standalone | | False | specifies whether sys unit standalone deployment is turned on. Value: True:turned on False: turned off | LOAD_BALANCE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | server_balance_cpu_mem_tolerance_percent | | 5 | specifies the tolerance (in percentage) of the unbalance of the cpu/memory utilization among all servers. The average cpu/memory utilization is calculated by dividing the total cpu/memory by the number of servers. server balancer will start a rebalancing task when the deviation between the average usage and some server load is greater than this tolerance Range: [1, 100] in percentage | LOAD_BALANCE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | server_balance_disk_tolerance_percent | | 1 | specifies the tolerance (in percentage) of the unbalance of the disk space utilization among all servers. The average disk space utilization is calculated by dividing the total space by the number of servers. server balancer will start a rebalancing task when the deviation between the average usage and some server load is greater than this tolerance Range: [1, 100] in percentage | LOAD_BALANCE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | server_balance_critical_disk_waterlevel | | 80 | disk water level to determine server balance strategy | LOAD_BALANCE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | balancer_log_interval | | 1m | the time interval between logging the load-balancing task\'s statistics. Range: [1s, +∞) | LOAD_BALANCE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | balancer_task_timeout | | 20m | the time to execute the load-balancing task before it is terminated. Range: [1s, +∞) | LOAD_BALANCE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | balancer_tolerance_percentage | | 10 | specifies the tolerance (in percentage) of the unbalance of the disk space utilization among all units. The average disk space utilization is calculated by dividing the total space by the number of units. For example, say balancer_tolerance_percentage is set to 10 and a tenant has two units in the system, the average disk use for each unit should be about the same, thus 50% of the total value. Therefore, the system will start a rebalancing task when any unit\'s disk space goes beyond +-10% of the average usage. Range: [1, 100) in percentage | LOAD_BALANCE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | enable_rereplication | | True | specifies whether the auto-replication is turned on. Value: True:turned on False: turned off | LOAD_BALANCE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | resource_hard_limit | | 100 | system utilization should not be large than resource_hard_limit | LOAD_BALANCE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | log_storage_warning_trigger_percentage | | 0 | The performance decrease percentage threshold that may trigger a log disk failure. The higher the value, the more sensitive it is. The default value is 0, Range: [0,50].The default value is 0, which means the log disk will be considered to have failure only if any IO RT exceeds log_storage_warning_tolerance_time. If the value is greater than 0, which means the log disk will be considered to have failure only if current IO throughput < (normal throughput * log_storage_warning_trigger_percentage / 100) and performance degradation has been ongoing for log_storage_warning_tolerance_time seconds. If the parameter needs to be set, it is recommended to set a value less than 10 to avoid misjudgment. | LOGSERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | log_storage_warning_tolerance_time | | 5s | time to tolerate log disk io delay, after that, the disk status will be set warning. Range: [1s,300s] | LOGSERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | log_disk_percentage | | 0 | the percentage of disk space used by the log files. Range: [0,99] in integer;only effective when parameter log_disk_size is 0;when log_disk_percentage is 0: a) if the data and the log are on the same disk, means log_disk_percentage = 30 b) if the data and the log are on the different disks, means log_disk_perecentage = 90 | LOGSERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | log_disk_size | | 0M | the size of disk space used by the log files. Range: [0, +∞) | LOGSERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | recyclebin_object_expire_time | | 0s | recyclebin object expire time, default 0 that means auto purge recyclebin off. Range: [0s, +∞) | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | ob_event_history_recycle_interval | | 7d | the time to recycle event history. Range: [1d, 180d] | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | enable_major_freeze | | True | specifies whether major_freeze function is turned on. Value: True:turned on; False: turned off | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | enable_ddl | | True | specifies whether DDL operation is turned on. Value: True:turned on; False: turned off | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | min_observer_version | | 4.2.1.7 | the min observer version | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | tablet_meta_table_check_interval | | 30m | the time interval that observer compares tablet meta table with local ls replica info and make adjustments to ensure the correctness of tablet meta table. Range: [1m,+∞) | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | ls_meta_table_check_interval | | 1s | the time interval that observer compares ls meta table with local ls replica info and make adjustments to ensure the correctness of ls meta table. Range: [1ms,+∞) | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | tablet_meta_table_scan_batch_count | | 999 | the number of tablet replica info that will be read by each request on the tablet-related system tables during procedures such as load-balancing, daily merge, election and etc. Range:(0,65536] | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | rootservice_ready_check_interval | | 3s | the interval between the schedule of the rootservice restart task while restart failed Range: [100000us, 1m] | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | server_check_interval | | 30s | the time interval between schedules of a task that examines the __all_server table. Range: [1s, +∞) | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | migration_disable_time | | 3600s | the duration in which the observer stays in the \'block_migrate_in\' status, which means it is not allowed to migrate into the server. Range: [1s, +∞) | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | server_permanent_offline_time | | 60s | the time interval between any two heartbeats beyond which a server is considered to be \'permanently\' offline. Range: [20s,+∞) | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | enable_sys_table_ddl | | False | specifies whether a \'system\' table is allowed be to created manually. Value: True: allowed; False: not allowed | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | rootservice_async_task_queue_size | | 16384 | the size of the queue for all asynchronous tasks at rootserver. Range: [8, 131072] in integer | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | rootservice_async_task_thread_count | | 4 | maximum of threads allowed for executing asynchronous task at rootserver. Range: [1, 10] | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | lease_time | | 10s | Lease for current heartbeat. If the root server does not received any heartbeat from an observer in lease_time seconds, that observer is considered to be offline. Not recommended for modification. Range: [1s, 5m] | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | plan_cache_evict_interval | | 5s | time interval for periodic plan cache eviction. Range: [0s, +∞) | TENANT | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | memstore_limit_percentage | | 50 | used in calculating the value of MEMSTORE_LIMIT parameter: memstore_limit_percentage = memstore_limit / memory_size,memory_size, where MEMORY_SIZE is determined when the tenant is created. Range: (0, 100) | TENANT | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | large_query_threshold | | 5s | threshold for execution time beyond which a request may be paused and rescheduled as a \'large request\'. Range: [1ms, +∞) | TENANT | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | large_query_worker_percentage | | 30 | the percentage of the workers reserved to serve large query request. Range: [0, 100] in percentage | TENANT | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | workers_per_cpu_quota | | 10 | the ratio(integer) between the number of system allocated workers vs the maximum number of threads that can be scheduled concurrently. Range: [2, 20] | TENANT | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | location_cache_cpu_quota | | 5 | the number of vCPUs allocated for the requests regarding location info of the core tables. Range: [0,10] in integer | TENANT | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | server_cpu_quota_max | | 0 | the number of maximal vCPUs allocated to the server tenant(a special internal tenant that exists on every observer). 0 stands for adaptive. Range: [0, 16] | TENANT | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | server_cpu_quota_min | | 0 | the number of minimal vCPUs allocated to the server tenant(a special internal tenant that exists on every observer). 0 stands for adaptive. Range: [0, 16] | TENANT | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | enable_sql_operator_dump | | True | specifies whether sql operators (sort/hash join/material/window function/interm result/...) allowed to write to disk | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | autoinc_cache_refresh_interval | | 3600s | auto-increment service cache refresh sync_value in this interval, with default 3600s. Range: [100ms, +∞) | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | memory_chunk_cache_size | | 0M | the maximum size of memory cached by memory chunk cache. Range: [0M,], 0 stands for adaptive | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | cache_wash_threshold | | 4GB | size of remaining memory at which cache eviction will be triggered. Range: [0,+∞) | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | memory_limit_percentage | | 80 | the size of the memory reserved for internal use(for testing purpose). Range: [10, 95] | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | enable_syslog_recycle | | False | specifies whether log file recycling is turned on. Value: True：turned on; False: turned off | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | enable_syslog_wf | | True | specifies whether any log message with a log level higher than \'WARN\' would be printed into a separate file with a suffix of \'wf\' | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | enable_async_syslog | | True | specifies whether use async log for observer.log, elec.log and rs.log | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | max_syslog_file_count | | 0 | specifies the maximum number of the log files that can co-exist before the log file recycling kicks in. Each log file can occupy at most 256MB disk space. When this value is set to 0, no log file will be removed. Range: [0, +∞) in integer | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | diag_syslog_per_error_limit | | 200 | DIAG syslog limitation for each error per second, exceeding syslog would be truncated | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | syslog_io_bandwidth_limit | | 30MB | Syslog IO bandwidth limitation, exceeding syslog would be truncated. Use 0 to disable ERROR log. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | syslog_level | | WDIAG | specifies the current level of logging. There are DEBUG, TRACE, WDIAG, EDIAG, INFO, WARN, ERROR, seven different log levels. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | obconfig_url | | http://172.31.46.60:8080/services?Action=ObRootServiceInfo&User_ID=alibaba&UID=ocpmaster&ObRegion=release | URL for OBConfig service | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | cluster_id | | 1719287282 | ID of the cluster | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | cluster | | release | Name of the cluster | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | rootservice_list | | 172.31.35.128:2882:2881;172.31.44.197:2882:2881;172.31.32.214:2882:2881 | a list of servers against which election candidate is checked for validation | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | weak_read_version_refresh_interval | | 100ms | the time interval to refresh cluster weak read version Range: [50ms, +∞) | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | default_compress | | archive | default compress strategy for create new table within oracle mode | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | default_row_format | | dynamic | default row format in mysql mode | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | default_compress_func | | zstd_1.3.8 | default compress function name for create new table, values: none, lz4_1.0, snappy_1.0, zlib_1.0, zstd_1.0, zstd_1.3.8 | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | schema_history_expire_time | | 7d | the hour of expire time for schema history, from 1hour to 30days, with default 7days. Range: [1h, 30d] | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | enable_upgrade_mode | | False | specifies whether upgrade mode is turned on. If turned on, daily merger and balancer will be disabled. Value: True: turned on; False: turned off; | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | enable_perf_event | | True | specifies whether to enable perf event feature. The default value is True. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | dead_socket_detection_timeout | | 3s | specify a tcp_user_timeout for RFC5482. A zero value makes the option disabled, Range: [0, 2h] | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | debug_sync_timeout | | 0 | Enable the debug sync facility and optionally specify a default wait timeout in micro seconds. A zero value keeps the facility disabled, Range: [0, +∞] | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | enable_rich_error_msg | | False | specifies whether add ip:port, time and trace id to user error message. The default value is FALSE. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | enable_record_trace_id | | False | specifies whether record app trace id is turned on. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | enable_sql_audit | | True | specifies whether SQL audit is turned on. The default value is TRUE. Value: TRUE: turned on FALSE: turned off | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | max_string_print_length | | 500 | truncate very long string when printing to log file. Range:[0,] | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | enable_record_trace_log | | True | specifies whether to always record the trace log. The default value is True. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | trace_log_slow_query_watermark | | 1s | the threshold of execution time (in milliseconds) of a query beyond which it is considered to be a \'slow query\'. Range: [1ms,+∞) | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | cpu_count | | 20 | the number of CPU\'s in the system. If this parameter is set to zero, the number will be set according to sysconf; otherwise, this parameter is used. Range: [0,+∞) in integer | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | system_memory | | 0M | the memory reserved for internal use which cannot be allocated to any outer-tenant, and should be determined to guarantee every server functions normally. Range: [0M,) | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | memory_limit | | 0M | the size of the memory reserved for internal use(for testing purpose), 0 means follow memory_limit_percentage. Range: 0, [1G,). | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | tenant_task_queue_size | | 16384 | the size of the task queue for each tenant. Range: [1024,+∞) | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | high_priority_net_thread_count | | 0 | the number of rpc I/O threads for high priority messages, 0 means set off. Range: [0, 64] in integer | OBSERVER | CLUSTER | DEFAULT | STATIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | net_thread_count | | 0 | the number of rpc/mysql I/O threads for Libeasy. Range: [0, 64] in integer, 0 stands for max(6, CPU_NUM/8) | OBSERVER | CLUSTER | DEFAULT | STATIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | internal_sql_execute_timeout | | 30s | the number of microseconds an internal DML request is permitted to execute before it is terminated. Range: [1000us, 1h] | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | ob_startup_mode | | NORMAL | specifies the observer startup mode | OBSERVER | CLUSTER | DEFAULT | READONLY | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | zone | | zone2 | specifies the zone name | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | devname | | eth0 | name of network adapter | OBSERVER | CLUSTER | DEFAULT | READONLY | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | mysql_port | | 2881 | port number for mysql connection. Range: (1024, 65536) in integer | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | rpc_port | | 2882 | the port number for RPC protocol. Range: (1024, 65536) in integer | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | leak_mod_to_check | | NONE | the name of the module under memory leak checks | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | config_additional_dir | | /data/log1/release/etc2;/data/1/release/etc3 | additional directories of configure file | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | memory_reserved | | 500M | the size of the system memory reserved for emergency internal use. Range: [10M, total size of memory] | SSTABLE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | datafile_disk_percentage | | 95 | the percentage of disk space used by the data files. Range: [0,99] in integer | SSTABLE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | datafile_maxsize | | 0M | the auto extend max size. Range: [0, +∞) | SSTABLE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | datafile_next | | 0 | the auto extend step. Range: [0, +∞) | SSTABLE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | datafile_size | | 0M | size of the data file. Range: [0, +∞) | SSTABLE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | redundancy_level | | NORMAL | EXTERNAL: use extrernal redundancyNORMAL: tolerate one disk failureHIGH: tolerate two disk failure if disk count is enough | SSTABLE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | data_dir | | /data/oceanbase/store/release | the directory for the data file | SSTABLE | CLUSTER | DEFAULT | READONLY | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | sql_plan_management_mode | | Disable | Specifies how spm work."Disable" represent disable spm (default value)."OnlineEvolve" represent evolve plan online. | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | choose_migration_source_policy | | idc | the policy of choose source in migration and add replica. 'idc' means firstly choose follower replica of the same idc as source, 'region' means firstly choose follower replica of the same region as source | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | lob_enable_block_cache_threshold | | 256K | For outrow-stored LOBs, if the length is less than or equal to that threshold, they can be admitted into the block cache to speed up the next query. | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | json_document_max_depth | | 100 | maximum nesting depth allowed in a JSON document | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | max_partition_num | | 8192 | set max partition num in mysql mode | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | optimizer_index_cost_adj | | 0 | adjust costing of index scan | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | ttl_thread_score | | 0 | the current work thread score of ttl thread. Range: [0,100] in integer. Especially, 0 means default value | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | enable_kv_ttl | | False | specifies whether ttl task is enbled | ROOT_SERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | kv_ttl_history_recycle_interval | | 7d | the time to recycle ttl history. Range: [1d, 180d] | ROOT_SERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | kv_ttl_duty_duration | | | ttl background task working time durationbegin_time or end_time in Range, e.g., [23:00:00, 24:00:00] | ROOT_SERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | range_optimizer_max_mem_size | | 128M | to limit the memory consumption for the query range optimizer. Range: [0M,+∞), 0 stands for unlimited | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | enable_user_defined_rewrite_rules | | False | specify whether the user defined rewrite rules are enabled. Value: True: enable False: disable | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | dump_data_dictionary_to_log_interval | | 24h | data dictionary dump to log(SYS LS) intervalRange: (0s,+∞) | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | tenant_sql_net_thread_count | | 0 | the number of mysql I/O threads for a tenant. Range: [0, 64] in integer, 0 stands for unit_min_cpu | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | tenant_sql_login_thread_count | | 0 | the number of threads for sql login request of each tenant. Range: [0, 32] in integer, 0 stands for unit_min_cpu | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | arbitration_timeout | | 5s | The timeout before automatically degrading when arbitration member exists. Range: [3s,+∞] | TRANS | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | query_response_time_range_base | | 10 | Select base of log for QUERY_RESPONSE_TIME ranges. WARNING: variable change takes affect only after flush.The default value is 10. Range: [2,10000]. | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | query_response_time_flush | | False | Flush QUERY_RESPONSE_TIME table and re-read query_response_time_range_baseThe default value is False. Value: TRUE: trigger flush FALSE: do not trigger | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | query_response_time_stats | | True | Enable or disable QUERY_RESPONSE_TIME statistics collecting, and need enable_sql_audit is True.The default value is True. Value: TRUE: turned on FALSE: turned off | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | default_enable_extended_rowid | | False | specifies whether to create table as extended rowid mode or not | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | ob_query_switch_leader_retry_timeout | | 0ms | max time spend on retry caused by leader swith or network disconnectionRange: [0ms, +∞) | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | default_auto_increment_mode | | order | specifies default auto-increment mode, default is 'order' | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | enable_sql_extension | | False | specifies whether to allow use some oracle mode features in mysql mode | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | job_queue_processes | | 1000 | specifies the maximum number of job slaves per instance that can be created for the execution of DBMS_JOB jobs and Oracle Scheduler (DBMS_SCHEDULER) jobs. | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | ob_proxy_readonly_transaction_routing_policy | | False | Proxy route policy for readonly sql: whether regard begining read only stmts as in transaction | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | connection_control_max_connection_delay | | 2147483647 | The maximum delay in milliseconds for server response to failed connection attempts, if connection_control_failed_connections_threshold is greater than zero | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | connection_control_min_connection_delay | | 1000 | The minimum delay in milliseconds for server response to failed connection attempts, if connection_control_failed_connections_threshold is greater than zero. | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | connection_control_failed_connections_threshold | | 0 | The number of consecutive failed connection attempts permitted to accountsbefore the server adds a delay for subsequent connection attempts | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | open_cursors | | 50 | specifies the maximum number of open cursors a session can have at once.can use this parameter to prevent a session from opening an excessive number of cursors.Range: [0, 65535] in integer | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | ob_ssl_invited_common_names | | NONE | when server use ssl, use it to control client identity with ssl subject common name. default NONE | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | plsql_warnings | | DISABLE::ALL | enables or disables the reporting of warning messages by thePL/SQL compiler, and specifies which warning messages to show as errors | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | plsql_v2_compatibility | | False | allows some abnormal behavior that Version 8 disallows, not available | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | plsql_optimize_level | | 1 | specifies the optimization level that will be used tocompile PL/SQL library units. The higher the setting of this parameter, the more effortthe compiler makes to optimize PL/SQL library units | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | plsql_debug | | False | specifies whether or not PL/SQL library units will be compiled for debugging | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | plsql_code_type | | native | specifies the compilation mode for PL/SQL library units | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | plsql_ccflags | | | provides a mechanism that allows PL/SQL programmers to controlconditional compilation of each PL/SQL library unit independently | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | tde_method | | none | none : transparent encryption is none, none means cannot use tde, internal : transparent encryption is in the form of internal tables, bkmi : transparent encryption is in the form of external bkmi | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | external_kms_info | | | when using the external key management center, this parameter will store some key management information | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | ob_enable_batched_multi_statement | | False | enable use of batched multi statement | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | backup_data_file_size | | 4G | backup data file size. Range: [512M, 4G] in integer | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | audit_trail | | None | enables or disables database auditing, support NONE;OS;DB;DB,EXTENDED;DB_EXTENDED | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | audit_sys_operations | | False | whether trace sys user operations | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | sql_work_area | | 1G | Work area memory limitation for tenant | OBSERVER | TENANT | DEFAULT | STATIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | ob_compaction_schedule_interval | | 120s | the time interval to schedule compaction, Range: [3s,5m]Range: [3s, 5m] | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | major_compact_trigger | | 0 | specifies how many minor freeze should be triggered between two major freeze, Range: [0,65535] in integer | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | minor_compact_trigger | | 2 | minor_compact_trigger, Range: [0,16] in integer | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | ddl_thread_score | | 0 | the current work thread score of ddl thread. Range: [0,100] in integer. Especially, 0 means default value | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | ha_low_thread_score | | 0 | the current work thread score of high availability low thread. Range: [0,100] in integer. Especially, 0 means default value | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | ha_mid_thread_score | | 0 | the current work thread score of high availability mid thread. Range: [0,100] in integer. Especially, 0 means default value | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | ha_high_thread_score | | 0 | the current work thread score of high availability high thread. Range: [0,100] in integer. Especially, 0 means default value | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | compaction_high_thread_score | | 0 | the current work thread score of high priority compaction. Range: [0,100] in integer. Especially, 0 means default value | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | compaction_mid_thread_score | | 0 | the current work thread score of middle priority compaction. Range: [0,100] in integer. Especially, 0 means default value | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | compaction_low_thread_score | | 0 | the current work thread score of low priority compaction. Range: [0,100] in integer. Especially, 0 means default value | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | compaction_schedule_tablet_batch_cnt | | 50000 | the batch size when scheduling tablet to execute compaction task. Range: [10000,200000] in integer. default value is 50000 | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | compaction_dag_cnt_limit | | 15000 | the compaction dag count limit. Range: [10000,200000] in integer. default value is 15000 | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | rpc_memory_limit_percentage | | 0 | maximum memory for rpc in a tenant, as a percentage of total tenant memory, and 0 means no limit to rpc memory | RPC | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | enable_early_lock_release | | True | enable early lock release | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | merger_check_interval | | 10m | the time interval between the schedules of the task that checks on the progress of MERGE for each zone. Range: [10s, 60m] | DAILY_MERGE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | major_freeze_duty_time | | 02:00 | the start time of system daily merge procedure. Range: [00:00, 24:00) | DAILY_MERGE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | partition_balance_schedule_interval | | 2h | the time interval between generate partition balance task. The value should be no less than balancer_idle_time to enable partition balance. Default value 2h and the value 0s means disable partition balance. Range: [0s, +∞) | LOAD_BALANCE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | balancer_idle_time | | 10s | the time interval between the schedules of the tenant load-balancing task. Range: [10s, +∞) | LOAD_BALANCE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | enable_transfer | | True | controls whether transfers are allowed in the tenant. This config does not take effect when enable_rebalance is disabled. Value: True:turned on False:turned off | LOAD_BALANCE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | enable_rebalance | | True | specifies whether the tenant load-balancing is turned on. Value: True:turned on False: turned off | LOAD_BALANCE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | standby_db_preferred_upstream_log_region | | | The preferred upstream log region for Standby db. The Standby db will give priority to the preferred upstream log region to fetch log. For high availability，the Standby db will also switch to the other region when the preferred upstream log region can not fetch log because of exception etc. | LOGSERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | archive_lag_target | | 120s | The lag target of the log archive. The log archive target affects not only the backup availability, but also the lag of the standby database based on archive. Values larger than 7200s are not reasonable lag. The typical value is 120s. Extremely low values can result in high IOPS, which is not optimal for object storage; such values can also affect the performance of the database. The value 0ms means to archive as soon as possible. Range: [0ms,7200s] | LOGSERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | standby_db_fetch_log_rpc_timeout | | 15s | The threshold for detecting the RPC timeout for the standby tenant to fetch log from the log restore source tenant. When the rpc timeout, the log transport service switches to another server of the log restore source tenant to fetch logs. Range: [2s, +∞) | LOGSERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | ls_gc_delay_time | | 0s | The max delay time for ls gc when log archive is off. The default value is 0s. Range: [0s, +∞). The ls delay deletion mechanism will no longer take effect when the tenant is dropped. | LOGSERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | log_disk_throttling_maximum_duration | | 2h | maximum duration of log disk throttling, that is the time remaining until the log disk space is exhausted after log disk throttling triggered. | LOGSERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | log_disk_throttling_percentage | | 60 | the threshold of the size of the log disk when writing_limit will be triggered. Rang:[40,100]. setting 100 means turn off writing limit | LOGSERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | log_disk_utilization_threshold | | 80 | log disk utilization threshold before reuse log files, should be smaller than log_disk_utilization_limit_threshold. Range: [10, 100) | LOGSERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | log_disk_utilization_limit_threshold | | 95 | maximum of log disk usage percentage before stop submitting or receiving logs, should be bigger than log_disk_utilization_threshold. Range: [80, 100] | LOGSERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | log_archive_concurrency | | 0 | log archive concurrency, for both archive fetcher and sender. If the value is default 0, the database will automatically calculate the number of archive worker threads based on the tenant specification, which is tenant max_cpu divided by 4; otherwise set the the worker count equals to the value.Range: [0, 100] in integer | LOGSERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | log_restore_concurrency | | 0 | log restore concurrency, for both the restore tenant and standby tenant. If the value is default 0, the database will automatically calculate the number of restore worker threads based on the tenant specification, which is tenant max_cpu; otherwise set the the worker count equals to the value.Range: [0, 100] in integer | LOGSERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | log_storage_compress_func | | lz4_1.0 | specifies the algorithms used for log storage compression. Values: lz4_1.0, zstd_1.0, zstd_1.3.8 | LOGSERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | log_storage_compress_all | | False | specifies whether to compress logs before storing. The default is false(no compression) | LOGSERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | log_transport_compress_func | | lz4_1.0 | compressor used for log transport. Values: none, lz4_1.0, zstd_1.0, zstd_1.3.8 | LOGSERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | log_transport_compress_all | | False | If this option is set to true, use compression for log transport. The default is false(no compression) | LOGSERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | compatible | | 4.2.1.7 | compatible version for persisted data | ROOT_SERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | workarea_size_policy | | AUTO | policy used to size SQL working areas (MANUAL/AUTO) | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | default_progressive_merge_num | | 0 | default progressive_merge_num when tenant create tableRange:[0,) | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | writing_throttling_maximum_duration | | 2h | maximum duration of writting throttling(in minutes), max value is 3 days | TRANS | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | writing_throttling_trigger_percentage | | 60 | the threshold of the size of the mem store when writing_limit will be triggered. Rang:(0,100]. setting 100 means turn off writing limit | TRANS | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | freeze_trigger_percentage | | 20 | the threshold of the size of the mem store when freeze will be triggered. Rang:(0,100) | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | undo_retention | | 1800 | the low threshold value of undo retention. The system retains undo for at least the time specified in this config when active txn protection is banned. Range: [0, 4294967295] | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | px_workers_per_cpu_quota | | 10 | the ratio(integer) between the number of system allocated px workers vs the maximum number of threads that can be scheduled concurrently. Range: [0, 20] | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | cpu_quota_concurrency | | 10 | max allowed concurrency for 1 CPU quota. Range: [1,20] | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | enable_monotonic_weak_read | | False | specifies observer supportting atomicity and monotonic order read | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | max_stale_time_for_weak_consistency | | 5s | the max data stale time that cluster weak read version behind current timestamp,no smaller than weak_read_version_refresh_interval, range: [5s, +∞) | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | kv_transport_compress_threshold | | 10K | Together with the configuration item kv_transport_compress_func, it is used to specify the minimum threshold size of the OBKV query result set that needs to be compressed. Range: [0, +∞) | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone2 | observer | 172.31.32.214 | 2882 | kv_transport_compress_func | | none | compressor used for tableAPI query result. Values: none, lz4_1.0, snappy_1.0, zlib_1.0, zstd_1.0 zstd 1.3.8 | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | sql_protocol_min_tls_version | | none | SQL SSL control options, used to specify the minimum SSL/TLS version number. values: none, TLSv1, TLSv1.1, TLSv1.2, TLSv1.3 | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | rpc_server_authentication_method | | ALL | specifies rpc server authentication method. ALL: support all authentication methods. NONE: without authentication. SSL_NO_ENCRYPT: authentication by SSL handshake but not encrypt the communication channel. SSL_IO: authentication by SSL handshake and encrypt the communication channel | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | rpc_client_authentication_method | | NONE | specifies rpc client authentication method. NONE: without authentication. SSL_NO_ENCRYPT: authentication by SSL handshake but not encrypt the communication channel. SSL_IO: authentication by SSL handshake and encrypt the communication channel | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | observer_id | | 14 | the unique id that been assigned by rootservice for each observer in cluster, default: 0 (invalid id), Range: [1, 18446744073709551615] | OBSERVER | CLUSTER | DEFAULT | READONLY | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | local_ip | | 172.31.35.128 | the IP address of the machine on which the ObServer will be installed | OBSERVER | CLUSTER | DEFAULT | READONLY | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | enable_dblink | | True | Enable or disable dblink | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | global_background_cpu_quota | | -1 | When enable_global_background_resource_isolation is True, specify the number of vCPUs allocated to the background tasks-1 for the CPU is not limited by the cgroup | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | enable_global_background_resource_isolation | | False | When set to false, foreground and background tasks are isolated within the tenant; When set to true, isolate background tasks individually upon tenant-level | OBSERVER | CLUSTER | DEFAULT | STATIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | enable_cgroup | | True | when set to false, cgroup will not init; when set to true but cgroup root dir is not ready, print ERROR | OBSERVER | CLUSTER | DEFAULT | STATIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | sql_net_thread_count | | 0 | the number of global mysql I/O threads. Range: [0, 64] in integer, default value is 0, 0 stands for old value GCONF.net_thread_count | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | sql_login_thread_count | | 0 | the number of threads for sql login request. Range: [0, 32] in integer, 0 stands for use default thread count defined in TG.the default thread count for login request in TG is normal:6 mini-mode:2 | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | tcp_keepcnt | | 10 | The maximum number of keepalive probes TCP should send before dropping the connection. Take effect for new established connections. Range: [1,+∞) | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | tcp_keepintvl | | 6s | The time (in seconds) between individual keepalive probes. Take effect for new established connections. Range: [1s, +∞] | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | tcp_keepidle | | 7200s | The time (in seconds) the connection needs to remain idle before TCP starts sending keepalive probe. Take effect for new established connections. Range: [1s, +∞] | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | enable_tcp_keepalive | | True | enable TCP keepalive for the TCP connection of sql protocol. Take effect for new established connections. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | ob_ratelimit_stat_period | | 1s | the time interval to update observer's maximum bandwidth to a certain region. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | enable_ob_ratelimit | | False | enable ratelimit between regions for RPC connection. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | ssl_external_kms_info | | | when using the external key management center for ssl, this parameter will store some key management information | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | use_large_pages | | false | used to manage the database's use of large pages, values: false, true, only | OBSERVER | CLUSTER | DEFAULT | STATIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | schema_history_recycle_interval | | 10m | the time interval between the schedules of schema history recyle task. Range: [0s, +∞) | LOAD_BALANCE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | use_ipv6 | | False | Whether this server uses ipv6 address | OBSERVER | CLUSTER | DEFAULT | STATIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | ssl_client_authentication | | False | enable server SSL support. Takes effect after ca/cert/key file is configured correctly. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | stack_size | | 512K | the size of routine execution stackRange: [512K, 20M] | OBSERVER | CLUSTER | DEFAULT | STATIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | px_task_size | | 2M | to be removed | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | dtl_buffer_size | | 64K | to be removed | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | micro_block_merge_verify_level | | 2 | specify what kind of verification should be done when merging micro block. 0 : no verification will be done 1 : verify encoding algorithm, encoded micro block will be read to ensure data is correct 2 : verify encoding and compression algorithm, besides encoding verification, compressed block will be decompressed to ensure data is correct3 : verify encoding, compression algorithm and lost write protect | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | builtin_db_data_verify_cycle | | 20 | check cycle of db data. Range: [0, 360] in integer. Unit: day. 0: check nothing. 1-360: check all data every specified days. The default value is 20. The real check cycle maybe longer than the specified value for insuring performance. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | tablet_size | | 128M | default tablet size, has to be a multiple of 2M | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | sys_bkgd_migration_change_member_list_timeout | | 20s | the timeout for migration change member list retry. The default value is 20s. Range: [0s,24h] | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | sys_bkgd_migration_retry_num | | 3 | retry num limit during migration. Range: [3, 100] in integer | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | disk_io_thread_count | | 8 | The number of io threads on each disk. The default value is 8. Range: [2,32] in even integer | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | sys_bkgd_net_percentage | | 60 | the net percentage of sys background net. Range: [0, 100] in integer | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | data_disk_usage_limit_percentage | | 98 | the safe use percentage of data diskRange: [50,100] in integer | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | data_storage_error_tolerance_time | | 300s | time to tolerate disk read failure, after that, the disk status will be set error. Range [10s,7200s]. The default value is 300s | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | data_storage_warning_tolerance_time | | 5s | time to tolerate disk read failure, after that, the disk status will be set warning. Range [1s,300s]. The default value is 5s | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | storage_meta_cache_priority | | 10 | storage meta cache priority. Range:[1, ) | CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | fuse_row_cache_priority | | 1 | fuse row cache priority. Range:[1, ) | CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | bf_cache_miss_count_threshold | | 100 | bf cache miss count threshold, 0 means disable bf cache. Range:[0, ) | CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | bf_cache_priority | | 1 | bf cache priority. Range:[1, ) | CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | user_row_cache_priority | | 1 | user row cache priority. Range:[1, ) | CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | user_block_cache_priority | | 1 | user block cache priority. Range:[1, ) | CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | index_block_cache_priority | | 10 | index cache priority. Range:[1, ) | CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | opt_tab_stat_cache_priority | | 1 | tab stat cache priority. Range:[1, ) | CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | tablet_ls_cache_priority | | 1000 | tablet ls cache priority. Range:[1, ) | CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | location_cache_refresh_sql_timeout | | 1s | The timeout used for refreshing location cache by SQL. Range: [1ms, +∞) | LOCATION_CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | location_cache_refresh_rpc_timeout | | 500ms | The timeout used for refreshing location cache by RPC. Range: [1ms, +∞) | LOCATION_CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | all_server_list | | 172.31.32.214:2882,172.31.35.128:2882,172.31.44.197:2882 | all server addr in cluster | LOCATION_CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | location_cache_refresh_min_interval | | 100ms | the time interval in which no request for location cache renewal will be executed. The default value is 100 milliseconds. [0s, +∞) | LOCATION_CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | location_fetch_concurrency | | 20 | the maximum number of the tasks for fetching location cache concurrently. Range: [1, 1000] | LOCATION_CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | location_refresh_thread_count | | 2 | the number of threads for fetching location cache in the background. Range: (1, 64] | LOCATION_CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | virtual_table_location_cache_expire_time | | 8s | expiration time for virtual table location info in partition location cache. Range: [1s, +∞) | LOCATION_CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | standby_fetch_log_bandwidth_limit | | 0MB | the max bandwidth in bytes per second that can be occupied by the sum of the synchronizing log from primary cluster of all servers in the standby cluster | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | rpc_timeout | | 2s | the time during which a RPC request is permitted to execute before it is terminated | RPC | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | ignore_replay_checksum_error | | False | specifies whether error raised from the memtable replay checksum validation can be ignored. Value: True:ignored; False: not ignored | TRANS | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | row_compaction_update_limit | | 6 | maximum update count before trigger row compaction. Range: [1, 6400] | TRANS | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | clog_sync_time_warn_threshold | | 100ms | the time given to the commit log synchronization between a leader and its followers before a \'warning\' message is printed in the log file. Range: [1ms,1000ms] | TRANS | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | trx_2pc_retry_interval | | 100ms | the time interval between the retries in case of failure during a transaction\'s two-phase commit phase. Range: [1ms,5000ms] | TRANS | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | enable_sys_unit_standalone | | False | specifies whether sys unit standalone deployment is turned on. Value: True:turned on False: turned off | LOAD_BALANCE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | server_balance_cpu_mem_tolerance_percent | | 5 | specifies the tolerance (in percentage) of the unbalance of the cpu/memory utilization among all servers. The average cpu/memory utilization is calculated by dividing the total cpu/memory by the number of servers. server balancer will start a rebalancing task when the deviation between the average usage and some server load is greater than this tolerance Range: [1, 100] in percentage | LOAD_BALANCE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | server_balance_disk_tolerance_percent | | 1 | specifies the tolerance (in percentage) of the unbalance of the disk space utilization among all servers. The average disk space utilization is calculated by dividing the total space by the number of servers. server balancer will start a rebalancing task when the deviation between the average usage and some server load is greater than this tolerance Range: [1, 100] in percentage | LOAD_BALANCE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | server_balance_critical_disk_waterlevel | | 80 | disk water level to determine server balance strategy | LOAD_BALANCE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | balancer_log_interval | | 1m | the time interval between logging the load-balancing task\'s statistics. Range: [1s, +∞) | LOAD_BALANCE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | balancer_task_timeout | | 20m | the time to execute the load-balancing task before it is terminated. Range: [1s, +∞) | LOAD_BALANCE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | balancer_tolerance_percentage | | 10 | specifies the tolerance (in percentage) of the unbalance of the disk space utilization among all units. The average disk space utilization is calculated by dividing the total space by the number of units. For example, say balancer_tolerance_percentage is set to 10 and a tenant has two units in the system, the average disk use for each unit should be about the same, thus 50% of the total value. Therefore, the system will start a rebalancing task when any unit\'s disk space goes beyond +-10% of the average usage. Range: [1, 100) in percentage | LOAD_BALANCE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | enable_rereplication | | True | specifies whether the auto-replication is turned on. Value: True:turned on False: turned off | LOAD_BALANCE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | resource_hard_limit | | 100 | system utilization should not be large than resource_hard_limit | LOAD_BALANCE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | log_storage_warning_trigger_percentage | | 0 | The performance decrease percentage threshold that may trigger a log disk failure. The higher the value, the more sensitive it is. The default value is 0, Range: [0,50].The default value is 0, which means the log disk will be considered to have failure only if any IO RT exceeds log_storage_warning_tolerance_time. If the value is greater than 0, which means the log disk will be considered to have failure only if current IO throughput < (normal throughput * log_storage_warning_trigger_percentage / 100) and performance degradation has been ongoing for log_storage_warning_tolerance_time seconds. If the parameter needs to be set, it is recommended to set a value less than 10 to avoid misjudgment. | LOGSERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | log_storage_warning_tolerance_time | | 5s | time to tolerate log disk io delay, after that, the disk status will be set warning. Range: [1s,300s] | LOGSERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | log_disk_percentage | | 0 | the percentage of disk space used by the log files. Range: [0,99] in integer;only effective when parameter log_disk_size is 0;when log_disk_percentage is 0: a) if the data and the log are on the same disk, means log_disk_percentage = 30 b) if the data and the log are on the different disks, means log_disk_perecentage = 90 | LOGSERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | log_disk_size | | 0M | the size of disk space used by the log files. Range: [0, +∞) | LOGSERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | recyclebin_object_expire_time | | 0s | recyclebin object expire time, default 0 that means auto purge recyclebin off. Range: [0s, +∞) | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | ob_event_history_recycle_interval | | 7d | the time to recycle event history. Range: [1d, 180d] | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | enable_major_freeze | | True | specifies whether major_freeze function is turned on. Value: True:turned on; False: turned off | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | enable_ddl | | True | specifies whether DDL operation is turned on. Value: True:turned on; False: turned off | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | min_observer_version | | 4.2.1.7 | the min observer version | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | tablet_meta_table_check_interval | | 30m | the time interval that observer compares tablet meta table with local ls replica info and make adjustments to ensure the correctness of tablet meta table. Range: [1m,+∞) | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | ls_meta_table_check_interval | | 1s | the time interval that observer compares ls meta table with local ls replica info and make adjustments to ensure the correctness of ls meta table. Range: [1ms,+∞) | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | tablet_meta_table_scan_batch_count | | 999 | the number of tablet replica info that will be read by each request on the tablet-related system tables during procedures such as load-balancing, daily merge, election and etc. Range:(0,65536] | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | rootservice_ready_check_interval | | 3s | the interval between the schedule of the rootservice restart task while restart failed Range: [100000us, 1m] | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | server_check_interval | | 30s | the time interval between schedules of a task that examines the __all_server table. Range: [1s, +∞) | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | migration_disable_time | | 3600s | the duration in which the observer stays in the \'block_migrate_in\' status, which means it is not allowed to migrate into the server. Range: [1s, +∞) | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | server_permanent_offline_time | | 60s | the time interval between any two heartbeats beyond which a server is considered to be \'permanently\' offline. Range: [20s,+∞) | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | enable_sys_table_ddl | | False | specifies whether a \'system\' table is allowed be to created manually. Value: True: allowed; False: not allowed | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | rootservice_async_task_queue_size | | 16384 | the size of the queue for all asynchronous tasks at rootserver. Range: [8, 131072] in integer | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | rootservice_async_task_thread_count | | 4 | maximum of threads allowed for executing asynchronous task at rootserver. Range: [1, 10] | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | lease_time | | 10s | Lease for current heartbeat. If the root server does not received any heartbeat from an observer in lease_time seconds, that observer is considered to be offline. Not recommended for modification. Range: [1s, 5m] | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | plan_cache_evict_interval | | 5s | time interval for periodic plan cache eviction. Range: [0s, +∞) | TENANT | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | memstore_limit_percentage | | 50 | used in calculating the value of MEMSTORE_LIMIT parameter: memstore_limit_percentage = memstore_limit / memory_size,memory_size, where MEMORY_SIZE is determined when the tenant is created. Range: (0, 100) | TENANT | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | large_query_threshold | | 5s | threshold for execution time beyond which a request may be paused and rescheduled as a \'large request\'. Range: [1ms, +∞) | TENANT | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | large_query_worker_percentage | | 30 | the percentage of the workers reserved to serve large query request. Range: [0, 100] in percentage | TENANT | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | workers_per_cpu_quota | | 10 | the ratio(integer) between the number of system allocated workers vs the maximum number of threads that can be scheduled concurrently. Range: [2, 20] | TENANT | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | location_cache_cpu_quota | | 5 | the number of vCPUs allocated for the requests regarding location info of the core tables. Range: [0,10] in integer | TENANT | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | server_cpu_quota_max | | 0 | the number of maximal vCPUs allocated to the server tenant(a special internal tenant that exists on every observer). 0 stands for adaptive. Range: [0, 16] | TENANT | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | server_cpu_quota_min | | 0 | the number of minimal vCPUs allocated to the server tenant(a special internal tenant that exists on every observer). 0 stands for adaptive. Range: [0, 16] | TENANT | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | enable_sql_operator_dump | | True | specifies whether sql operators (sort/hash join/material/window function/interm result/...) allowed to write to disk | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | autoinc_cache_refresh_interval | | 3600s | auto-increment service cache refresh sync_value in this interval, with default 3600s. Range: [100ms, +∞) | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | memory_chunk_cache_size | | 0M | the maximum size of memory cached by memory chunk cache. Range: [0M,], 0 stands for adaptive | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | cache_wash_threshold | | 4GB | size of remaining memory at which cache eviction will be triggered. Range: [0,+∞) | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | memory_limit_percentage | | 80 | the size of the memory reserved for internal use(for testing purpose). Range: [10, 95] | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | enable_syslog_recycle | | False | specifies whether log file recycling is turned on. Value: True：turned on; False: turned off | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | enable_syslog_wf | | True | specifies whether any log message with a log level higher than \'WARN\' would be printed into a separate file with a suffix of \'wf\' | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | enable_async_syslog | | True | specifies whether use async log for observer.log, elec.log and rs.log | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | max_syslog_file_count | | 0 | specifies the maximum number of the log files that can co-exist before the log file recycling kicks in. Each log file can occupy at most 256MB disk space. When this value is set to 0, no log file will be removed. Range: [0, +∞) in integer | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | diag_syslog_per_error_limit | | 200 | DIAG syslog limitation for each error per second, exceeding syslog would be truncated | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | syslog_io_bandwidth_limit | | 30MB | Syslog IO bandwidth limitation, exceeding syslog would be truncated. Use 0 to disable ERROR log. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | syslog_level | | WDIAG | specifies the current level of logging. There are DEBUG, TRACE, WDIAG, EDIAG, INFO, WARN, ERROR, seven different log levels. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | obconfig_url | | http://172.31.46.60:8080/services?Action=ObRootServiceInfo&User_ID=alibaba&UID=ocpmaster&ObRegion=release | URL for OBConfig service | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | cluster_id | | 1719287282 | ID of the cluster | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | cluster | | release | Name of the cluster | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | rootservice_list | | 172.31.35.128:2882:2881;172.31.44.197:2882:2881;172.31.32.214:2882:2881 | a list of servers against which election candidate is checked for validation | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | weak_read_version_refresh_interval | | 100ms | the time interval to refresh cluster weak read version Range: [50ms, +∞) | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | default_compress | | archive | default compress strategy for create new table within oracle mode | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | default_row_format | | dynamic | default row format in mysql mode | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | default_compress_func | | zstd_1.3.8 | default compress function name for create new table, values: none, lz4_1.0, snappy_1.0, zlib_1.0, zstd_1.0, zstd_1.3.8 | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | schema_history_expire_time | | 7d | the hour of expire time for schema history, from 1hour to 30days, with default 7days. Range: [1h, 30d] | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | enable_upgrade_mode | | False | specifies whether upgrade mode is turned on. If turned on, daily merger and balancer will be disabled. Value: True: turned on; False: turned off; | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | enable_perf_event | | True | specifies whether to enable perf event feature. The default value is True. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | dead_socket_detection_timeout | | 3s | specify a tcp_user_timeout for RFC5482. A zero value makes the option disabled, Range: [0, 2h] | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | debug_sync_timeout | | 0 | Enable the debug sync facility and optionally specify a default wait timeout in micro seconds. A zero value keeps the facility disabled, Range: [0, +∞] | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | enable_rich_error_msg | | False | specifies whether add ip:port, time and trace id to user error message. The default value is FALSE. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | enable_record_trace_id | | False | specifies whether record app trace id is turned on. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | enable_sql_audit | | True | specifies whether SQL audit is turned on. The default value is TRUE. Value: TRUE: turned on FALSE: turned off | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | max_string_print_length | | 500 | truncate very long string when printing to log file. Range:[0,] | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | enable_record_trace_log | | True | specifies whether to always record the trace log. The default value is True. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | trace_log_slow_query_watermark | | 1s | the threshold of execution time (in milliseconds) of a query beyond which it is considered to be a \'slow query\'. Range: [1ms,+∞) | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | cpu_count | | 20 | the number of CPU\'s in the system. If this parameter is set to zero, the number will be set according to sysconf; otherwise, this parameter is used. Range: [0,+∞) in integer | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | system_memory | | 0M | the memory reserved for internal use which cannot be allocated to any outer-tenant, and should be determined to guarantee every server functions normally. Range: [0M,) | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | memory_limit | | 0M | the size of the memory reserved for internal use(for testing purpose), 0 means follow memory_limit_percentage. Range: 0, [1G,). | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | tenant_task_queue_size | | 16384 | the size of the task queue for each tenant. Range: [1024,+∞) | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | high_priority_net_thread_count | | 0 | the number of rpc I/O threads for high priority messages, 0 means set off. Range: [0, 64] in integer | OBSERVER | CLUSTER | DEFAULT | STATIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | net_thread_count | | 0 | the number of rpc/mysql I/O threads for Libeasy. Range: [0, 64] in integer, 0 stands for max(6, CPU_NUM/8) | OBSERVER | CLUSTER | DEFAULT | STATIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | internal_sql_execute_timeout | | 30s | the number of microseconds an internal DML request is permitted to execute before it is terminated. Range: [1000us, 1h] | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | ob_startup_mode | | NORMAL | specifies the observer startup mode | OBSERVER | CLUSTER | DEFAULT | READONLY | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | zone | | zone1 | specifies the zone name | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | devname | | eth0 | name of network adapter | OBSERVER | CLUSTER | DEFAULT | READONLY | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | mysql_port | | 2881 | port number for mysql connection. Range: (1024, 65536) in integer | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | rpc_port | | 2882 | the port number for RPC protocol. Range: (1024, 65536) in integer | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | leak_mod_to_check | | NONE | the name of the module under memory leak checks | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | config_additional_dir | | /data/log1/release/etc2;/data/1/release/etc3 | additional directories of configure file | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | memory_reserved | | 500M | the size of the system memory reserved for emergency internal use. Range: [10M, total size of memory] | SSTABLE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | datafile_disk_percentage | | 95 | the percentage of disk space used by the data files. Range: [0,99] in integer | SSTABLE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | datafile_maxsize | | 0M | the auto extend max size. Range: [0, +∞) | SSTABLE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | datafile_next | | 0 | the auto extend step. Range: [0, +∞) | SSTABLE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | datafile_size | | 0M | size of the data file. Range: [0, +∞) | SSTABLE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | redundancy_level | | NORMAL | EXTERNAL: use extrernal redundancyNORMAL: tolerate one disk failureHIGH: tolerate two disk failure if disk count is enough | SSTABLE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | data_dir | | /data/oceanbase/store/release | the directory for the data file | SSTABLE | CLUSTER | DEFAULT | READONLY | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | sql_plan_management_mode | | Disable | Specifies how spm work."Disable" represent disable spm (default value)."OnlineEvolve" represent evolve plan online. | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | choose_migration_source_policy | | idc | the policy of choose source in migration and add replica. 'idc' means firstly choose follower replica of the same idc as source, 'region' means firstly choose follower replica of the same region as source | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | lob_enable_block_cache_threshold | | 256K | For outrow-stored LOBs, if the length is less than or equal to that threshold, they can be admitted into the block cache to speed up the next query. | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | json_document_max_depth | | 100 | maximum nesting depth allowed in a JSON document | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | max_partition_num | | 8192 | set max partition num in mysql mode | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | optimizer_index_cost_adj | | 0 | adjust costing of index scan | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | ttl_thread_score | | 0 | the current work thread score of ttl thread. Range: [0,100] in integer. Especially, 0 means default value | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | enable_kv_ttl | | False | specifies whether ttl task is enbled | ROOT_SERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | kv_ttl_history_recycle_interval | | 7d | the time to recycle ttl history. Range: [1d, 180d] | ROOT_SERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | kv_ttl_duty_duration | | | ttl background task working time durationbegin_time or end_time in Range, e.g., [23:00:00, 24:00:00] | ROOT_SERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | range_optimizer_max_mem_size | | 128M | to limit the memory consumption for the query range optimizer. Range: [0M,+∞), 0 stands for unlimited | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | enable_user_defined_rewrite_rules | | False | specify whether the user defined rewrite rules are enabled. Value: True: enable False: disable | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | dump_data_dictionary_to_log_interval | | 24h | data dictionary dump to log(SYS LS) intervalRange: (0s,+∞) | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | tenant_sql_net_thread_count | | 0 | the number of mysql I/O threads for a tenant. Range: [0, 64] in integer, 0 stands for unit_min_cpu | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | tenant_sql_login_thread_count | | 0 | the number of threads for sql login request of each tenant. Range: [0, 32] in integer, 0 stands for unit_min_cpu | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | arbitration_timeout | | 5s | The timeout before automatically degrading when arbitration member exists. Range: [3s,+∞] | TRANS | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | query_response_time_range_base | | 10 | Select base of log for QUERY_RESPONSE_TIME ranges. WARNING: variable change takes affect only after flush.The default value is 10. Range: [2,10000]. | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | query_response_time_flush | | False | Flush QUERY_RESPONSE_TIME table and re-read query_response_time_range_baseThe default value is False. Value: TRUE: trigger flush FALSE: do not trigger | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | query_response_time_stats | | True | Enable or disable QUERY_RESPONSE_TIME statistics collecting, and need enable_sql_audit is True.The default value is True. Value: TRUE: turned on FALSE: turned off | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | default_enable_extended_rowid | | False | specifies whether to create table as extended rowid mode or not | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | ob_query_switch_leader_retry_timeout | | 0ms | max time spend on retry caused by leader swith or network disconnectionRange: [0ms, +∞) | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | default_auto_increment_mode | | order | specifies default auto-increment mode, default is 'order' | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | enable_sql_extension | | False | specifies whether to allow use some oracle mode features in mysql mode | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | job_queue_processes | | 1000 | specifies the maximum number of job slaves per instance that can be created for the execution of DBMS_JOB jobs and Oracle Scheduler (DBMS_SCHEDULER) jobs. | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | ob_proxy_readonly_transaction_routing_policy | | False | Proxy route policy for readonly sql: whether regard begining read only stmts as in transaction | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | connection_control_max_connection_delay | | 2147483647 | The maximum delay in milliseconds for server response to failed connection attempts, if connection_control_failed_connections_threshold is greater than zero | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | connection_control_min_connection_delay | | 1000 | The minimum delay in milliseconds for server response to failed connection attempts, if connection_control_failed_connections_threshold is greater than zero. | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | connection_control_failed_connections_threshold | | 0 | The number of consecutive failed connection attempts permitted to accountsbefore the server adds a delay for subsequent connection attempts | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | open_cursors | | 50 | specifies the maximum number of open cursors a session can have at once.can use this parameter to prevent a session from opening an excessive number of cursors.Range: [0, 65535] in integer | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | ob_ssl_invited_common_names | | NONE | when server use ssl, use it to control client identity with ssl subject common name. default NONE | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | plsql_warnings | | DISABLE::ALL | enables or disables the reporting of warning messages by thePL/SQL compiler, and specifies which warning messages to show as errors | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | plsql_v2_compatibility | | False | allows some abnormal behavior that Version 8 disallows, not available | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | plsql_optimize_level | | 1 | specifies the optimization level that will be used tocompile PL/SQL library units. The higher the setting of this parameter, the more effortthe compiler makes to optimize PL/SQL library units | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | plsql_debug | | False | specifies whether or not PL/SQL library units will be compiled for debugging | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | plsql_code_type | | native | specifies the compilation mode for PL/SQL library units | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | plsql_ccflags | | | provides a mechanism that allows PL/SQL programmers to controlconditional compilation of each PL/SQL library unit independently | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | tde_method | | none | none : transparent encryption is none, none means cannot use tde, internal : transparent encryption is in the form of internal tables, bkmi : transparent encryption is in the form of external bkmi | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | external_kms_info | | | when using the external key management center, this parameter will store some key management information | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | ob_enable_batched_multi_statement | | False | enable use of batched multi statement | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | backup_data_file_size | | 4G | backup data file size. Range: [512M, 4G] in integer | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | audit_trail | | None | enables or disables database auditing, support NONE;OS;DB;DB,EXTENDED;DB_EXTENDED | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | audit_sys_operations | | False | whether trace sys user operations | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | sql_work_area | | 1G | Work area memory limitation for tenant | OBSERVER | TENANT | DEFAULT | STATIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | ob_compaction_schedule_interval | | 120s | the time interval to schedule compaction, Range: [3s,5m]Range: [3s, 5m] | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | major_compact_trigger | | 0 | specifies how many minor freeze should be triggered between two major freeze, Range: [0,65535] in integer | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | minor_compact_trigger | | 2 | minor_compact_trigger, Range: [0,16] in integer | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | ddl_thread_score | | 0 | the current work thread score of ddl thread. Range: [0,100] in integer. Especially, 0 means default value | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | ha_low_thread_score | | 0 | the current work thread score of high availability low thread. Range: [0,100] in integer. Especially, 0 means default value | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | ha_mid_thread_score | | 0 | the current work thread score of high availability mid thread. Range: [0,100] in integer. Especially, 0 means default value | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | ha_high_thread_score | | 0 | the current work thread score of high availability high thread. Range: [0,100] in integer. Especially, 0 means default value | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | compaction_high_thread_score | | 0 | the current work thread score of high priority compaction. Range: [0,100] in integer. Especially, 0 means default value | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | compaction_mid_thread_score | | 0 | the current work thread score of middle priority compaction. Range: [0,100] in integer. Especially, 0 means default value | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | compaction_low_thread_score | | 0 | the current work thread score of low priority compaction. Range: [0,100] in integer. Especially, 0 means default value | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | compaction_schedule_tablet_batch_cnt | | 50000 | the batch size when scheduling tablet to execute compaction task. Range: [10000,200000] in integer. default value is 50000 | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | compaction_dag_cnt_limit | | 15000 | the compaction dag count limit. Range: [10000,200000] in integer. default value is 15000 | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | rpc_memory_limit_percentage | | 0 | maximum memory for rpc in a tenant, as a percentage of total tenant memory, and 0 means no limit to rpc memory | RPC | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | enable_early_lock_release | | True | enable early lock release | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | merger_check_interval | | 10m | the time interval between the schedules of the task that checks on the progress of MERGE for each zone. Range: [10s, 60m] | DAILY_MERGE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | major_freeze_duty_time | | 02:00 | the start time of system daily merge procedure. Range: [00:00, 24:00) | DAILY_MERGE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | partition_balance_schedule_interval | | 2h | the time interval between generate partition balance task. The value should be no less than balancer_idle_time to enable partition balance. Default value 2h and the value 0s means disable partition balance. Range: [0s, +∞) | LOAD_BALANCE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | balancer_idle_time | | 10s | the time interval between the schedules of the tenant load-balancing task. Range: [10s, +∞) | LOAD_BALANCE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | enable_transfer | | True | controls whether transfers are allowed in the tenant. This config does not take effect when enable_rebalance is disabled. Value: True:turned on False:turned off | LOAD_BALANCE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | enable_rebalance | | True | specifies whether the tenant load-balancing is turned on. Value: True:turned on False: turned off | LOAD_BALANCE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | standby_db_preferred_upstream_log_region | | | The preferred upstream log region for Standby db. The Standby db will give priority to the preferred upstream log region to fetch log. For high availability，the Standby db will also switch to the other region when the preferred upstream log region can not fetch log because of exception etc. | LOGSERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | archive_lag_target | | 120s | The lag target of the log archive. The log archive target affects not only the backup availability, but also the lag of the standby database based on archive. Values larger than 7200s are not reasonable lag. The typical value is 120s. Extremely low values can result in high IOPS, which is not optimal for object storage; such values can also affect the performance of the database. The value 0ms means to archive as soon as possible. Range: [0ms,7200s] | LOGSERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | standby_db_fetch_log_rpc_timeout | | 15s | The threshold for detecting the RPC timeout for the standby tenant to fetch log from the log restore source tenant. When the rpc timeout, the log transport service switches to another server of the log restore source tenant to fetch logs. Range: [2s, +∞) | LOGSERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | ls_gc_delay_time | | 0s | The max delay time for ls gc when log archive is off. The default value is 0s. Range: [0s, +∞). The ls delay deletion mechanism will no longer take effect when the tenant is dropped. | LOGSERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | log_disk_throttling_maximum_duration | | 2h | maximum duration of log disk throttling, that is the time remaining until the log disk space is exhausted after log disk throttling triggered. | LOGSERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | log_disk_throttling_percentage | | 60 | the threshold of the size of the log disk when writing_limit will be triggered. Rang:[40,100]. setting 100 means turn off writing limit | LOGSERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | log_disk_utilization_threshold | | 80 | log disk utilization threshold before reuse log files, should be smaller than log_disk_utilization_limit_threshold. Range: [10, 100) | LOGSERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | log_disk_utilization_limit_threshold | | 95 | maximum of log disk usage percentage before stop submitting or receiving logs, should be bigger than log_disk_utilization_threshold. Range: [80, 100] | LOGSERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | log_archive_concurrency | | 0 | log archive concurrency, for both archive fetcher and sender. If the value is default 0, the database will automatically calculate the number of archive worker threads based on the tenant specification, which is tenant max_cpu divided by 4; otherwise set the the worker count equals to the value.Range: [0, 100] in integer | LOGSERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | log_restore_concurrency | | 0 | log restore concurrency, for both the restore tenant and standby tenant. If the value is default 0, the database will automatically calculate the number of restore worker threads based on the tenant specification, which is tenant max_cpu; otherwise set the the worker count equals to the value.Range: [0, 100] in integer | LOGSERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | log_storage_compress_func | | lz4_1.0 | specifies the algorithms used for log storage compression. Values: lz4_1.0, zstd_1.0, zstd_1.3.8 | LOGSERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | log_storage_compress_all | | False | specifies whether to compress logs before storing. The default is false(no compression) | LOGSERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | log_transport_compress_func | | lz4_1.0 | compressor used for log transport. Values: none, lz4_1.0, zstd_1.0, zstd_1.3.8 | LOGSERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | log_transport_compress_all | | False | If this option is set to true, use compression for log transport. The default is false(no compression) | LOGSERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | compatible | | 4.2.1.7 | compatible version for persisted data | ROOT_SERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | workarea_size_policy | | AUTO | policy used to size SQL working areas (MANUAL/AUTO) | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | default_progressive_merge_num | | 0 | default progressive_merge_num when tenant create tableRange:[0,) | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | writing_throttling_maximum_duration | | 2h | maximum duration of writting throttling(in minutes), max value is 3 days | TRANS | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | writing_throttling_trigger_percentage | | 60 | the threshold of the size of the mem store when writing_limit will be triggered. Rang:(0,100]. setting 100 means turn off writing limit | TRANS | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | freeze_trigger_percentage | | 20 | the threshold of the size of the mem store when freeze will be triggered. Rang:(0,100) | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | undo_retention | | 1800 | the low threshold value of undo retention. The system retains undo for at least the time specified in this config when active txn protection is banned. Range: [0, 4294967295] | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | px_workers_per_cpu_quota | | 10 | the ratio(integer) between the number of system allocated px workers vs the maximum number of threads that can be scheduled concurrently. Range: [0, 20] | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | cpu_quota_concurrency | | 10 | max allowed concurrency for 1 CPU quota. Range: [1,20] | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | enable_monotonic_weak_read | | False | specifies observer supportting atomicity and monotonic order read | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | max_stale_time_for_weak_consistency | | 5s | the max data stale time that cluster weak read version behind current timestamp,no smaller than weak_read_version_refresh_interval, range: [5s, +∞) | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | kv_transport_compress_threshold | | 10K | Together with the configuration item kv_transport_compress_func, it is used to specify the minimum threshold size of the OBKV query result set that needs to be compressed. Range: [0, +∞) | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 172.31.35.128 | 2882 | kv_transport_compress_func | | none | compressor used for tableAPI query result. Values: none, lz4_1.0, snappy_1.0, zlib_1.0, zstd_1.0 zstd 1.3.8 | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+---------------+------------+-------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+