obclient > show variables like 'version_comment'; +-----------------+------------------------------------------------------------------------------------------------------------------+ | Variable_name | Value | +=================+==================================================================================================================+ | version_comment | OceanBase_CE 4.0.0.0 (r102000032022120718-58fdb0ef1a9b589ef05e56c1ede65e951986d996) (Built Dec 7 2022 18:32:31) | +-----------------+------------------------------------------------------------------------------------------------------------------+ obclient > SELECT * FROM oceanbase.__all_zone WHERE name='idc'; +----------------------------+----------------------------+--------+--------+---------+--------+ | gmt_create | gmt_modified | zone | name | value | info | +============================+============================+========+========+=========+========+ | 2023-08-26 10:10:56.503577 | 2023-08-26 10:10:56.503577 | zone1 | idc | 0 | | +----------------------------+----------------------------+--------+--------+---------+--------+ obclient > select svr_ip,zone,with_rootserver,status,block_migrate_in_time,start_service_time,stop_time,build_version from oceanbase.__all_server order by zone; +-----------+--------+-------------------+----------+-------------------------+----------------------+-------------+-------------------------------------------------------------------------------------------+ | svr_ip | zone | with_rootserver | status | block_migrate_in_time | start_service_time | stop_time | build_version | +===========+========+===================+==========+=========================+======================+=============+===========================================================================================+ | 127.0.0.1 | zone1 | 1 | ACTIVE | 0 | 1718185428839566 | 0 | 4.0.0.0_102000032022120718-58fdb0ef1a9b589ef05e56c1ede65e951986d996(Dec 7 2022 18:32:31) | +-----------+--------+-------------------+----------+-------------------------+----------------------+-------------+-------------------------------------------------------------------------------------------+ obclient > select tenant_id,tenant_name,primary_zone,compatibility_mode from oceanbase.__all_tenant; +-------------+---------------+----------------+----------------------+ | tenant_id | tenant_name | primary_zone | compatibility_mode | +=============+===============+================+======================+ | 1 | sys | RANDOM | 0 | +-------------+---------------+----------------+----------------------+ obclient > show parameters like '%syslog_level%'; +--------+------------+-----------+------------+--------------+-------------+---------+------------------------------------------------------------------------------------------------------------------------+-----------+---------+----------+-------------------+ | zone | svr_type | svr_ip | svr_port | name | data_type | value | info | section | scope | source | edit_level | +========+============+===========+============+==============+=============+=========+========================================================================================================================+===========+=========+==========+===================+ | zone1 | observer | 127.0.0.1 | 3310 | syslog_level | | WARN | specifies the current level of logging. There are DEBUG, TRACE, INFO, WARN, USER_ERR, ERROR, six different log levels. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+-----------+------------+--------------+-------------+---------+------------------------------------------------------------------------------------------------------------------------+-----------+---------+----------+-------------------+ obclient > show parameters like '%syslog_io_bandwidth_limit%'; +--------+------------+-----------+------------+---------------------------+-------------+---------+--------------------------------------------------------------------------------------------------+-----------+---------+----------+-------------------+ | zone | svr_type | svr_ip | svr_port | name | data_type | value | info | section | scope | source | edit_level | +========+============+===========+============+===========================+=============+=========+==================================================================================================+===========+=========+==========+===================+ | zone1 | observer | 127.0.0.1 | 3310 | syslog_io_bandwidth_limit | | 10M | Syslog IO bandwidth limitation, exceeding syslog would be truncated. Use 0 to disable ERROR log. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+-----------+------------+---------------------------+-------------+---------+--------------------------------------------------------------------------------------------------+-----------+---------+----------+-------------------+ obclient > select count(*),tenant_id,zone_list,unit_count from oceanbase.__all_resource_pool group by tenant_id,zone_list,unit_count; +------------+-------------+-------------+--------------+ | count(*) | tenant_id | zone_list | unit_count | +============+=============+=============+==============+ | 1 | 1 | zone1 | 1 | +------------+-------------+-------------+--------------+ obclient > show parameters +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone | svr_type | svr_ip | svr_port | name | data_type | value | info | section | scope | source | edit_level | +========+============+===========+============+=================================================+=============+==========================+====================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================+================+=========+==========+===================+ | zone1 | observer | 127.0.0.1 | 3310 | 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 | 127.0.0.1 | 3310 | 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 | 127.0.0.1 | 3310 | 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 | 127.0.0.1 | 3310 | 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 | 127.0.0.1 | 3310 | 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 | 127.0.0.1 | 3310 | 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 | 127.0.0.1 | 3310 | 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 | 127.0.0.1 | 3310 | enable_ob_ratelimit | | False | enable ratelimit between regions for RPC connection. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | 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 | 127.0.0.1 | 3310 | 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 | 127.0.0.1 | 3310 | 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 | 127.0.0.1 | 3310 | backup_data_file_size | | 4G | backup data file size. Range: [512M, 4G] in integer | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | use_ipv6 | | False | Whether this server uses ipv6 address | OBSERVER | CLUSTER | DEFAULT | STATIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | 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 | 127.0.0.1 | 3310 | stack_size | | 512K | the size of routine execution stackRange: [512K, 20M] | OBSERVER | CLUSTER | DEFAULT | STATIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | px_task_size | | 2M | to be removed | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | dtl_buffer_size | | 64K | to be removed | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | 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 | 127.0.0.1 | 3310 | 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 | 127.0.0.1 | 3310 | tablet_size | | 128M | default tablet size, has to be a multiple of 2M | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | sys_bkgd_migration_change_member_list_timeout | | 1h | the timeout for migration change member list retry. The default value is 1h. Range: [0s,24h] | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | sys_bkgd_migration_retry_num | | 3 | retry num limit during migration. Range: [3, 100] in integer | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | restore_concurrency | | 0 | the current work thread num of restore macro block. Range: [0,512] in integer | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | 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 | 127.0.0.1 | 3310 | sys_bkgd_net_percentage | | 60 | the net percentage of sys background net. Range: [0, 100] in integer | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | data_disk_usage_limit_percentage | | 90 | the safe use percentage of data diskRange: [50,100] in integer | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | 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 | 127.0.0.1 | 3310 | data_storage_warning_tolerance_time | | 30s | time to tolerate disk read failure, after that, the disk status will be set warning. Range [10s,300s]. The default value is 30s | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | fuse_row_cache_priority | | 1 | fuse row cache priority. Range:[1, ) | CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | 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 | 127.0.0.1 | 3310 | bf_cache_priority | | 1 | bf cache priority. Range:[1, ) | CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | user_row_cache_priority | | 1 | user row cache priority. Range:[1, ) | CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | user_block_cache_priority | | 1 | user block cache priority. Range:[1, ) | CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | index_block_cache_priority | | 10 | index cache priority. Range:[1, ) | CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | opt_tab_stat_cache_priority | | 1 | tab stat cache priority. Range:[1, ) | CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | tablet_ls_cache_priority | | 1000 | tablet ls cache priority. Range:[1, ) | CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | 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 | 127.0.0.1 | 3310 | 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 | 127.0.0.1 | 3310 | all_server_list | | 127.0.0.1:3310 | all server addr in cluster | LOCATION_CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | 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 | 127.0.0.1 | 3310 | 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 | 127.0.0.1 | 3310 | location_refresh_thread_count | | 4 | the number of threads for fetching location cache in the background. Range: (1, 64] | LOCATION_CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | virtual_table_location_cache_expire_time | | 8s | expiration time for virtual table location info in partiton location cache. Range: [1s, +∞) | LOCATION_CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | 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 | 127.0.0.1 | 3310 | 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 | 127.0.0.1 | 3310 | row_compaction_update_limit | | 6 | maximum update count before trigger row compaction. Range: [1, 64] | TRANS | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | clog_sync_time_warn_threshold | | 2s | 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 | 127.0.0.1 | 3310 | trx_2pc_retry_interval | | 500ms | 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 | 127.0.0.1 | 3310 | 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 | 127.0.0.1 | 3310 | 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 | 127.0.0.1 | 3310 | 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 | 127.0.0.1 | 3310 | server_balance_critical_disk_waterlevel | | 80 | disk water level to determine server balance strategy | LOAD_BALANCE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | 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 | 127.0.0.1 | 3310 | 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 | 127.0.0.1 | 3310 | 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 | 127.0.0.1 | 3310 | balancer_idle_time | | 5m | the time interval between the schedules of the load-balancing task. Range: [10s, +∞) | LOAD_BALANCE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | enable_rebalance | | True | specifies whether the load-balancing is turned on. Value: True:turned on False: turned off | LOAD_BALANCE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | 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 | 127.0.0.1 | 3310 | resource_hard_limit | | 100 | system utilization should not be large than resource_hard_limit | LOAD_BALANCE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | 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 | 127.0.0.1 | 3310 | log_disk_size | | 40G | the size of disk space used by the log files. Range: [0, +∞) | LOGSERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | 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 | 127.0.0.1 | 3310 | ob_event_history_recycle_interval | | 7d | the time to recycle event history. Range: [1d, 180d] | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | 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 | 127.0.0.1 | 3310 | 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 | 127.0.0.1 | 3310 | min_observer_version | | 4.0.0.0 | the min observer version | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | 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 | 127.0.0.1 | 3310 | 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 | 127.0.0.1 | 3310 | 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 | 127.0.0.1 | 3310 | 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 | 127.0.0.1 | 3310 | 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 | 127.0.0.1 | 3310 | 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 | 127.0.0.1 | 3310 | server_permanent_offline_time | | 3600s | 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 | 127.0.0.1 | 3310 | 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 | 127.0.0.1 | 3310 | 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 | 127.0.0.1 | 3310 | 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 | 127.0.0.1 | 3310 | 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 | 127.0.0.1 | 3310 | max_px_worker_count | | 64 | maximum parallel execution worker count can be used for all parallel requests. Range:[0, 65535] | TENANT | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | plan_cache_evict_interval | | 1s | time interval for periodic plan cache eviction. Range: [0s, +∞) | TENANT | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | plan_cache_low_watermark | | 1500M | (don't use now) memory usage at which plan cache eviction will be stopped. Range: [0, plan_cache_high_watermark) | TENANT | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | plan_cache_high_watermark | | 2000M | (don't use now) memory usage at which plan cache eviction will be trigger immediately. Range: [0, +∞) | TENANT | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | 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 | 127.0.0.1 | 3310 | 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 | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | global_write_halt_residual_memory | | 30 | disable write to memstore when observer memstore free memory(plus memory hold by blockcache) lower than this limit, Range: (0, 100)limit calc by (memory_limit - system_memory) * global_write_halt_residual_memory/100 | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | token_reserved_percentage | | 30 | specifies the amount of token increase allocated to a tenant based on his consumption from the last round (without exceeding his upper limit). Range: [0, 100] in percentage | TENANT | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | 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 | 127.0.0.1 | 3310 | 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 | 127.0.0.1 | 3310 | 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 | 127.0.0.1 | 3310 | 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 | 127.0.0.1 | 3310 | server_cpu_quota_max | | 1 | the number of maximal vCPUs allocated to the server tenant(a special internal tenant that exists on every observer). Range: [1, 16] | TENANT | CLUSTER | DEFAULT | STATIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | server_cpu_quota_min | | 1 | the number of minimal vCPUs allocated to the server tenant(a special internal tenant that exists on every observer). Range: [1, 16] | TENANT | CLUSTER | DEFAULT | STATIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | tenant_cpu_variation_per_server | | 50 | the percentage variation for any tenant\'s CPU quota allocation on each observer. The default value is 50(%). Range: [0, 100] in percentage | TENANT | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | tableapi_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 | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | 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 | 127.0.0.1 | 3310 | autoinc_cache_refresh_interval | | 86400s | auto-increment service cache refresh sync_value in this interval, with default 3600s. Range: [100ms, +∞) | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | 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 | 127.0.0.1 | 3310 | cache_wash_threshold | | 4GB | size of remaining memory at which cache eviction will be triggered. Range: [0,+∞) | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | memory_limit_percentage | | 80 | the size of the memory reserved for internal use(for testing purpose). Range: [10, 90] | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | enable_syslog_recycle | | True | specifies whether log file recycling is turned on. Value: True：turned on; False: turned off | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | enable_syslog_wf | | False | 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 | 127.0.0.1 | 3310 | enable_async_syslog | | True | specifies whether use async log for observer.log, elec.log and rs.log | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | max_syslog_file_count | | 4 | 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 | 127.0.0.1 | 3310 | syslog_io_bandwidth_limit | | 10M | Syslog IO bandwidth limitation, exceeding syslog would be truncated. Use 0 to disable ERROR log. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | syslog_level | | WARN | specifies the current level of logging. There are DEBUG, TRACE, INFO, WARN, USER_ERR, ERROR, six different log levels. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | obconfig_url | | | URL for OBConfig service | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | cluster_id | | 1 | ID of the cluster | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | cluster | | obcluster | Name of the cluster | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | rootservice_list | | 127.0.0.1:3310:3306 | a list of servers against which election candidate is checked for validation | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | weak_read_version_refresh_interval | | 100ms | the time interval to refresh cluster weak read version Range: [50ms, +∞) | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | default_compress | | archive | default compress strategy for create new table within oracle mode | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | default_row_format | | dynamic | default row format in mysql mode | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | 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 | 127.0.0.1 | 3310 | 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 | 127.0.0.1 | 3310 | 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 | 127.0.0.1 | 3310 | enable_perf_event | | True | specifies whether to enable perf event feature. The default value is True. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | 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 | 127.0.0.1 | 3310 | 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 | 127.0.0.1 | 3310 | 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 | 127.0.0.1 | 3310 | enable_record_trace_id | | True | specifies whether record app trace id is turned on. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | 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 | 127.0.0.1 | 3310 | max_string_print_length | | 500 | truncate very long string when printing to log file. Range:[0,] | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | system_trace_level | | 1 | system trace log level, 0:none, 1:standard, 2:debug. The default log level for trace log is 1 | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | 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 | 127.0.0.1 | 3310 | 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 | 127.0.0.1 | 3310 | trace_log_sampling_interval | | 10ms | the time interval for periodically printing log info in trace log. When force_trace_log is set to FALSE, for each time interval specifies by sampling_trace_log_interval, logging info regarding ‘slow query’ and ‘white list’ will be printed out. Range: [0ms,+∞) | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | cpu_count | | 8 | 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 | 127.0.0.1 | 3310 | system_memory | | 16G | 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 | 127.0.0.1 | 3310 | rootservice_memory_limit | | 2G | max memory size which can be used by rs tenant The default value is 2G. Range: [2G,) | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | memory_limit | | 30G | the size of the memory reserved for internal use(for testing purpose), 0 means follow memory_limit_percentage. Range: 0, [4G,). | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | tenant_task_queue_size | | 65536 | the size of the task queue for each tenant. Range: [1024,+∞) | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | rdma_io_thread_count | | 0 | the number of RDMA I/O threads for Libreasy. Range: [0, 8] in integer, 0 stands for RDMA being disabled. | OBSERVER | CLUSTER | DEFAULT | STATIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | 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 | 127.0.0.1 | 3310 | 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 | 127.0.0.1 | 3310 | 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 | 127.0.0.1 | 3310 | zone | | zone1 | specifies the zone name | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | devname | | lo | name of network adapter | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | mysql_port | | 3306 | port number for mysql connection. Range: (1024, 65536) in integer | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | rpc_port | | 3310 | the port number for RPC protocol. Range: (1024. 65536) in integer | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | leak_mod_to_check | | NONE | the name of the module under memory leak checks | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | config_additional_dir | | etc2;etc3 | additional directories of configure file | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | 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 | 127.0.0.1 | 3310 | datafile_disk_percentage | | 0 | the percentage of disk space used by the data files. Range: [0,99] in integer | SSTABLE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | datafile_size | | 60G | size of the data file. Range: [0, +∞) | SSTABLE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | 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 | 127.0.0.1 | 3310 | data_dir | | /var/lib/oceanbase/store | the directory for the data file | SSTABLE | CLUSTER | DEFAULT | READONLY | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | 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 False. Value: TRUE: trigger flush FALSE: do not trigger | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | 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 | 127.0.0.1 | 3310 | query_response_time_stats | | False | Enable or disable QUERY_RESPONSE_TIME statistics collectingThe default value is False. Value: TRUE: turned on FALSE: turned off | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | default_enable_extended_rowid | | False | specifies whether to create table as extended rowid mode or not | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | 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 | 127.0.0.1 | 3310 | default_auto_increment_mode | | order | specifies default auto-increment mode, default is 'order' | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | enable_sql_extension | | False | specifies whether to allow use some oracle mode features in mysql mode | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | 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 | 127.0.0.1 | 3310 | 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 | 127.0.0.1 | 3310 | 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 | 127.0.0.1 | 3310 | 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 | 127.0.0.1 | 3310 | 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 | 127.0.0.1 | 3310 | 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 | 127.0.0.1 | 3310 | 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 | 127.0.0.1 | 3310 | 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 | 127.0.0.1 | 3310 | plsql_v2_compatibility | | False | allows some abnormal behavior that Version 8 disallows, not available | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | 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 | 127.0.0.1 | 3310 | plsql_debug | | False | specifies whether or not PL/SQL library units will be compiled for debugging | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | plsql_code_type | | native | specifies the compilation mode for PL/SQL library units | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | 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 | 127.0.0.1 | 3310 | 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 | 127.0.0.1 | 3310 | 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 | 127.0.0.1 | 3310 | ob_enable_batched_multi_statement | | False | enable use of batched multi statement | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | audit_trail | | None | enables or disables database auditing, support NONE;OS;DB;DB,EXTENDED;DB_EXTENDED | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | audit_sys_operations | | False | whether trace sys user operations | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | sql_work_area | | 1G | Work area memory limitation for tenant | OBSERVER | TENANT | DEFAULT | STATIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | ob_compaction_schedule_interval | | 120s | the time interval to schedule compaction, Range: [3s,5m]Range: [3s, 5m] | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | 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 | 127.0.0.1 | 3310 | minor_compact_trigger | | 2 | minor_compact_trigger, Range: [0,16] in integer | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | 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 | 127.0.0.1 | 3310 | 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 | 127.0.0.1 | 3310 | 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 | 127.0.0.1 | 3310 | 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 | 127.0.0.1 | 3310 | 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 | 127.0.0.1 | 3310 | 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 | 127.0.0.1 | 3310 | io_category_config | | other: 100,100,100 | configs for different category of io request. specify with category name, minimal percentage, maximal percentage, weight percentage. devide the category with semicolon | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | enable_early_lock_release | | False | enable early lock release | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | 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 | 127.0.0.1 | 3310 | 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 | 127.0.0.1 | 3310 | 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 | 127.0.0.1 | 3310 | 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 | 127.0.0.1 | 3310 | workarea_size_policy | | AUTO | policy used to size SQL working areas (MANUAL/AUTO) | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | default_progressive_merge_num | | 0 | default progressive_merge_num when tenant create tableRange:[0,) | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | writing_throttling_maximum_duration | | 1h | maximum duration of writting throttling(in minutes), max value is 3 days | TRANS | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | writing_throttling_trigger_percentage | | 85 | 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 | 127.0.0.1 | 3310 | freeze_trigger_percentage | | 60 | the threshold of the size of the mem store when freeze will be triggered. Rang:(0，100) | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | undo_retention | | 1800 | the low threshold value of undo retention. The system retains undo for at least the time specified in this config. Range: [0, 4294967295] | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | cpu_quota_concurrency | | 10 | max allowed concurrency for 1 CPU quota. Range: [1,10] | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | enable_monotonic_weak_read | | False | specifies observer supportting atomicity and monotonic order read | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+ | zone1 | observer | 127.0.0.1 | 3310 | 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 | +--------+------------+-----------+------------+-------------------------------------------------+-------------+--------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+