obclient > show variables like 'version_comment'; +-----------------+------------------------------------------------------------------------------------------------------------------+ | Variable_name | Value | +=================+==================================================================================================================+ | version_comment | OceanBase_CE 4.3.4.0 (r100000162024110717-82547d6edc6ea98ba710e376a736a9a850499a06) (Built Nov 7 2024 17:28:11) | +-----------------+------------------------------------------------------------------------------------------------------------------+ obclient > SELECT * FROM oceanbase.DBA_OB_ZONES ORDER BY ZONE; +--------+----------------------------+----------------------------+----------+-------+------------+-----------+ | ZONE | CREATE_TIME | MODIFY_TIME | STATUS | IDC | REGION | TYPE | +========+============================+============================+==========+=======+============+===========+ | zone41 | 2024-12-06 22:51:49.098995 | 2024-12-06 22:51:49.100054 | ACTIVE | | sys_region | ReadWrite | +--------+----------------------------+----------------------------+----------+-------+------------+-----------+ | zone42 | 2024-12-06 22:51:49.100054 | 2024-12-06 22:51:49.100054 | ACTIVE | | sys_region | ReadWrite | +--------+----------------------------+----------------------------+----------+-------+------------+-----------+ | zone43 | 2024-12-06 22:51:49.100054 | 2024-12-06 22:51:49.100054 | ACTIVE | | sys_region | ReadWrite | +--------+----------------------------+----------------------------+----------+-------+------------+-----------+ obclient > SELECT * FROM oceanbase.DBA_OB_SERVERS ORDER BY ZONE; +--------------+------------+------+--------+------------+-------------------+----------+----------------------------+-------------+-------------------------+----------------------------+----------------------------+-------------------------------------------------------------------------------------------+----------------------------+ | SVR_IP | SVR_PORT | ID | ZONE | SQL_PORT | WITH_ROOTSERVER | STATUS | START_SERVICE_TIME | STOP_TIME | BLOCK_MIGRATE_IN_TIME | CREATE_TIME | MODIFY_TIME | BUILD_VERSION | LAST_OFFLINE_TIME | +==============+============+======+========+============+===================+==========+============================+=============+=========================+============================+============================+===========================================================================================+============================+ | 192.168.3.41 | 2882 | 1 | zone41 | 2881 | YES | ACTIVE | 2024-12-06 22:51:50.759484 | | | 2024-12-06 22:51:49.812442 | 2024-12-06 22:51:53.013002 | 4.3.4.0_100000162024110717-82547d6edc6ea98ba710e376a736a9a850499a06(Nov 7 2024 17:28:11) | | +--------------+------------+------+--------+------------+-------------------+----------+----------------------------+-------------+-------------------------+----------------------------+----------------------------+-------------------------------------------------------------------------------------------+----------------------------+ | 192.168.3.42 | 2882 | 2 | zone42 | 2881 | NO | ACTIVE | 2024-12-06 22:51:50.744684 | | | 2024-12-06 22:51:49.821846 | 2024-12-06 22:51:53.016700 | 4.3.4.0_100000162024110717-82547d6edc6ea98ba710e376a736a9a850499a06(Nov 7 2024 17:28:11) | | +--------------+------------+------+--------+------------+-------------------+----------+----------------------------+-------------+-------------------------+----------------------------+----------------------------+-------------------------------------------------------------------------------------------+----------------------------+ | 192.168.3.43 | 2882 | 3 | zone43 | 2881 | NO | INACTIVE | | | | 2024-12-06 22:51:49.827162 | 2024-12-18 15:56:36.013097 | 4.3.4.0_100000162024110717-82547d6edc6ea98ba710e376a736a9a850499a06(Nov 7 2024 17:28:11) | 2024-12-18 15:56:36.011258 | +--------------+------------+------+--------+------------+-------------------+----------+----------------------------+-------------+-------------------------+----------------------------+----------------------------+-------------------------------------------------------------------------------------------+----------------------------+ obclient > SELECT SVR_IP,SVR_PORT,ZONE,SQL_PORT,CPU_CAPACITY,CPU_CAPACITY_MAX,CPU_ASSIGNED,CPU_ASSIGNED_MAX, concat(ROUND(MEM_CAPACITY/1024/1024/1024,0), 'G') as MEM_CAPACITY, concat(ROUND(MEM_ASSIGNED/1024/1024/1024,0), 'G') as MEM_ASSIGNED, concat(ROUND(LOG_DISK_CAPACITY/1024/1024/1024,0), 'G') as LOG_DISK_CAPACITY, concat(ROUND(LOG_DISK_ASSIGNED/1024/1024/1024,0), 'G') as LOG_DISK_ASSIGNED, concat(ROUND(LOG_DISK_IN_USE/1024/1024/1024,0), 'G') as LOG_DISK_IN_USE, concat(ROUND(DATA_DISK_CAPACITY/1024/1024/1024,0), 'G') as DATA_DISK_CAPACITY,concat(ROUND(DATA_DISK_IN_USE/1024/1024/1024,0), 'G') as DATA_DISK_IN_USE,concat(ROUND(MEMORY_LIMIT/1024/1024/1024,0), 'G') as MEMORY_LIMIT,concat(ROUND(DATA_DISK_ALLOCATED/1024/1024/1024,0), 'G') as DATA_DISK_ALLOCATED FROM oceanbase.GV$OB_SERVERS; +--------------+------------+--------+------------+----------------+--------------------+----------------+--------------------+----------------+----------------+---------------------+---------------------+-------------------+----------------------+--------------------+----------------+-----------------------+ | SVR_IP | SVR_PORT | ZONE | SQL_PORT | CPU_CAPACITY | CPU_CAPACITY_MAX | CPU_ASSIGNED | CPU_ASSIGNED_MAX | MEM_CAPACITY | MEM_ASSIGNED | LOG_DISK_CAPACITY | LOG_DISK_ASSIGNED | LOG_DISK_IN_USE | DATA_DISK_CAPACITY | DATA_DISK_IN_USE | MEMORY_LIMIT | DATA_DISK_ALLOCATED | +==============+============+========+============+================+====================+================+====================+================+================+=====================+=====================+===================+======================+====================+================+=======================+ | 192.168.3.41 | 2882 | zone41 | 2881 | 16 | 16 | 4 | 4 | 34G | 4G | 110G | 11G | 9G | 177G | 14G | 41G | 110G | +--------------+------------+--------+------------+----------------+--------------------+----------------+--------------------+----------------+----------------+---------------------+---------------------+-------------------+----------------------+--------------------+----------------+-----------------------+ | 192.168.3.42 | 2882 | zone42 | 2881 | 16 | 16 | 4 | 4 | 34G | 4G | 110G | 11G | 9G | 198G | 13G | 41G | 110G | +--------------+------------+--------+------------+----------------+--------------------+----------------+--------------------+----------------+----------------+---------------------+---------------------+-------------------+----------------------+--------------------+----------------+-----------------------+ obclient > SELECT * FROM oceanbase.DBA_OB_TENANTS; +-------------+---------------+---------------+----------------------------+----------------------------+----------------+------------------------------------------------+---------------------+----------------------+----------+-----------------+----------+---------------+---------------------+--------------------+---------------------+---------------------+---------------------+----------------------+--------------+------------------------------+------------+--------------+-------------+---------------------+ | TENANT_ID | TENANT_NAME | TENANT_TYPE | CREATE_TIME | MODIFY_TIME | PRIMARY_ZONE | LOCALITY | PREVIOUS_LOCALITY | COMPATIBILITY_MODE | STATUS | IN_RECYCLEBIN | LOCKED | TENANT_ROLE | SWITCHOVER_STATUS | SWITCHOVER_EPOCH | SYNC_SCN | REPLAYABLE_SCN | READABLE_SCN | RECOVERY_UNTIL_SCN | LOG_MODE | ARBITRATION_SERVICE_STATUS | UNIT_NUM | COMPATIBLE | MAX_LS_ID | RESTORE_DATA_MODE | +=============+===============+===============+============================+============================+================+================================================+=====================+======================+==========+=================+==========+===============+=====================+====================+=====================+=====================+=====================+======================+==============+==============================+============+==============+=============+=====================+ | 1 | sys | SYS | 2024-12-06 22:51:48.898460 | 2024-12-06 22:51:48.898460 | RANDOM | FULL{1}@zone41, FULL{1}@zone42, FULL{1}@zone43 | | MYSQL | NORMAL | NO | NO | PRIMARY | NORMAL | 0 | | | | | NOARCHIVELOG | DISABLED | 1 | 4.3.4.0 | 1 | NORMAL | +-------------+---------------+---------------+----------------------------+----------------------------+----------------+------------------------------------------------+---------------------+----------------------+----------+-----------------+----------+---------------+---------------------+--------------------+---------------------+---------------------+---------------------+----------------------+--------------+------------------------------+------------+--------------+-------------+---------------------+ | 1001 | META$1002 | META | 2024-12-06 22:52:33.294679 | 2024-12-06 22:53:00.556832 | RANDOM | FULL{1}@zone41, FULL{1}@zone42, FULL{1}@zone43 | | MYSQL | NORMAL | NO | NO | PRIMARY | NORMAL | 0 | | | | | NOARCHIVELOG | DISABLED | 1 | 4.3.4.0 | 1 | NORMAL | +-------------+---------------+---------------+----------------------------+----------------------------+----------------+------------------------------------------------+---------------------+----------------------+----------+-----------------+----------+---------------+---------------------+--------------------+---------------------+---------------------+---------------------+----------------------+--------------+------------------------------+------------+--------------+-------------+---------------------+ | 1002 | ocp_meta | USER | 2024-12-06 22:52:33.297834 | 2024-12-06 22:53:00.625684 | RANDOM | FULL{1}@zone41, FULL{1}@zone42, FULL{1}@zone43 | | MYSQL | NORMAL | NO | NO | PRIMARY | NORMAL | 0 | 1734508682072175003 | 1734508682072175003 | 1734508680070102002 | 4611686018427387903 | NOARCHIVELOG | DISABLED | 1 | 4.3.4.0 | 1003 | NORMAL | +-------------+---------------+---------------+----------------------------+----------------------------+----------------+------------------------------------------------+---------------------+----------------------+----------+-----------------+----------+---------------+---------------------+--------------------+---------------------+---------------------+---------------------+----------------------+--------------+------------------------------+------------+--------------+-------------+---------------------+ obclient > SELECT c.TENANT_ID, e.TENANT_NAME, concat(c.NAME, ': ', d.NAME) `pool:conf`,concat(c.UNIT_COUNT, ' unit: ', d.min_cpu, 'C/', ROUND(d.MEMORY_SIZE/1024/1024/1024,0), 'G') unit_info FROM oceanbase.DBA_OB_RESOURCE_POOLS c, oceanbase.DBA_OB_UNIT_CONFIGS d, oceanbase.DBA_OB_TENANTS e WHERE c.UNIT_CONFIG_ID=d.UNIT_CONFIG_ID AND c.TENANT_ID=e.TENANT_ID ORDER BY c.TENANT_ID; +-------------+---------------+------------------------------+---------------+ | TENANT_ID | TENANT_NAME | pool:conf | unit_info | +=============+===============+==============================+===============+ | 1 | sys | sys_pool: sys_unit_config | 1 unit: 3C/2G | +-------------+---------------+------------------------------+---------------+ | 1002 | ocp_meta | ocp_meta_pool: ocp_meta_unit | 1 unit: 1C/2G | +-------------+---------------+------------------------------+---------------+ obclient > SELECT a.TENANT_NAME,a.TENANT_ID,b.SVR_IP FROM oceanbase.DBA_OB_TENANTS a, oceanbase.GV$OB_UNITS b WHERE a.TENANT_ID=b.TENANT_ID; +---------------+-------------+--------------+ | TENANT_NAME | TENANT_ID | SVR_IP | +===============+=============+==============+ | sys | 1 | 192.168.3.41 | +---------------+-------------+--------------+ | META$1002 | 1001 | 192.168.3.41 | +---------------+-------------+--------------+ | ocp_meta | 1002 | 192.168.3.41 | +---------------+-------------+--------------+ | sys | 1 | 192.168.3.42 | +---------------+-------------+--------------+ | META$1002 | 1001 | 192.168.3.42 | +---------------+-------------+--------------+ | ocp_meta | 1002 | 192.168.3.42 | +---------------+-------------+--------------+ obclient > select /*+read_consistency(weak) QUERY_TIMEOUT(60000000) */ t1.svr_ip, t1.role, t1.tenant_id,t1.database_name,t1.table_name, ifnull(t2.data_size,0) / 1073741824 as total_data_size_gb from (select tenant_id, database_name, table_name, role, svr_ip, table_id, tablet_id from oceanbase.cdb_ob_table_locations) t1 left join (select tenant_id, tablet_id, data_size from oceanbase.cdb_ob_tablet_replicas) t2 on t1.tenant_id = t2.tenant_id and t1.tablet_id = t2.tablet_id order by total_data_size_gb desc limit 50; +--------------+----------+-------------+-----------------+-----------------------------+----------------------+ | svr_ip | role | tenant_id | database_name | table_name | total_data_size_gb | +==============+==========+=============+=================+=============================+======================+ | 192.168.3.42 | FOLLOWER | 1 | ob | da_sale | 2.64 | +--------------+----------+-------------+-----------------+-----------------------------+----------------------+ | 192.168.3.43 | FOLLOWER | 1 | ob | da_sale | 2.64 | +--------------+----------+-------------+-----------------+-----------------------------+----------------------+ | 192.168.3.42 | FOLLOWER | 1 | ob | da_sale | 2.64 | +--------------+----------+-------------+-----------------+-----------------------------+----------------------+ | 192.168.3.41 | LEADER | 1 | ob | da_sale | 2.64 | +--------------+----------+-------------+-----------------+-----------------------------+----------------------+ | 192.168.3.42 | FOLLOWER | 1 | ob | da_sale | 2.64 | +--------------+----------+-------------+-----------------+-----------------------------+----------------------+ | 192.168.3.43 | FOLLOWER | 1 | ob | da_sale | 2.64 | +--------------+----------+-------------+-----------------+-----------------------------+----------------------+ | 192.168.3.43 | FOLLOWER | 1 | ob | da_sale | 2.64 | +--------------+----------+-------------+-----------------+-----------------------------+----------------------+ | 192.168.3.41 | LEADER | 1 | ob | da_sale | 2.64 | +--------------+----------+-------------+-----------------+-----------------------------+----------------------+ | 192.168.3.41 | LEADER | 1 | ob | da_sale | 2.64 | +--------------+----------+-------------+-----------------+-----------------------------+----------------------+ | 192.168.3.41 | LEADER | 1 | ob | __idx_500096_idx_da_sale | 1.6589 | +--------------+----------+-------------+-----------------+-----------------------------+----------------------+ | 192.168.3.42 | FOLLOWER | 1 | ob | __idx_500096_idx_da_sale | 1.6589 | +--------------+----------+-------------+-----------------+-----------------------------+----------------------+ | 192.168.3.43 | FOLLOWER | 1 | ob | __idx_500096_idx_da_sale | 1.6589 | +--------------+----------+-------------+-----------------+-----------------------------+----------------------+ | 192.168.3.41 | LEADER | 1 | ob | __idx_500096_idx_da_sale | 1.6589 | +--------------+----------+-------------+-----------------+-----------------------------+----------------------+ | 192.168.3.42 | FOLLOWER | 1 | ob | __idx_500096_idx_da_sale | 1.6589 | +--------------+----------+-------------+-----------------+-----------------------------+----------------------+ | 192.168.3.43 | FOLLOWER | 1 | ob | __idx_500096_idx_da_sale | 1.6589 | +--------------+----------+-------------+-----------------+-----------------------------+----------------------+ | 192.168.3.41 | LEADER | 1 | ob | __idx_500096_idx_da_sale | 1.6589 | +--------------+----------+-------------+-----------------+-----------------------------+----------------------+ | 192.168.3.43 | FOLLOWER | 1 | ob | __idx_500096_idx_da_sale | 1.6589 | +--------------+----------+-------------+-----------------+-----------------------------+----------------------+ | 192.168.3.42 | FOLLOWER | 1 | ob | __idx_500096_idx_da_sale | 1.6589 | +--------------+----------+-------------+-----------------+-----------------------------+----------------------+ | 192.168.3.41 | LEADER | 1 | ob | da_sale_imp2 | 1.3799 | +--------------+----------+-------------+-----------------+-----------------------------+----------------------+ | 192.168.3.42 | FOLLOWER | 1 | ob | da_sale_imp2 | 1.3799 | +--------------+----------+-------------+-----------------+-----------------------------+----------------------+ | 192.168.3.41 | LEADER | 1 | ob | da_sale_imp2 | 1.3799 | +--------------+----------+-------------+-----------------+-----------------------------+----------------------+ | 192.168.3.43 | FOLLOWER | 1 | ob | da_sale_imp2 | 1.3799 | +--------------+----------+-------------+-----------------+-----------------------------+----------------------+ | 192.168.3.42 | FOLLOWER | 1 | ob | da_sale_imp2 | 1.3799 | +--------------+----------+-------------+-----------------+-----------------------------+----------------------+ | 192.168.3.43 | FOLLOWER | 1 | ob | da_sale_imp2 | 1.3799 | +--------------+----------+-------------+-----------------+-----------------------------+----------------------+ | 192.168.3.42 | FOLLOWER | 1 | ob | da_sale_imp2 | 1.3799 | +--------------+----------+-------------+-----------------+-----------------------------+----------------------+ | 192.168.3.43 | FOLLOWER | 1 | ob | da_sale_imp2 | 1.3799 | +--------------+----------+-------------+-----------------+-----------------------------+----------------------+ | 192.168.3.41 | LEADER | 1 | ob | da_sale_imp2 | 1.3799 | +--------------+----------+-------------+-----------------+-----------------------------+----------------------+ | 192.168.3.42 | FOLLOWER | 1 | ob | da_sale_imp | 1.1014 | +--------------+----------+-------------+-----------------+-----------------------------+----------------------+ | 192.168.3.41 | LEADER | 1 | ob | da_sale_imp | 1.1014 | +--------------+----------+-------------+-----------------+-----------------------------+----------------------+ | 192.168.3.41 | LEADER | 1 | ob | da_sale_imp | 1.1014 | +--------------+----------+-------------+-----------------+-----------------------------+----------------------+ | 192.168.3.42 | FOLLOWER | 1 | ob | da_sale_imp | 1.1014 | +--------------+----------+-------------+-----------------+-----------------------------+----------------------+ | 192.168.3.42 | FOLLOWER | 1 | ob | da_sale_imp | 1.1014 | +--------------+----------+-------------+-----------------+-----------------------------+----------------------+ | 192.168.3.43 | FOLLOWER | 1 | ob | da_sale_imp | 1.1014 | +--------------+----------+-------------+-----------------+-----------------------------+----------------------+ | 192.168.3.43 | FOLLOWER | 1 | ob | da_sale_imp | 1.1014 | +--------------+----------+-------------+-----------------+-----------------------------+----------------------+ | 192.168.3.41 | LEADER | 1 | ob | da_sale_imp | 1.1014 | +--------------+----------+-------------+-----------------+-----------------------------+----------------------+ | 192.168.3.43 | FOLLOWER | 1 | ob | da_sale_imp | 1.1014 | +--------------+----------+-------------+-----------------+-----------------------------+----------------------+ | 192.168.3.42 | FOLLOWER | 1 | ob | da_sale_imp | 0.5178 | +--------------+----------+-------------+-----------------+-----------------------------+----------------------+ | 192.168.3.41 | LEADER | 1 | ob | da_sale_imp | 0.5178 | +--------------+----------+-------------+-----------------+-----------------------------+----------------------+ | 192.168.3.42 | FOLLOWER | 1 | ob | da_sale_imp | 0.5178 | +--------------+----------+-------------+-----------------+-----------------------------+----------------------+ | 192.168.3.43 | FOLLOWER | 1 | ob | da_sale_imp | 0.5178 | +--------------+----------+-------------+-----------------+-----------------------------+----------------------+ | 192.168.3.42 | FOLLOWER | 1 | ob | da_sale_imp | 0.5178 | +--------------+----------+-------------+-----------------+-----------------------------+----------------------+ | 192.168.3.41 | LEADER | 1 | ob | da_sale_imp | 0.5178 | +--------------+----------+-------------+-----------------+-----------------------------+----------------------+ | 192.168.3.41 | LEADER | 1 | ob | da_sale_imp | 0.5178 | +--------------+----------+-------------+-----------------+-----------------------------+----------------------+ | 192.168.3.43 | FOLLOWER | 1 | ob | da_sale_imp | 0.5178 | +--------------+----------+-------------+-----------------+-----------------------------+----------------------+ | 192.168.3.43 | FOLLOWER | 1 | ob | da_sale_imp | 0.5178 | +--------------+----------+-------------+-----------------+-----------------------------+----------------------+ | 192.168.3.41 | LEADER | 1 | ob | __idx_500096_idx_da_sale_01 | 0.4897 | +--------------+----------+-------------+-----------------+-----------------------------+----------------------+ | 192.168.3.43 | FOLLOWER | 1 | ob | __idx_500096_idx_da_sale_01 | 0.4897 | +--------------+----------+-------------+-----------------+-----------------------------+----------------------+ | 192.168.3.42 | FOLLOWER | 1 | ob | __idx_500096_idx_da_sale_01 | 0.4897 | +--------------+----------+-------------+-----------------+-----------------------------+----------------------+ | 192.168.3.42 | FOLLOWER | 1 | ob | __idx_500096_idx_da_sale_01 | 0.4897 | +--------------+----------+-------------+-----------------+-----------------------------+----------------------+ | 192.168.3.41 | LEADER | 1 | ob | __idx_500096_idx_da_sale_01 | 0.4897 | +--------------+----------+-------------+-----------------+-----------------------------+----------------------+ obclient > show parameters +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone | svr_type | svr_ip | svr_port | name | data_type | value | info | section | scope | source | edit_level | default_value | isdefault | +========+============+==============+============+=================================================+=============+==========================================================================================+====================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================+================+=========+==========+===================+=================+=============+ | zone41 | observer | 192.168.3.41 | 2882 | ob_storage_s3_url_encode_type | STRING | default | Determines the URL encoding method for S3 requests."default": Uses the S3 standard URL encoding method."compliantRfc3986Encoding": Uses URL encoding that adheres to the RFC 3986 standard. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | default | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | _enable_dbms_job_package | BOOL | False | Control whether can use DBMS_JOB package. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | True | 0 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | enable_ob_error_msg_style | BOOL | True | A switch that determines whether to use the ORA-xx or OBE-xx error code format for ORA error codes, with a default value of True to use the OBE-xx format.The default value is True. Value: False means we use the ORA-xx format, True means we use the OBE-xx format. | OBSERVER | CLUSTER | DEFAULT | STATIC_EFFECTIVE | True | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | strict_check_os_params | BOOL | False | A switch that determines whether to enable strict OS parameter check mode, defaulting to true and can be set to false to bypass strict checks.Value: True: allowed; False: allowed but not suggested | OBSERVER | CLUSTER | DEFAULT | STATIC_EFFECTIVE | False | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | enable_rpc_authentication_bypass | BOOL | True | specifies whether allow OMS service to connect cluster and provide service when rpc authentication is turned on. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | True | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | sql_protocol_min_tls_version | STRING | none | SQL SSL control options, used to specify the minimum SSL/TLS version number. values: none, TLSv1, TLSv1.1, TLSv1.2, TLSv1.3 | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | none | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | rpc_server_authentication_method | STRING | ALL | specifies rpc server authentication method. ALL: support all authentication methods. NONE: without authentication. SSL_NO_ENCRYPT: authentication by SSL handshake but not encrypt the communication channel. SSL_IO: authentication by SSL handshake and encrypt the communication channel | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | ALL | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | rpc_client_authentication_method | STRING | NONE | specifies rpc client authentication method. NONE: without authentication. SSL_NO_ENCRYPT: authentication by SSL handshake but not encrypt the communication channel. SSL_IO: authentication by SSL handshake and encrypt the communication channel | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | NONE | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | observer_id | INT | 1 | the unique id that been assigned by rootservice for each observer in cluster, default: 0 (invalid id), Range: [1, 18446744073709551615] | OBSERVER | CLUSTER | DEFAULT | READONLY | 0 | 0 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | local_ip | STRING | 192.168.3.41 | the IP address of the machine on which the ObServer will be installed | OBSERVER | CLUSTER | DEFAULT | READONLY | | 0 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | enable_dblink | BOOL | True | Enable or disable dblink | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | True | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | global_background_cpu_quota | DOUBLE | -1 | When enable_global_background_resource_isolation is True, specify the number of vCPUs allocated to the background tasks-1 for the CPU is not limited by the cgroup | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | -1 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | enable_global_background_resource_isolation | BOOL | False | When set to false, foreground and background tasks are isolated within the tenant; When set to true, isolate background tasks individually upon tenant-level | OBSERVER | CLUSTER | DEFAULT | STATIC_EFFECTIVE | False | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | enable_cgroup | BOOL | 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 | True | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | sql_net_thread_count | INT | 0 | the number of global mysql I/O threads. Range: [0, 64] in integer, default value is 0, 0 stands for old value GCONF.net_thread_count | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 0 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | sql_login_thread_count | INT | 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 | 0 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | tcp_keepcnt | INT | 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 | 10 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | tcp_keepintvl | TIME | 6s | The time (in seconds) between individual keepalive probes. Take effect for new established connections. Range: [1s, +∞] | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 6s | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | tcp_keepidle | TIME | 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 | 7200s | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | enable_tcp_keepalive | BOOL | True | enable TCP keepalive for the TCP connection of sql protocol. Take effect for new established connections. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | true | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | ob_ratelimit_stat_period | TIME | 1s | the time interval to update observer's maximum bandwidth to a certain region. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 1s | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | enable_ob_ratelimit | BOOL | False | enable ratelimit between regions for RPC connection. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | False | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | ssl_external_kms_info | STRING | | when using the external key management center for ssl, this parameter will store some key management information | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | use_large_pages | STRING | false | used to manage the database's use of large pages, values: false, true, only | OBSERVER | CLUSTER | DEFAULT | STATIC_EFFECTIVE | false | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | schema_history_recycle_interval | TIME | 10m | the time interval between the schedules of schema history recyle task. Range: [0s, +∞) | LOAD_BALANCE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 10m | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | _bloom_filter_ratio | INT | 3 | the px bloom filter false-positive rate.the default value is 1, range: [0,100] | TENANT | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 35 | 0 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | use_ipv6 | BOOL | False | Whether this server uses ipv6 address | OBSERVER | CLUSTER | DEFAULT | STATIC_EFFECTIVE | False | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | ssl_client_authentication | BOOL | False | enable server SSL support. Takes effect after ca/cert/key file is configured correctly. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | False | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | stack_size | CAPACITY | 512K | the size of routine execution stackRange: [512K, 20M] | OBSERVER | CLUSTER | DEFAULT | STATIC_EFFECTIVE | 512K | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | px_task_size | CAPACITY | 2M | to be removed | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 2M | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | dtl_buffer_size | CAPACITY | 64K | to be removed | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 64K | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | micro_block_merge_verify_level | INT | 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 | 2 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | builtin_db_data_verify_cycle | INT | 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 | 20 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | tablet_size | CAPACITY | 128M | default tablet size, has to be a multiple of 2M | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 128M | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | sys_bkgd_migration_change_member_list_timeout | TIME | 20s | the timeout for migration change member list retry. The default value is 20s. Range: [0s,24h] | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 20s | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | sys_bkgd_migration_retry_num | INT | 3 | retry num limit during migration. Range: [3, 100] in integer | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 3 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | sync_io_thread_count | INT | 0 | The number of io threads for synchronizing request on each device. The default value is 0. Range: [0,1024] in integer | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 0 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | disk_io_thread_count | INT | 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 | 8 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | sys_bkgd_net_percentage | INT | 60 | the net percentage of sys background net. Range: [0, 100] in integer | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 60 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | data_disk_usage_limit_percentage | INT | 90 | the safe use percentage of data diskRange: [50,100] in integer | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 90 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | data_storage_error_tolerance_time | 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 | 300s | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | data_storage_warning_tolerance_time | TIME | 5s | time to tolerate disk read failure, after that, the disk status will be set warning. Range [1s,300s]. The default value is 5s | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 5s | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | storage_meta_cache_priority | INT | 10 | storage meta cache priority. Range:[1, ) | CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 10 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | fuse_row_cache_priority | INT | 1 | fuse row cache priority. Range:[1, ) | CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 1 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | bf_cache_miss_count_threshold | INT | 100 | bf cache miss count threshold, 0 means disable bf cache. Range:[0, ) | CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 100 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | bf_cache_priority | INT | 1 | bf cache priority. Range:[1, ) | CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 1 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | user_row_cache_priority | INT | 1 | user row cache priority. Range:[1, ) | CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 1 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | user_block_cache_priority | INT | 1 | user block cache priority. Range:[1, ) | CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 1 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | index_block_cache_priority | INT | 10 | index cache priority. Range:[1, ) | CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 10 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | opt_tab_stat_cache_priority | INT | 1 | tab stat cache priority. Range:[1, ) | CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 1 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | tablet_ls_cache_priority | INT | 1000 | tablet ls cache priority. Range:[1, ) | CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 1000 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | location_cache_refresh_sql_timeout | TIME | 1s | The timeout used for refreshing location cache by SQL. Range: [1ms, +∞) | LOCATION_CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 1s | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | location_cache_refresh_rpc_timeout | TIME | 500ms | The timeout used for refreshing location cache by RPC. Range: [1ms, +∞) | LOCATION_CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 500ms | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | all_server_list | STRING | 192.168.3.41:2882,192.168.3.42:2882,192.168.3.43:2882 | all server addr in cluster | LOCATION_CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | 0 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | location_cache_refresh_min_interval | TIME | 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 | 100ms | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | location_fetch_concurrency | INT | 20 | the maximum number of the tasks for fetching location cache concurrently. Range: [1, 1000] | LOCATION_CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 20 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | location_refresh_thread_count | INT | 2 | the number of threads for fetching location cache in the background. Range: (1, 64] | LOCATION_CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 2 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | virtual_table_location_cache_expire_time | TIME | 8s | expiration time for virtual table location info in partition location cache. Range: [1s, +∞) | LOCATION_CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 8s | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | standby_fetch_log_bandwidth_limit | CAPACITY | 0MB | the max bandwidth in bytes per second that can be occupied by the sum of the synchronizing log from primary cluster of all servers in the standby cluster | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 0MB | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | rpc_timeout | TIME | 2s | the time during which a RPC request is permitted to execute before it is terminated | RPC | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 2s | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | ignore_replay_checksum_error | BOOL | 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 | False | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | row_compaction_update_limit | INT | 6 | maximum update count before trigger row compaction. Range: [1, 6400] | TRANS | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 6 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | clog_sync_time_warn_threshold | TIME | 100ms | the time given to the commit log synchronization between a leader and its followers before a \'warning\' message is printed in the log file. Range: [1ms,1000ms] | TRANS | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 100ms | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | trx_2pc_retry_interval | TIME | 100ms | the time interval between the retries in case of failure during a transaction\'s two-phase commit phase. Range: [1ms,5000ms] | TRANS | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 100ms | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | enable_sys_unit_standalone | BOOL | False | specifies whether sys unit standalone deployment is turned on. Value: True:turned on False: turned off | LOAD_BALANCE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | False | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | server_balance_cpu_mem_tolerance_percent | INT | 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 | 5 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | server_balance_disk_tolerance_percent | INT | 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 | 1 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | server_balance_critical_disk_waterlevel | INT | 80 | disk water level to determine server balance strategy | LOAD_BALANCE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 80 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | __min_full_resource_pool_memory | INT | 2147483648 | the min memory value which is specified for a full resource pool. | LOAD_BALANCE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 5368709120 | 0 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | balancer_log_interval | TIME | 1m | the time interval between logging the load-balancing task\'s statistics. Range: [1s, +∞) | LOAD_BALANCE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 1m | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | balancer_task_timeout | TIME | 20m | the time to execute the load-balancing task before it is terminated. Range: [1s, +∞) | LOAD_BALANCE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 20m | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | balancer_tolerance_percentage | INT | 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 | 10 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | enable_rereplication | BOOL | True | specifies whether the auto-replication is turned on. Value: True:turned on False: turned off | LOAD_BALANCE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | True | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | resource_hard_limit | INT | 100 | system utilization should not be large than resource_hard_limit | LOAD_BALANCE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 100 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | arbitration_degradation_policy | STRING | LS_POLICY | specifies the degradation policy, whether to check network connectivity with RS before arbitration degrades. Value: LS_POLICY, CLUSTER_POLICY LS_POLICY: default policy. CLUSTER_POLICY: check network connectivity with RS before arbitration degrades. Do not degrade when not connected. Then, switch log stream leaders to the replicas which are connected with RS. | LOGSERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | LS_POLICY | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | log_storage_warning_tolerance_time | TIME | 5s | time to tolerate log disk io delay, after that, the disk status will be set warning. Range: [1s,300s] | LOGSERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 5s | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | log_disk_percentage | INT | 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 | 0 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | log_disk_size | CAPACITY | 110G | the size of disk space used by the log files. Range: [0, +∞) | LOGSERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 0M | 0 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | recyclebin_object_expire_time | TIME | 0s | recyclebin object expire time, default 0 that means auto purge recyclebin off. Range: [0s, +∞) | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 0s | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | ob_event_history_recycle_interval | TIME | 7d | the time to recycle event history. Range: [1d, 180d] | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 7d | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | enable_crazy_medium_compaction | BOOL | False | enables triggering medium compaction repeatly. The default value is False. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | False | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | enable_major_freeze | BOOL | True | specifies whether major_freeze function is turned on. Value: True:turned on; False: turned off | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | True | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | enable_ddl | BOOL | True | specifies whether DDL operation is turned on. Value: True:turned on; False: turned off | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | True | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | min_observer_version | STRING | 4.3.4.0 | the min observer version | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 4.3.4.0 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | tablet_meta_table_check_interval | TIME | 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 | 30m | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | ls_meta_table_check_interval | TIME | 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 | 1s | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | tablet_meta_table_scan_batch_count | INT | 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 | 999 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | rootservice_ready_check_interval | TIME | 3s | the interval between the schedule of the rootservice restart task while restart failed Range: [100000us, 1m] | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 3s | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | server_check_interval | TIME | 30s | the time interval between schedules of a task that examines the __all_server table. Range: [1s, +∞) | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 30s | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | migration_disable_time | 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 | 3600s | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | server_permanent_offline_time | 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 | 3600s | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | enable_sys_table_ddl | BOOL | False | specifies whether a \'system\' table is allowed be to created manually. Value: True: allowed; False: not allowed | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | False | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | rootservice_async_task_queue_size | INT | 16384 | the size of the queue for all asynchronous tasks at rootserver. Range: [8, 131072] in integer | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 16384 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | rootservice_async_task_thread_count | INT | 4 | maximum of threads allowed for executing asynchronous task at rootserver. Range: [1, 10] | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 4 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | lease_time | 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 | 10s | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | plan_cache_evict_interval | TIME | 5s | time interval for periodic plan cache eviction. Range: [0s, +∞) | TENANT | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 5s | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | data_disk_write_limit_percentage | INT | 0 | used to stop user write operations. When the user data disk reaches this watermark, SQL requests will report that the disk is full. The configuration should be greater than data_disk_usage_limit_percentage, with the recommended setting being: (1 - memstore_limit_size / data_disk_size) * 100% | TENANT | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 0 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | memstore_limit_percentage | INT | 0 | used in calculating the value of MEMSTORE_LIMIT parameter: memstore_limit_percentage = memstore_limit / memory_size, where MEMORY_SIZE is determined when the tenant is created. Range: [0, 100). 1. the system will use memstore_limit_percentage if only memstore_limit_percentage is set.2. the system will use _memstore_limit_percentage if both memstore_limit_percentage and _memstore_limit_percentage is set.3. the system will adjust automatically if both memstore_limit_percentage and _memstore_limit_percentage set to 0(by default). | TENANT | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 0 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | large_query_threshold | TIME | 600s | threshold for execution time beyond which a request may be paused and rescheduled as a \'large request\', 0ms means disable \'large request\'. Range: [0ms, +∞) | TENANT | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 5s | 0 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | large_query_worker_percentage | DOUBLE | 30 | the percentage of the workers reserved to serve large query request. Range: [0, 100] in percentage | TENANT | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 30 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | workers_per_cpu_quota | INT | 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 | 10 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | location_cache_cpu_quota | DOUBLE | 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 | 5 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | server_cpu_quota_max | DOUBLE | 0 | the number of maximal vCPUs allocated to the server tenant(a special internal tenant that exists on every observer). 0 stands for adaptive. Range: [0, 16] | TENANT | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 0 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | server_cpu_quota_min | DOUBLE | 0 | the number of minimal vCPUs allocated to the server tenant(a special internal tenant that exists on every observer). 0 stands for adaptive. Range: [0, 16] | TENANT | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 0 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | enable_sql_operator_dump | BOOL | True | specifies whether sql operators (sort/hash join/material/window function/interm result/...) allowed to write to disk | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | True | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | autoinc_cache_refresh_interval | TIME | 3600s | auto-increment service cache refresh sync_value in this interval, with default 3600s. Range: [100ms, +∞) | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 3600s | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | memory_chunk_cache_size | CAPACITY | 0M | the maximum size of memory cached by memory chunk cache. Range: [0M,], 0 stands for adaptive | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 0M | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | cache_wash_threshold | CAPACITY | 4GB | size of remaining memory at which cache eviction will be triggered. Range: [0,+∞) | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 4GB | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | memory_limit_percentage | INT | 80 | the size of the memory reserved for internal use(for testing purpose). Range: [10, 95] | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 80 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | syslog_file_uncompressed_count | INT | 0 | specifies the minimum number of the syslog files that will not be compressed. Each syslog file can occupy at most 256MB disk space. When this value is set to 0, all syslog file may be compressed. Range: [0, +∞) in integer | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 0 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | syslog_compress_func | STRING | none | compress function name for syslog files, values: none, zstd_1.0, zstd_1.3.8 | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | none | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | syslog_disk_size | CAPACITY | 0M | the size of disk space used by the syslog files. Range: [0, +∞) | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 0M | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | enable_syslog_recycle | BOOL | True | specifies whether log file recycling is turned on. Value: True：turned on; False: turned off | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | False | 0 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | enable_syslog_wf | BOOL | 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 | True | 0 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | enable_async_syslog | BOOL | True | specifies whether use async log for observer.log, elec.log and rs.log | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | True | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | max_syslog_file_count | INT | 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 | 0 | 0 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | diag_syslog_per_error_limit | INT | 200 | DIAG syslog limitation for each error per second, exceeding syslog would be truncated | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 200 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | syslog_io_bandwidth_limit | CAPACITY | 30MB | Syslog IO bandwidth limitation, exceeding syslog would be truncated. Use 0 to disable ERROR log. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 30MB | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | alert_log_level | STRING | INFO | specifies the current level of alert log. There are INFO, WARN, ERROR, three different log levels. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | INFO | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | syslog_level | STRING | WDIAG | specifies the current level of logging. There are DEBUG, TRACE, WDIAG, EDIAG, INFO, WARN, ERROR, seven different log levels. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | WDIAG | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | obconfig_url | STRING | http://192.168.3.41:8080/services?Action=ObRootServiceInfo&ObCluster=ocbase_test_cluster | URL for OBConfig service | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | 0 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | cluster_id | INT | 1733496353 | ID of the cluster | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 0 | 0 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | cluster | STRING | ocbase_test_cluster | Name of the cluster | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | obcluster | 0 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | rootservice_list | STR_LIST | 192.168.3.41:2882:2881;192.168.3.42:2882:2881 | a list of servers against which election candidate is checked for validation | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | 0 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | weak_read_version_refresh_interval | TIME | 100ms | the time interval to refresh cluster weak read version Range: [50ms, +∞) | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 100ms | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | default_compress | STRING | archive | default compress strategy for create new table within oracle mode | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | archive | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | default_row_format | STRING | dynamic | default row format in mysql mode | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | dynamic | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | default_compress_func | STRING | zstd_1.3.8 | default compress function name for create new table, values: none, lz4_1.0, snappy_1.0, zstd_1.0, zstd_1.3.8 | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | zstd_1.3.8 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | schema_history_expire_time | 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 | 7d | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | enable_upgrade_mode | BOOL | 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 | False | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | enable_perf_event | BOOL | True | specifies whether to enable perf event feature. The default value is True. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | True | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | dead_socket_detection_timeout | TIME | 3s | specify a tcp_user_timeout for RFC5482. A zero value makes the option disabled, Range: [0, 2h] | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 3s | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | debug_sync_timeout | TIME | 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 | 0 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | enable_rich_error_msg | BOOL | False | specifies whether add ip:port, time and trace id to user error message. The default value is FALSE. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | false | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | enable_record_trace_id | BOOL | False | specifies whether record app trace id is turned on. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | False | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | enable_sql_audit | BOOL | 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 | true | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | max_string_print_length | INT | 500 | truncate very long string when printing to log file. Range:[0,] | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 500 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | enable_record_trace_log | BOOL | False | specifies whether to always record the trace log. The default value is True. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | True | 0 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | trace_log_slow_query_watermark | TIME | 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 | 1s | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | cpu_count | INT | 16 | 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 | 0 | 0 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | system_memory | CAPACITY | 7G | 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 | 0M | 0 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | memory_limit | CAPACITY | 41G | the size of the memory reserved for internal use(for testing purpose), 0 means follow memory_limit_percentage. Range: 0, [1G,). | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 0M | 0 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | tenant_task_queue_size | INT | 16384 | the size of the task queue for each tenant. Range: [1024,+∞) | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 16384 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | high_priority_net_thread_count | INT | 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 | 0 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | net_thread_count | INT | 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 | 0 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | internal_sql_execute_timeout | TIME | 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 | 30s | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | ob_startup_mode | STRING | NORMAL | specifies the observer startup mode | OBSERVER | CLUSTER | DEFAULT | READONLY | NORMAL | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | zone | STRING | zone41 | specifies the zone name | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | 0 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | devname | STRING | ens192 | name of network adapter | OBSERVER | CLUSTER | DEFAULT | READONLY | bond0 | 0 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | mysql_port | INT | 2881 | port number for mysql connection. Range: (1024, 65536) in integer | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 2881 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | rpc_port | INT | 2882 | the port number for RPC protocol. Range: (1024, 65536) in integer | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 2882 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | leak_mod_to_check | STRING | NONE | the name of the module under memory leak checks | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | NONE | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | config_additional_dir | STR_LIST | etc2;etc3 | additional directories of configure file | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | etc2;etc3 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | memory_reserved | CAPACITY | 500M | the size of the system memory reserved for emergency internal use. Range: [10M, total size of memory] | SSTABLE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 500M | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | datafile_disk_percentage | INT | 0 | the percentage of disk space used by the data files. Range: [0,99] in integer | SSTABLE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 0 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | datafile_maxsize | CAPACITY | 193G | the auto extend max size. Range: [0, +∞) | SSTABLE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 0 | 0 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | datafile_next | CAPACITY | 19G | the auto extend step. Range: [0, +∞) | SSTABLE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 0 | 0 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | datafile_size | CAPACITY | 110G | size of the data file. Range: [0, +∞) | SSTABLE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 0M | 0 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | redundancy_level | STRING | NORMAL | EXTERNAL: use extrernal redundancyNORMAL: tolerate one disk failureHIGH: tolerate two disk failure if disk count is enough | SSTABLE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | NORMAL | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | data_dir | STRING | /data/ocbase_test_cluster/oceanbase/store | the directory for the data file | SSTABLE | CLUSTER | DEFAULT | READONLY | store | 0 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | ob_encoding_granularity | INT | 65536 | Maximum rows for encoding in one micro block. Range:[8192,1048576] | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 65536 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | ob_vector_memory_limit_percentage | INT | 0 | Used to control the upper limit percentage of memory resources that the vector_index module can use. Range:[0, 100) | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 0 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | kv_group_commit_rw_mode | STRING | ALL | Used to specify the read/write operation types when group commit is enable. Values: 'ALL' means enable all operations, 'READ' mean only enable read operation in group commit, 'WRITE' means only write operations in group commit. | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | ALL | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | kv_group_commit_batch_size | INT | 1 | Used to specify the batch size of each group commit batch in OBKV. Values: 1 means sinlge operaion in each batch, equally to disable group commit. When batch size is greater than 1, it means group commit is enable and used as its batch size. | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 1 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | direct_load_allow_fallback | BOOL | False | Control whether an error is reported when direct load of the derivative operation scenario is not supported. | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | False | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | default_load_mode | STRING | DISABLED | Specifies default load data path."DISABLED" represent load data not in direct load path (default value)."FULL_DIRECT_WRITE" represent load data in full direct load path with insert semantics."INC_DIRECT_WRITE" represent load data in inc direct load path with insert semantics."INC_REPLACE_DIRECT_WRITE" represent load data in inc direct load path with replace semantics. | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | DISABLED | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | sql_plan_management_mode | STRING | Disable | Specifies how spm work."Disable" represent disable spm (default value)."OnlineEvolve" represent evolve plan online. | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | Disable | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | lob_enable_block_cache_threshold | CAPACITY | 256K | For outrow-stored LOBs, if the length is less than or equal to that threshold, they can be admitted into the block cache to speed up the next query. | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 256K | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | choose_migration_source_policy | STRING | region | the policy of choose source in migration and add replica. 'idc' means firstly choose follower replica of the same idc as source, 'region' means firstly choose follower replica of the same region as source | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | region | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | json_document_max_depth | INT | 100 | maximum nesting depth allowed in a JSON document | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 100 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | max_partition_num | INT | 8192 | set max partition num in mysql mode | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 8192 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | optimizer_index_cost_adj | INT | 0 | adjust costing of index scan | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 0 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | kv_hbase_client_scanner_timeout_period | INT | 60000 | OBKV Hbase client scanner query timeout, which unit is milliseconds. Range: (0, +∞) in integer. Especially, 60000 means default value | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 60000 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | shared_log_retention | TIME | 1d | Retention time of log files on shared storage | TRANS | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 1d | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | ttl_thread_score | INT | 0 | the current work thread score of ttl thread. Range: [0,100] in integer. Especially, 0 means default value | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 0 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | enable_kv_ttl | BOOL | False | specifies whether ttl task is enbled | ROOT_SERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | False | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | kv_ttl_history_recycle_interval | TIME | 7d | the time to recycle ttl history. Range: [1d, 180d] | ROOT_SERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 7d | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | kv_ttl_duty_duration | STRING | | ttl background task working time durationbegin_time or end_time in Range, e.g., [23:00:00, 24:00:00] | ROOT_SERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | auto_split_tablet_size | CAPACITY | 128M | when create an auto-partitioned table in "create table" syntax or modify a table as an auto-partitioned table in "alter table" syntax,if the splitting threshold of tablet size is not setted,this config will be setted as the threshold of the table.Note that the modification of this config will not affect the created auto-partitioned table.Range: [128M, +∞) | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 128M | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | enable_auto_split | BOOL | False | if the auto-partition clause is not usedthis config judge whether to enable auto-partition for creating table. | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | False | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | range_optimizer_max_mem_size | CAPACITY | 128M | to limit the memory consumption for the query range optimizer. Range: [0M,+∞), 0 stands for unlimited | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 128M | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | enable_user_defined_rewrite_rules | BOOL | False | specify whether the user defined rewrite rules are enabled. Value: True: enable False: disable | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | False | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | dump_data_dictionary_to_log_interval | TIME | 24h | data dictionary dump to log(SYS LS) intervalRange: (0s,+∞) | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 24h | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | tenant_sql_net_thread_count | INT | 0 | the number of mysql I/O threads for a tenant. Range: [0, 64] in integer, 0 stands for unit_min_cpu | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 0 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | tenant_sql_login_thread_count | INT | 0 | the number of threads for sql login request of each tenant. Range: [0, 32] in integer, 0 stands for unit_min_cpu | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 0 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | arbitration_timeout | TIME | 5s | The timeout before automatically degrading when arbitration member exists. Range: [3s,+∞] | TRANS | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 5s | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | query_response_time_range_base | INT | 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 | 10 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | query_response_time_flush | BOOL | 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 | False | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | query_response_time_stats | BOOL | 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 | False | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | default_enable_extended_rowid | BOOL | False | specifies whether to create table as extended rowid mode or not | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | false | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | ob_query_switch_leader_retry_timeout | TIME | 0ms | max time spend on retry caused by leader swith or network disconnectionRange: [0ms, +∞) | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 0ms | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | default_auto_increment_mode | STRING | order | specifies default auto-increment mode, default is 'order' | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | order | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | enable_sql_extension | BOOL | False | specifies whether to allow use some oracle mode features in mysql mode | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | False | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | job_queue_processes | INT | 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 | 1000 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | ob_proxy_readonly_transaction_routing_policy | BOOL | False | Proxy route policy for readonly sql: whether regard begining read only stmts as in transaction | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | false | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | connection_control_max_connection_delay | INT | 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 | 2147483647 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | connection_control_min_connection_delay | INT | 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 | 1000 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | connection_control_failed_connections_threshold | INT | 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 | 0 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | open_cursors | INT | 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 | 50 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | ob_ssl_invited_common_names | STRING | NONE | when server use ssl, use it to control client identity with ssl subject common name. default NONE | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | NONE | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | plsql_v2_compatibility | BOOL | False | allows to control store routine compile action at DDL stage | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | False | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | plsql_debug | BOOL | False | specifies whether or not PL/SQL library units will be compiled for debugging | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | False | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | plsql_code_type | STRING | native | specifies the compilation mode for PL/SQL library units | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | native | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | tde_method | STRING | 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 | none | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | external_kms_info | STRING | | when using the external key management center, this parameter will store some key management information | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | ob_enable_batched_multi_statement | BOOL | False | enable use of batched multi statement | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | False | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | backup_data_file_size | CAPACITY | 4G | backup data file size. Range: [512M, 4G] in integer | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 4G | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | audit_log_strategy | STRING | ASYNCHRONOUS | the logging method used by the audit log plugin. ASYNCHRONOUS: Log asynchronously. Wait for space in the output buffer. PERFORMANCE: Log asynchronously. Drop requests when there is insufficient buffer. SYNCHRONOUS: Log synchronously. | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | ASYNCHRONOUS | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | audit_log_rotate_on_size | CAPACITY | 256M | [0,)whenever a write to the audit log file causes its size to exceed the config value, it will be renamed and a new audit log file using is opened, range: [0,) | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 256M | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | audit_log_query_sql | STRING | ALL | how to record the query sql. ALL: record the original query sql. DESENSITIVE: record the desensitive query sql. NONE: not to record query sql. | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | ALL | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | audit_log_prune_seconds | INT | 0 | the number of seconds after which audit log files become subject to pruning, range: [0,) | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 0 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | audit_log_max_size | CAPACITY | 0M | the maximum combined size of the audit log files | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 0M | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | audit_log_format | STRING | CSV | the audit log file format, values: CSV | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | CSV | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | audit_log_path | STRING | | the directory of the audit log | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | audit_log_compression | STRING | NONE | the type of compression for the audit log file, values: NONE, ZSTD | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | NONE | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | audit_log_buffer_size | CAPACITY | 16M | [16M,)the buffer size of async audit logRange: [16M, total size of memory] | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 16M | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | audit_log_enable | BOOL | False | whether enable audit log | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | False | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | audit_trail | STRING | None | enables or disables database auditing, support NONE;OS;DB;DB,EXTENDED;DB_EXTENDED | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | None | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | audit_sys_operations | BOOL | False | whether trace sys user operations | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | False | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | sql_work_area | CAPACITY | 1G | Work area memory limitation for tenant | OBSERVER | TENANT | DEFAULT | STATIC_EFFECTIVE | 1G | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | ob_compaction_schedule_interval | TIME | 120s | the time interval to schedule compaction, Range: [3s,5m]Range: [3s, 5m] | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 120s | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | major_compact_trigger | INT | 0 | specifies how many minor freeze should be triggered between two major freeze, Range: [0,65535] in integer | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 0 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | minor_compact_trigger | INT | 2 | minor_compact_trigger, Range: [0,16] in integer | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 2 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | ddl_thread_score | INT | 0 | the current work thread score of ddl thread. Range: [0,100] in integer. Especially, 0 means default value | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 0 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | ha_low_thread_score | INT | 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 | 0 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | ha_mid_thread_score | INT | 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 | 0 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | ha_high_thread_score | INT | 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 | 0 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | compaction_high_thread_score | INT | 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 | 0 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | compaction_mid_thread_score | INT | 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 | 0 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | compaction_low_thread_score | INT | 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 | 0 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | compaction_schedule_tablet_batch_cnt | INT | 50000 | the batch size when scheduling tablet to execute compaction task. Range: [10000,200000] in integer. default value is 50000 | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 50000 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | compaction_dag_cnt_limit | INT | 15000 | the compaction dag count limit. Range: [10000,200000] in integer. default value is 15000 | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 15000 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | rpc_memory_limit_percentage | INT | 0 | maximum memory for rpc in a tenant, as a percentage of total tenant memory, and 0 means no limit to rpc memory | RPC | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 0 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | enable_early_lock_release | BOOL | True | enable early lock release | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | True | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | merger_check_interval | TIME | 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 | 10m | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | major_freeze_duty_time | MOMENT | 02:00 | the start time of system daily merge procedure. Range: [00:00, 24:00) | DAILY_MERGE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 02:00 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | partition_balance_schedule_interval | TIME | 2h | the time interval between generate partition balance task. The value should be no less than balancer_idle_time to enable partition balance. Default value 2h and the value 0s means disable partition balance. Range: [0s, +∞) | LOAD_BALANCE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 2h | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | balancer_idle_time | TIME | 10s | the time interval between the schedules of the tenant load-balancing task. Range: [10s, +∞) | LOAD_BALANCE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 10s | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | enable_transfer | BOOL | True | controls whether transfers are allowed in the tenant. This config does not take effect when enable_rebalance is disabled. Value: True:turned on False:turned off | LOAD_BALANCE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | True | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | enable_rebalance | BOOL | True | specifies whether the tenant load-balancing is turned on. Value: True:turned on False: turned off | LOAD_BALANCE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | True | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | standby_db_preferred_upstream_log_region | STRING | | The preferred upstream log region for Standby db. The Standby db will give priority to the preferred upstream log region to fetch log. For high availability，the Standby db will also switch to the other region when the preferred upstream log region can not fetch log because of exception etc. | LOGSERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | archive_lag_target | TIME | 120s | The lag target of the log archive. The log archive target affects not only the backup availability, but also the lag of the standby database based on archive. Values larger than 7200s are not reasonable lag. The typical value is 120s. Extremely low values can result in high IOPS, which is not optimal for object storage; such values can also affect the performance of the database. The value 0ms means to archive as soon as possible. Range: [0ms,7200s] | LOGSERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 120s | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | standby_db_fetch_log_rpc_timeout | TIME | 15s | The threshold for detecting the RPC timeout for the standby tenant to fetch log from the log restore source tenant. When the rpc timeout, the log transport service switches to another server of the log restore source tenant to fetch logs. Range: [2s, +∞) | LOGSERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 15s | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | ls_gc_delay_time | TIME | 0s | The max delay time for ls gc when log archive is off. The default value is 0s. Range: [0s, +∞). The ls delay deletion mechanism will no longer take effect when the tenant is dropped. | LOGSERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 0s | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | log_disk_throttling_maximum_duration | TIME | 2h | maximum duration of log disk throttling, that is the time remaining until the log disk space is exhausted after log disk throttling triggered. | LOGSERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 2h | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | log_disk_throttling_percentage | INT | 60 | the threshold of the size of the log disk when writing_limit will be triggered. Rang:[40,100]. setting 100 means turn off writing limit | LOGSERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 60 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | log_disk_utilization_threshold | INT | 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 | 80 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | log_disk_utilization_limit_threshold | INT | 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 | 95 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | log_archive_concurrency | INT | 0 | log archive concurrency, for both archive fetcher and sender. If the value is default 0, the database will automatically calculate the number of archive worker threads based on the tenant specification, which is tenant max_cpu divided by 4; otherwise set the the worker count equals to the value.Range: [0, 100] in integer | LOGSERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 0 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | log_restore_concurrency | INT | 0 | log restore concurrency, for both the restore tenant and standby tenant. If the value is default 0, the database will automatically calculate the number of restore worker threads based on the tenant specification, which is tenant max_cpu; otherwise set the the worker count equals to the value.Range: [0, 100] in integer | LOGSERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 0 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | log_storage_compress_func | STRING | lz4_1.0 | specifies the algorithms used for log storage compression. Values: lz4_1.0, zstd_1.0, zstd_1.3.8 | LOGSERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | lz4_1.0 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | log_storage_compress_all | BOOL | False | specifies whether to compress logs before storing. The default is false(no compression) | LOGSERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | False | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | log_transport_compress_func | STRING | lz4_1.0 | compressor used for log transport. Values: none, lz4_1.0, zstd_1.0, zstd_1.3.8 | LOGSERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | lz4_1.0 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | log_transport_compress_all | BOOL | False | If this option is set to true, use compression for log transport. The default is false(no compression) | LOGSERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | False | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | compatible | VERSION | 4.3.4.0 | compatible version for persisted data | ROOT_SERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 4.3.4.0 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | workarea_size_policy | STRING | AUTO | policy used to size SQL working areas (MANUAL/AUTO) | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | AUTO | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | default_progressive_merge_num | INT | 0 | default progressive_merge_num when tenant create tableRange:[0,) | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 0 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | ob_storage_s3_url_encode_type | STRING | default | Determines the URL encoding method for S3 requests."default": Uses the S3 standard URL encoding method."compliantRfc3986Encoding": Uses URL encoding that adheres to the RFC 3986 standard. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | default | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | _enable_dbms_job_package | BOOL | False | Control whether can use DBMS_JOB package. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | True | 0 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | enable_ob_error_msg_style | BOOL | True | A switch that determines whether to use the ORA-xx or OBE-xx error code format for ORA error codes, with a default value of True to use the OBE-xx format.The default value is True. Value: False means we use the ORA-xx format, True means we use the OBE-xx format. | OBSERVER | CLUSTER | DEFAULT | STATIC_EFFECTIVE | True | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | strict_check_os_params | BOOL | False | A switch that determines whether to enable strict OS parameter check mode, defaulting to true and can be set to false to bypass strict checks.Value: True: allowed; False: allowed but not suggested | OBSERVER | CLUSTER | DEFAULT | STATIC_EFFECTIVE | False | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | enable_rpc_authentication_bypass | BOOL | True | specifies whether allow OMS service to connect cluster and provide service when rpc authentication is turned on. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | True | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | sql_protocol_min_tls_version | STRING | none | SQL SSL control options, used to specify the minimum SSL/TLS version number. values: none, TLSv1, TLSv1.1, TLSv1.2, TLSv1.3 | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | none | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | rpc_server_authentication_method | STRING | ALL | specifies rpc server authentication method. ALL: support all authentication methods. NONE: without authentication. SSL_NO_ENCRYPT: authentication by SSL handshake but not encrypt the communication channel. SSL_IO: authentication by SSL handshake and encrypt the communication channel | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | ALL | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | rpc_client_authentication_method | STRING | NONE | specifies rpc client authentication method. NONE: without authentication. SSL_NO_ENCRYPT: authentication by SSL handshake but not encrypt the communication channel. SSL_IO: authentication by SSL handshake and encrypt the communication channel | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | NONE | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | observer_id | INT | 2 | the unique id that been assigned by rootservice for each observer in cluster, default: 0 (invalid id), Range: [1, 18446744073709551615] | OBSERVER | CLUSTER | DEFAULT | READONLY | 0 | 0 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | local_ip | STRING | 192.168.3.42 | the IP address of the machine on which the ObServer will be installed | OBSERVER | CLUSTER | DEFAULT | READONLY | | 0 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | enable_dblink | BOOL | True | Enable or disable dblink | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | True | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | global_background_cpu_quota | DOUBLE | -1 | When enable_global_background_resource_isolation is True, specify the number of vCPUs allocated to the background tasks-1 for the CPU is not limited by the cgroup | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | -1 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | enable_global_background_resource_isolation | BOOL | False | When set to false, foreground and background tasks are isolated within the tenant; When set to true, isolate background tasks individually upon tenant-level | OBSERVER | CLUSTER | DEFAULT | STATIC_EFFECTIVE | False | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | enable_cgroup | BOOL | 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 | True | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | sql_net_thread_count | INT | 0 | the number of global mysql I/O threads. Range: [0, 64] in integer, default value is 0, 0 stands for old value GCONF.net_thread_count | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 0 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | sql_login_thread_count | INT | 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 | 0 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | tcp_keepcnt | INT | 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 | 10 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | tcp_keepintvl | TIME | 6s | The time (in seconds) between individual keepalive probes. Take effect for new established connections. Range: [1s, +∞] | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 6s | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | tcp_keepidle | TIME | 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 | 7200s | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | enable_tcp_keepalive | BOOL | True | enable TCP keepalive for the TCP connection of sql protocol. Take effect for new established connections. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | true | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | ob_ratelimit_stat_period | TIME | 1s | the time interval to update observer's maximum bandwidth to a certain region. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 1s | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | enable_ob_ratelimit | BOOL | False | enable ratelimit between regions for RPC connection. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | False | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | ssl_external_kms_info | STRING | | when using the external key management center for ssl, this parameter will store some key management information | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | use_large_pages | STRING | false | used to manage the database's use of large pages, values: false, true, only | OBSERVER | CLUSTER | DEFAULT | STATIC_EFFECTIVE | false | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | schema_history_recycle_interval | TIME | 10m | the time interval between the schedules of schema history recyle task. Range: [0s, +∞) | LOAD_BALANCE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 10m | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | _bloom_filter_ratio | INT | 3 | the px bloom filter false-positive rate.the default value is 1, range: [0,100] | TENANT | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 35 | 0 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | use_ipv6 | BOOL | False | Whether this server uses ipv6 address | OBSERVER | CLUSTER | DEFAULT | STATIC_EFFECTIVE | False | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | ssl_client_authentication | BOOL | False | enable server SSL support. Takes effect after ca/cert/key file is configured correctly. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | False | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | stack_size | CAPACITY | 512K | the size of routine execution stackRange: [512K, 20M] | OBSERVER | CLUSTER | DEFAULT | STATIC_EFFECTIVE | 512K | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | px_task_size | CAPACITY | 2M | to be removed | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 2M | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | dtl_buffer_size | CAPACITY | 64K | to be removed | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 64K | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | micro_block_merge_verify_level | INT | 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 | 2 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | builtin_db_data_verify_cycle | INT | 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 | 20 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | tablet_size | CAPACITY | 128M | default tablet size, has to be a multiple of 2M | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 128M | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | sys_bkgd_migration_change_member_list_timeout | TIME | 20s | the timeout for migration change member list retry. The default value is 20s. Range: [0s,24h] | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 20s | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | sys_bkgd_migration_retry_num | INT | 3 | retry num limit during migration. Range: [3, 100] in integer | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 3 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | sync_io_thread_count | INT | 0 | The number of io threads for synchronizing request on each device. The default value is 0. Range: [0,1024] in integer | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 0 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | disk_io_thread_count | INT | 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 | 8 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | sys_bkgd_net_percentage | INT | 60 | the net percentage of sys background net. Range: [0, 100] in integer | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 60 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | data_disk_usage_limit_percentage | INT | 90 | the safe use percentage of data diskRange: [50,100] in integer | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 90 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | data_storage_error_tolerance_time | 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 | 300s | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | data_storage_warning_tolerance_time | TIME | 5s | time to tolerate disk read failure, after that, the disk status will be set warning. Range [1s,300s]. The default value is 5s | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 5s | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | storage_meta_cache_priority | INT | 10 | storage meta cache priority. Range:[1, ) | CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 10 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | fuse_row_cache_priority | INT | 1 | fuse row cache priority. Range:[1, ) | CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 1 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | bf_cache_miss_count_threshold | INT | 100 | bf cache miss count threshold, 0 means disable bf cache. Range:[0, ) | CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 100 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | bf_cache_priority | INT | 1 | bf cache priority. Range:[1, ) | CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 1 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | user_row_cache_priority | INT | 1 | user row cache priority. Range:[1, ) | CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 1 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | user_block_cache_priority | INT | 1 | user block cache priority. Range:[1, ) | CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 1 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | index_block_cache_priority | INT | 10 | index cache priority. Range:[1, ) | CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 10 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | opt_tab_stat_cache_priority | INT | 1 | tab stat cache priority. Range:[1, ) | CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 1 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | tablet_ls_cache_priority | INT | 1000 | tablet ls cache priority. Range:[1, ) | CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 1000 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | location_cache_refresh_sql_timeout | TIME | 1s | The timeout used for refreshing location cache by SQL. Range: [1ms, +∞) | LOCATION_CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 1s | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | location_cache_refresh_rpc_timeout | TIME | 500ms | The timeout used for refreshing location cache by RPC. Range: [1ms, +∞) | LOCATION_CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 500ms | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | all_server_list | STRING | 192.168.3.41:2882,192.168.3.42:2882,192.168.3.43:2882 | all server addr in cluster | LOCATION_CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | 0 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | location_cache_refresh_min_interval | TIME | 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 | 100ms | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | location_fetch_concurrency | INT | 20 | the maximum number of the tasks for fetching location cache concurrently. Range: [1, 1000] | LOCATION_CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 20 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | location_refresh_thread_count | INT | 2 | the number of threads for fetching location cache in the background. Range: (1, 64] | LOCATION_CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 2 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | virtual_table_location_cache_expire_time | TIME | 8s | expiration time for virtual table location info in partition location cache. Range: [1s, +∞) | LOCATION_CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 8s | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | standby_fetch_log_bandwidth_limit | CAPACITY | 0MB | the max bandwidth in bytes per second that can be occupied by the sum of the synchronizing log from primary cluster of all servers in the standby cluster | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 0MB | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | rpc_timeout | TIME | 2s | the time during which a RPC request is permitted to execute before it is terminated | RPC | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 2s | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | ignore_replay_checksum_error | BOOL | 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 | False | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | row_compaction_update_limit | INT | 6 | maximum update count before trigger row compaction. Range: [1, 6400] | TRANS | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 6 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | clog_sync_time_warn_threshold | TIME | 100ms | the time given to the commit log synchronization between a leader and its followers before a \'warning\' message is printed in the log file. Range: [1ms,1000ms] | TRANS | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 100ms | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | trx_2pc_retry_interval | TIME | 100ms | the time interval between the retries in case of failure during a transaction\'s two-phase commit phase. Range: [1ms,5000ms] | TRANS | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 100ms | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | enable_sys_unit_standalone | BOOL | False | specifies whether sys unit standalone deployment is turned on. Value: True:turned on False: turned off | LOAD_BALANCE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | False | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | server_balance_cpu_mem_tolerance_percent | INT | 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 | 5 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | server_balance_disk_tolerance_percent | INT | 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 | 1 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | server_balance_critical_disk_waterlevel | INT | 80 | disk water level to determine server balance strategy | LOAD_BALANCE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 80 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | __min_full_resource_pool_memory | INT | 2147483648 | the min memory value which is specified for a full resource pool. | LOAD_BALANCE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 5368709120 | 0 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | balancer_log_interval | TIME | 1m | the time interval between logging the load-balancing task\'s statistics. Range: [1s, +∞) | LOAD_BALANCE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 1m | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | balancer_task_timeout | TIME | 20m | the time to execute the load-balancing task before it is terminated. Range: [1s, +∞) | LOAD_BALANCE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 20m | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | balancer_tolerance_percentage | INT | 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 | 10 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | enable_rereplication | BOOL | True | specifies whether the auto-replication is turned on. Value: True:turned on False: turned off | LOAD_BALANCE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | True | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | resource_hard_limit | INT | 100 | system utilization should not be large than resource_hard_limit | LOAD_BALANCE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 100 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | arbitration_degradation_policy | STRING | LS_POLICY | specifies the degradation policy, whether to check network connectivity with RS before arbitration degrades. Value: LS_POLICY, CLUSTER_POLICY LS_POLICY: default policy. CLUSTER_POLICY: check network connectivity with RS before arbitration degrades. Do not degrade when not connected. Then, switch log stream leaders to the replicas which are connected with RS. | LOGSERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | LS_POLICY | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | log_storage_warning_tolerance_time | TIME | 5s | time to tolerate log disk io delay, after that, the disk status will be set warning. Range: [1s,300s] | LOGSERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 5s | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | log_disk_percentage | INT | 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 | 0 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | log_disk_size | CAPACITY | 110G | the size of disk space used by the log files. Range: [0, +∞) | LOGSERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 0M | 0 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | recyclebin_object_expire_time | TIME | 0s | recyclebin object expire time, default 0 that means auto purge recyclebin off. Range: [0s, +∞) | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 0s | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | ob_event_history_recycle_interval | TIME | 7d | the time to recycle event history. Range: [1d, 180d] | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 7d | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | enable_crazy_medium_compaction | BOOL | False | enables triggering medium compaction repeatly. The default value is False. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | False | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | enable_major_freeze | BOOL | True | specifies whether major_freeze function is turned on. Value: True:turned on; False: turned off | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | True | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | enable_ddl | BOOL | True | specifies whether DDL operation is turned on. Value: True:turned on; False: turned off | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | True | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | min_observer_version | STRING | 4.3.4.0 | the min observer version | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 4.3.4.0 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | tablet_meta_table_check_interval | TIME | 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 | 30m | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | ls_meta_table_check_interval | TIME | 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 | 1s | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | tablet_meta_table_scan_batch_count | INT | 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 | 999 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | rootservice_ready_check_interval | TIME | 3s | the interval between the schedule of the rootservice restart task while restart failed Range: [100000us, 1m] | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 3s | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | server_check_interval | TIME | 30s | the time interval between schedules of a task that examines the __all_server table. Range: [1s, +∞) | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 30s | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | migration_disable_time | 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 | 3600s | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | server_permanent_offline_time | 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 | 3600s | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | enable_sys_table_ddl | BOOL | False | specifies whether a \'system\' table is allowed be to created manually. Value: True: allowed; False: not allowed | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | False | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | rootservice_async_task_queue_size | INT | 16384 | the size of the queue for all asynchronous tasks at rootserver. Range: [8, 131072] in integer | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 16384 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | rootservice_async_task_thread_count | INT | 4 | maximum of threads allowed for executing asynchronous task at rootserver. Range: [1, 10] | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 4 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | lease_time | 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 | 10s | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | plan_cache_evict_interval | TIME | 5s | time interval for periodic plan cache eviction. Range: [0s, +∞) | TENANT | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 5s | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | data_disk_write_limit_percentage | INT | 0 | used to stop user write operations. When the user data disk reaches this watermark, SQL requests will report that the disk is full. The configuration should be greater than data_disk_usage_limit_percentage, with the recommended setting being: (1 - memstore_limit_size / data_disk_size) * 100% | TENANT | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 0 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | memstore_limit_percentage | INT | 0 | used in calculating the value of MEMSTORE_LIMIT parameter: memstore_limit_percentage = memstore_limit / memory_size, where MEMORY_SIZE is determined when the tenant is created. Range: [0, 100). 1. the system will use memstore_limit_percentage if only memstore_limit_percentage is set.2. the system will use _memstore_limit_percentage if both memstore_limit_percentage and _memstore_limit_percentage is set.3. the system will adjust automatically if both memstore_limit_percentage and _memstore_limit_percentage set to 0(by default). | TENANT | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 0 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | large_query_threshold | TIME | 600s | threshold for execution time beyond which a request may be paused and rescheduled as a \'large request\', 0ms means disable \'large request\'. Range: [0ms, +∞) | TENANT | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 5s | 0 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | large_query_worker_percentage | DOUBLE | 30 | the percentage of the workers reserved to serve large query request. Range: [0, 100] in percentage | TENANT | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 30 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | workers_per_cpu_quota | INT | 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 | 10 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | location_cache_cpu_quota | DOUBLE | 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 | 5 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | server_cpu_quota_max | DOUBLE | 0 | the number of maximal vCPUs allocated to the server tenant(a special internal tenant that exists on every observer). 0 stands for adaptive. Range: [0, 16] | TENANT | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 0 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | server_cpu_quota_min | DOUBLE | 0 | the number of minimal vCPUs allocated to the server tenant(a special internal tenant that exists on every observer). 0 stands for adaptive. Range: [0, 16] | TENANT | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 0 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | enable_sql_operator_dump | BOOL | True | specifies whether sql operators (sort/hash join/material/window function/interm result/...) allowed to write to disk | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | True | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | autoinc_cache_refresh_interval | TIME | 3600s | auto-increment service cache refresh sync_value in this interval, with default 3600s. Range: [100ms, +∞) | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 3600s | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | memory_chunk_cache_size | CAPACITY | 0M | the maximum size of memory cached by memory chunk cache. Range: [0M,], 0 stands for adaptive | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 0M | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | cache_wash_threshold | CAPACITY | 4GB | size of remaining memory at which cache eviction will be triggered. Range: [0,+∞) | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 4GB | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | memory_limit_percentage | INT | 80 | the size of the memory reserved for internal use(for testing purpose). Range: [10, 95] | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 80 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | syslog_file_uncompressed_count | INT | 0 | specifies the minimum number of the syslog files that will not be compressed. Each syslog file can occupy at most 256MB disk space. When this value is set to 0, all syslog file may be compressed. Range: [0, +∞) in integer | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 0 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | syslog_compress_func | STRING | none | compress function name for syslog files, values: none, zstd_1.0, zstd_1.3.8 | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | none | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | syslog_disk_size | CAPACITY | 0M | the size of disk space used by the syslog files. Range: [0, +∞) | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 0M | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | enable_syslog_recycle | BOOL | True | specifies whether log file recycling is turned on. Value: True：turned on; False: turned off | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | False | 0 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | enable_syslog_wf | BOOL | 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 | True | 0 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | enable_async_syslog | BOOL | True | specifies whether use async log for observer.log, elec.log and rs.log | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | True | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | max_syslog_file_count | INT | 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 | 0 | 0 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | diag_syslog_per_error_limit | INT | 200 | DIAG syslog limitation for each error per second, exceeding syslog would be truncated | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 200 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | syslog_io_bandwidth_limit | CAPACITY | 30MB | Syslog IO bandwidth limitation, exceeding syslog would be truncated. Use 0 to disable ERROR log. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 30MB | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | alert_log_level | STRING | INFO | specifies the current level of alert log. There are INFO, WARN, ERROR, three different log levels. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | INFO | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | syslog_level | STRING | WDIAG | specifies the current level of logging. There are DEBUG, TRACE, WDIAG, EDIAG, INFO, WARN, ERROR, seven different log levels. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | WDIAG | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | obconfig_url | STRING | http://192.168.3.41:8080/services?Action=ObRootServiceInfo&ObCluster=ocbase_test_cluster | URL for OBConfig service | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | 0 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | cluster_id | INT | 1733496353 | ID of the cluster | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 0 | 0 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | cluster | STRING | ocbase_test_cluster | Name of the cluster | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | obcluster | 0 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | rootservice_list | STR_LIST | 192.168.3.41:2882:2881;192.168.3.42:2882:2881 | a list of servers against which election candidate is checked for validation | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | 0 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | weak_read_version_refresh_interval | TIME | 100ms | the time interval to refresh cluster weak read version Range: [50ms, +∞) | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 100ms | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | default_compress | STRING | archive | default compress strategy for create new table within oracle mode | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | archive | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | default_row_format | STRING | dynamic | default row format in mysql mode | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | dynamic | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | default_compress_func | STRING | zstd_1.3.8 | default compress function name for create new table, values: none, lz4_1.0, snappy_1.0, zstd_1.0, zstd_1.3.8 | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | zstd_1.3.8 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | schema_history_expire_time | 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 | 7d | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | enable_upgrade_mode | BOOL | 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 | False | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | enable_perf_event | BOOL | True | specifies whether to enable perf event feature. The default value is True. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | True | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | dead_socket_detection_timeout | TIME | 3s | specify a tcp_user_timeout for RFC5482. A zero value makes the option disabled, Range: [0, 2h] | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 3s | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | debug_sync_timeout | TIME | 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 | 0 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | enable_rich_error_msg | BOOL | False | specifies whether add ip:port, time and trace id to user error message. The default value is FALSE. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | false | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | enable_record_trace_id | BOOL | False | specifies whether record app trace id is turned on. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | False | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | enable_sql_audit | BOOL | 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 | true | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | max_string_print_length | INT | 500 | truncate very long string when printing to log file. Range:[0,] | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 500 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | enable_record_trace_log | BOOL | False | specifies whether to always record the trace log. The default value is True. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | True | 0 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | trace_log_slow_query_watermark | TIME | 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 | 1s | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | cpu_count | INT | 16 | 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 | 0 | 0 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | system_memory | CAPACITY | 7G | 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 | 0M | 0 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | memory_limit | CAPACITY | 41G | the size of the memory reserved for internal use(for testing purpose), 0 means follow memory_limit_percentage. Range: 0, [1G,). | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 0M | 0 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | tenant_task_queue_size | INT | 16384 | the size of the task queue for each tenant. Range: [1024,+∞) | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 16384 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | high_priority_net_thread_count | INT | 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 | 0 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | net_thread_count | INT | 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 | 0 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | internal_sql_execute_timeout | TIME | 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 | 30s | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | ob_startup_mode | STRING | NORMAL | specifies the observer startup mode | OBSERVER | CLUSTER | DEFAULT | READONLY | NORMAL | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | zone | STRING | zone42 | specifies the zone name | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | 0 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | devname | STRING | ens192 | name of network adapter | OBSERVER | CLUSTER | DEFAULT | READONLY | bond0 | 0 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | mysql_port | INT | 2881 | port number for mysql connection. Range: (1024, 65536) in integer | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 2881 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | rpc_port | INT | 2882 | the port number for RPC protocol. Range: (1024, 65536) in integer | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 2882 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | leak_mod_to_check | STRING | NONE | the name of the module under memory leak checks | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | NONE | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | config_additional_dir | STR_LIST | etc2;etc3 | additional directories of configure file | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | etc2;etc3 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | memory_reserved | CAPACITY | 500M | the size of the system memory reserved for emergency internal use. Range: [10M, total size of memory] | SSTABLE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 500M | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | datafile_disk_percentage | INT | 0 | the percentage of disk space used by the data files. Range: [0,99] in integer | SSTABLE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 0 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | datafile_maxsize | CAPACITY | 198G | the auto extend max size. Range: [0, +∞) | SSTABLE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 0 | 0 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | datafile_next | CAPACITY | 20G | the auto extend step. Range: [0, +∞) | SSTABLE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 0 | 0 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | datafile_size | CAPACITY | 110G | size of the data file. Range: [0, +∞) | SSTABLE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | 0M | 0 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | redundancy_level | STRING | NORMAL | EXTERNAL: use extrernal redundancyNORMAL: tolerate one disk failureHIGH: tolerate two disk failure if disk count is enough | SSTABLE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | NORMAL | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | data_dir | STRING | /data/ocbase_test_cluster/oceanbase/store | the directory for the data file | SSTABLE | CLUSTER | DEFAULT | READONLY | store | 0 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | ob_encoding_granularity | INT | 65536 | Maximum rows for encoding in one micro block. Range:[8192,1048576] | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 65536 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | ob_vector_memory_limit_percentage | INT | 0 | Used to control the upper limit percentage of memory resources that the vector_index module can use. Range:[0, 100) | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 0 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | kv_group_commit_rw_mode | STRING | ALL | Used to specify the read/write operation types when group commit is enable. Values: 'ALL' means enable all operations, 'READ' mean only enable read operation in group commit, 'WRITE' means only write operations in group commit. | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | ALL | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | kv_group_commit_batch_size | INT | 1 | Used to specify the batch size of each group commit batch in OBKV. Values: 1 means sinlge operaion in each batch, equally to disable group commit. When batch size is greater than 1, it means group commit is enable and used as its batch size. | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 1 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | direct_load_allow_fallback | BOOL | False | Control whether an error is reported when direct load of the derivative operation scenario is not supported. | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | False | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | default_load_mode | STRING | DISABLED | Specifies default load data path."DISABLED" represent load data not in direct load path (default value)."FULL_DIRECT_WRITE" represent load data in full direct load path with insert semantics."INC_DIRECT_WRITE" represent load data in inc direct load path with insert semantics."INC_REPLACE_DIRECT_WRITE" represent load data in inc direct load path with replace semantics. | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | DISABLED | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | sql_plan_management_mode | STRING | Disable | Specifies how spm work."Disable" represent disable spm (default value)."OnlineEvolve" represent evolve plan online. | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | Disable | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | lob_enable_block_cache_threshold | CAPACITY | 256K | For outrow-stored LOBs, if the length is less than or equal to that threshold, they can be admitted into the block cache to speed up the next query. | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 256K | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | choose_migration_source_policy | STRING | region | the policy of choose source in migration and add replica. 'idc' means firstly choose follower replica of the same idc as source, 'region' means firstly choose follower replica of the same region as source | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | region | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | json_document_max_depth | INT | 100 | maximum nesting depth allowed in a JSON document | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 100 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | max_partition_num | INT | 8192 | set max partition num in mysql mode | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 8192 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | optimizer_index_cost_adj | INT | 0 | adjust costing of index scan | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 0 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | kv_hbase_client_scanner_timeout_period | INT | 60000 | OBKV Hbase client scanner query timeout, which unit is milliseconds. Range: (0, +∞) in integer. Especially, 60000 means default value | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 60000 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | shared_log_retention | TIME | 1d | Retention time of log files on shared storage | TRANS | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 1d | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | ttl_thread_score | INT | 0 | the current work thread score of ttl thread. Range: [0,100] in integer. Especially, 0 means default value | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 0 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | enable_kv_ttl | BOOL | False | specifies whether ttl task is enbled | ROOT_SERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | False | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | kv_ttl_history_recycle_interval | TIME | 7d | the time to recycle ttl history. Range: [1d, 180d] | ROOT_SERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 7d | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | kv_ttl_duty_duration | STRING | | ttl background task working time durationbegin_time or end_time in Range, e.g., [23:00:00, 24:00:00] | ROOT_SERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | auto_split_tablet_size | CAPACITY | 128M | when create an auto-partitioned table in "create table" syntax or modify a table as an auto-partitioned table in "alter table" syntax,if the splitting threshold of tablet size is not setted,this config will be setted as the threshold of the table.Note that the modification of this config will not affect the created auto-partitioned table.Range: [128M, +∞) | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 128M | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | enable_auto_split | BOOL | False | if the auto-partition clause is not usedthis config judge whether to enable auto-partition for creating table. | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | False | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | range_optimizer_max_mem_size | CAPACITY | 128M | to limit the memory consumption for the query range optimizer. Range: [0M,+∞), 0 stands for unlimited | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 128M | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | enable_user_defined_rewrite_rules | BOOL | False | specify whether the user defined rewrite rules are enabled. Value: True: enable False: disable | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | False | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | dump_data_dictionary_to_log_interval | TIME | 24h | data dictionary dump to log(SYS LS) intervalRange: (0s,+∞) | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 24h | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | tenant_sql_net_thread_count | INT | 0 | the number of mysql I/O threads for a tenant. Range: [0, 64] in integer, 0 stands for unit_min_cpu | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 0 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | tenant_sql_login_thread_count | INT | 0 | the number of threads for sql login request of each tenant. Range: [0, 32] in integer, 0 stands for unit_min_cpu | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 0 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | arbitration_timeout | TIME | 5s | The timeout before automatically degrading when arbitration member exists. Range: [3s,+∞] | TRANS | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 5s | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | query_response_time_range_base | INT | 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 | 10 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | query_response_time_flush | BOOL | 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 | False | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | query_response_time_stats | BOOL | 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 | False | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | default_enable_extended_rowid | BOOL | False | specifies whether to create table as extended rowid mode or not | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | false | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | ob_query_switch_leader_retry_timeout | TIME | 0ms | max time spend on retry caused by leader swith or network disconnectionRange: [0ms, +∞) | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 0ms | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | default_auto_increment_mode | STRING | order | specifies default auto-increment mode, default is 'order' | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | order | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | enable_sql_extension | BOOL | False | specifies whether to allow use some oracle mode features in mysql mode | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | False | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | job_queue_processes | INT | 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 | 1000 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | ob_proxy_readonly_transaction_routing_policy | BOOL | False | Proxy route policy for readonly sql: whether regard begining read only stmts as in transaction | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | false | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | connection_control_max_connection_delay | INT | 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 | 2147483647 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | connection_control_min_connection_delay | INT | 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 | 1000 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | connection_control_failed_connections_threshold | INT | 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 | 0 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | open_cursors | INT | 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 | 50 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | ob_ssl_invited_common_names | STRING | NONE | when server use ssl, use it to control client identity with ssl subject common name. default NONE | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | NONE | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | plsql_v2_compatibility | BOOL | False | allows to control store routine compile action at DDL stage | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | False | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | plsql_debug | BOOL | False | specifies whether or not PL/SQL library units will be compiled for debugging | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | False | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | plsql_code_type | STRING | native | specifies the compilation mode for PL/SQL library units | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | native | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | tde_method | STRING | 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 | none | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | external_kms_info | STRING | | when using the external key management center, this parameter will store some key management information | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | ob_enable_batched_multi_statement | BOOL | False | enable use of batched multi statement | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | False | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | backup_data_file_size | CAPACITY | 4G | backup data file size. Range: [512M, 4G] in integer | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 4G | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | audit_log_strategy | STRING | ASYNCHRONOUS | the logging method used by the audit log plugin. ASYNCHRONOUS: Log asynchronously. Wait for space in the output buffer. PERFORMANCE: Log asynchronously. Drop requests when there is insufficient buffer. SYNCHRONOUS: Log synchronously. | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | ASYNCHRONOUS | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | audit_log_rotate_on_size | CAPACITY | 256M | [0,)whenever a write to the audit log file causes its size to exceed the config value, it will be renamed and a new audit log file using is opened, range: [0,) | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 256M | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | audit_log_query_sql | STRING | ALL | how to record the query sql. ALL: record the original query sql. DESENSITIVE: record the desensitive query sql. NONE: not to record query sql. | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | ALL | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | audit_log_prune_seconds | INT | 0 | the number of seconds after which audit log files become subject to pruning, range: [0,) | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 0 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | audit_log_max_size | CAPACITY | 0M | the maximum combined size of the audit log files | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 0M | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | audit_log_format | STRING | CSV | the audit log file format, values: CSV | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | CSV | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | audit_log_path | STRING | | the directory of the audit log | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | audit_log_compression | STRING | NONE | the type of compression for the audit log file, values: NONE, ZSTD | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | NONE | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | audit_log_buffer_size | CAPACITY | 16M | [16M,)the buffer size of async audit logRange: [16M, total size of memory] | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 16M | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | audit_log_enable | BOOL | False | whether enable audit log | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | False | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | audit_trail | STRING | None | enables or disables database auditing, support NONE;OS;DB;DB,EXTENDED;DB_EXTENDED | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | None | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | audit_sys_operations | BOOL | False | whether trace sys user operations | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | False | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | sql_work_area | CAPACITY | 1G | Work area memory limitation for tenant | OBSERVER | TENANT | DEFAULT | STATIC_EFFECTIVE | 1G | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | ob_compaction_schedule_interval | TIME | 120s | the time interval to schedule compaction, Range: [3s,5m]Range: [3s, 5m] | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 120s | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | major_compact_trigger | INT | 0 | specifies how many minor freeze should be triggered between two major freeze, Range: [0,65535] in integer | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 0 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | minor_compact_trigger | INT | 2 | minor_compact_trigger, Range: [0,16] in integer | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 2 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | ddl_thread_score | INT | 0 | the current work thread score of ddl thread. Range: [0,100] in integer. Especially, 0 means default value | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 0 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | ha_low_thread_score | INT | 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 | 0 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | ha_mid_thread_score | INT | 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 | 0 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | ha_high_thread_score | INT | 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 | 0 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | compaction_high_thread_score | INT | 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 | 0 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | compaction_mid_thread_score | INT | 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 | 0 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | compaction_low_thread_score | INT | 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 | 0 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | compaction_schedule_tablet_batch_cnt | INT | 50000 | the batch size when scheduling tablet to execute compaction task. Range: [10000,200000] in integer. default value is 50000 | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 50000 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | compaction_dag_cnt_limit | INT | 15000 | the compaction dag count limit. Range: [10000,200000] in integer. default value is 15000 | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 15000 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | rpc_memory_limit_percentage | INT | 0 | maximum memory for rpc in a tenant, as a percentage of total tenant memory, and 0 means no limit to rpc memory | RPC | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 0 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | enable_early_lock_release | BOOL | True | enable early lock release | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | True | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | merger_check_interval | TIME | 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 | 10m | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | major_freeze_duty_time | MOMENT | 02:00 | the start time of system daily merge procedure. Range: [00:00, 24:00) | DAILY_MERGE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 02:00 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | partition_balance_schedule_interval | TIME | 2h | the time interval between generate partition balance task. The value should be no less than balancer_idle_time to enable partition balance. Default value 2h and the value 0s means disable partition balance. Range: [0s, +∞) | LOAD_BALANCE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 2h | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | balancer_idle_time | TIME | 10s | the time interval between the schedules of the tenant load-balancing task. Range: [10s, +∞) | LOAD_BALANCE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 10s | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | enable_transfer | BOOL | True | controls whether transfers are allowed in the tenant. This config does not take effect when enable_rebalance is disabled. Value: True:turned on False:turned off | LOAD_BALANCE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | True | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | enable_rebalance | BOOL | True | specifies whether the tenant load-balancing is turned on. Value: True:turned on False: turned off | LOAD_BALANCE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | True | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | standby_db_preferred_upstream_log_region | STRING | | The preferred upstream log region for Standby db. The Standby db will give priority to the preferred upstream log region to fetch log. For high availability，the Standby db will also switch to the other region when the preferred upstream log region can not fetch log because of exception etc. | LOGSERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | archive_lag_target | TIME | 120s | The lag target of the log archive. The log archive target affects not only the backup availability, but also the lag of the standby database based on archive. Values larger than 7200s are not reasonable lag. The typical value is 120s. Extremely low values can result in high IOPS, which is not optimal for object storage; such values can also affect the performance of the database. The value 0ms means to archive as soon as possible. Range: [0ms,7200s] | LOGSERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 120s | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | standby_db_fetch_log_rpc_timeout | TIME | 15s | The threshold for detecting the RPC timeout for the standby tenant to fetch log from the log restore source tenant. When the rpc timeout, the log transport service switches to another server of the log restore source tenant to fetch logs. Range: [2s, +∞) | LOGSERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 15s | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | ls_gc_delay_time | TIME | 0s | The max delay time for ls gc when log archive is off. The default value is 0s. Range: [0s, +∞). The ls delay deletion mechanism will no longer take effect when the tenant is dropped. | LOGSERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 0s | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | log_disk_throttling_maximum_duration | TIME | 2h | maximum duration of log disk throttling, that is the time remaining until the log disk space is exhausted after log disk throttling triggered. | LOGSERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 2h | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | log_disk_throttling_percentage | INT | 60 | the threshold of the size of the log disk when writing_limit will be triggered. Rang:[40,100]. setting 100 means turn off writing limit | LOGSERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 60 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | log_disk_utilization_threshold | INT | 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 | 80 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | log_disk_utilization_limit_threshold | INT | 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 | 95 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | log_archive_concurrency | INT | 0 | log archive concurrency, for both archive fetcher and sender. If the value is default 0, the database will automatically calculate the number of archive worker threads based on the tenant specification, which is tenant max_cpu divided by 4; otherwise set the the worker count equals to the value.Range: [0, 100] in integer | LOGSERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 0 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | log_restore_concurrency | INT | 0 | log restore concurrency, for both the restore tenant and standby tenant. If the value is default 0, the database will automatically calculate the number of restore worker threads based on the tenant specification, which is tenant max_cpu; otherwise set the the worker count equals to the value.Range: [0, 100] in integer | LOGSERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 0 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | log_storage_compress_func | STRING | lz4_1.0 | specifies the algorithms used for log storage compression. Values: lz4_1.0, zstd_1.0, zstd_1.3.8 | LOGSERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | lz4_1.0 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | log_storage_compress_all | BOOL | False | specifies whether to compress logs before storing. The default is false(no compression) | LOGSERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | False | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | log_transport_compress_func | STRING | lz4_1.0 | compressor used for log transport. Values: none, lz4_1.0, zstd_1.0, zstd_1.3.8 | LOGSERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | lz4_1.0 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | log_transport_compress_all | BOOL | False | If this option is set to true, use compression for log transport. The default is false(no compression) | LOGSERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | False | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | compatible | VERSION | 4.3.4.0 | compatible version for persisted data | ROOT_SERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 4.3.4.0 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | workarea_size_policy | STRING | AUTO | policy used to size SQL working areas (MANUAL/AUTO) | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | AUTO | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | default_progressive_merge_num | INT | 0 | default progressive_merge_num when tenant create tableRange:[0,) | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 0 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | writing_throttling_maximum_duration | TIME | 2h | maximum duration of writting throttling(in minutes), max value is 3 days | TRANS | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 2h | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | writing_throttling_trigger_percentage | INT | 60 | the threshold of the size of the mem store when writing_limit will be triggered. Rang:(0,100]. setting 100 means turn off writing limit | TRANS | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 60 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | freeze_trigger_percentage | INT | 20 | the threshold of the size of the mem store when freeze will be triggered. Rang:(0,100) | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 20 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | undo_retention | INT | 1800 | the low threshold value of undo retention. The system retains undo for at least the time specified in this config when active txn protection is banned. Range: [0, 4294967295] | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 1800 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | px_workers_per_cpu_quota | INT | 10 | the ratio(integer) between the number of system allocated px workers vs the maximum number of threads that can be scheduled concurrently. Range: [0, 20] | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 10 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | cpu_quota_concurrency | DOUBLE | 10 | max allowed concurrency for 1 CPU quota. Range: [1,20] | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 4 | 0 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | enable_monotonic_weak_read | BOOL | False | specifies observer supportting atomicity and monotonic order read | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | false | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | max_stale_time_for_weak_consistency | TIME | 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 | 5s | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | spill_compression_codec | STRING | NONE | specific the compression algorithm type to compress the spilled data in temp block store during the sql execution phase. The supported compression codecs are: ZSTD, LZ4, SNAPPY, ZLIB. NONE means no compression.The default value is NONE. | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | NONE | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | kv_transport_compress_threshold | CAPACITY | 10K | Together with the configuration item kv_transport_compress_func, it is used to specify the minimum threshold size of the OBKV query result set that needs to be compressed. Range: [0, +∞) | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 10K | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | kv_transport_compress_func | STRING | none | compressor used for tableAPI query result. Values: none, lz4_1.0, snappy_1.0, zlib_1.0, zstd_1.0 zstd 1.3.8 | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | none | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | storage_rowsets_size | INT | 8192 | the row number processed by vectorized storage engine within one batch in column storage. Range: (0,1048576] | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 8192 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone41 | observer | 192.168.3.41 | 2882 | default_table_store_format | STRING | row | Specify the default storage format of creating table: row, column, compound format of row and columnvalues: row, column, compound | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | row | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | writing_throttling_maximum_duration | TIME | 2h | maximum duration of writting throttling(in minutes), max value is 3 days | TRANS | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 2h | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | writing_throttling_trigger_percentage | INT | 60 | the threshold of the size of the mem store when writing_limit will be triggered. Rang:(0,100]. setting 100 means turn off writing limit | TRANS | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 60 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | freeze_trigger_percentage | INT | 20 | the threshold of the size of the mem store when freeze will be triggered. Rang:(0,100) | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 20 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | undo_retention | INT | 1800 | the low threshold value of undo retention. The system retains undo for at least the time specified in this config when active txn protection is banned. Range: [0, 4294967295] | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 1800 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | px_workers_per_cpu_quota | INT | 10 | the ratio(integer) between the number of system allocated px workers vs the maximum number of threads that can be scheduled concurrently. Range: [0, 20] | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 10 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | cpu_quota_concurrency | DOUBLE | 10 | max allowed concurrency for 1 CPU quota. Range: [1,20] | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 4 | 0 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | enable_monotonic_weak_read | BOOL | False | specifies observer supportting atomicity and monotonic order read | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | false | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | max_stale_time_for_weak_consistency | TIME | 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 | 5s | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | spill_compression_codec | STRING | NONE | specific the compression algorithm type to compress the spilled data in temp block store during the sql execution phase. The supported compression codecs are: ZSTD, LZ4, SNAPPY, ZLIB. NONE means no compression.The default value is NONE. | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | NONE | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | kv_transport_compress_threshold | CAPACITY | 10K | Together with the configuration item kv_transport_compress_func, it is used to specify the minimum threshold size of the OBKV query result set that needs to be compressed. Range: [0, +∞) | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 10K | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | kv_transport_compress_func | STRING | none | compressor used for tableAPI query result. Values: none, lz4_1.0, snappy_1.0, zlib_1.0, zstd_1.0 zstd 1.3.8 | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | none | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | storage_rowsets_size | INT | 8192 | the row number processed by vectorized storage engine within one batch in column storage. Range: (0,1048576] | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | 8192 | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ | zone42 | observer | 192.168.3.42 | 2882 | default_table_store_format | STRING | row | Specify the default storage format of creating table: row, column, compound format of row and columnvalues: row, column, compound | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | row | 1 | +--------+------------+--------------+------------+-------------------------------------------------+-------------+------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+----------+-------------------+-----------------+-------------+ obclient > show variables +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | Variable_name | Value | +====================================================+==================================================================================================================+ | activate_all_roles_on_login | OFF | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | autocommit | ON | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | automatic_sp_privileges | 1 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | auto_generate_certs | ON | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | auto_increment_cache_size | 1000000 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | auto_increment_increment | 1 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | auto_increment_offset | 1 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | avoid_temporal_upgrade | OFF | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | big_tables | OFF | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | binlog_cache_size | 32768 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | binlog_checksum | CRC32 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | binlog_direct_non_transactional_updates | 0 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | binlog_error_action | ABORT_SERVER | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | binlog_format | ROW | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | binlog_group_commit_sync_delay | 0 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | binlog_group_commit_sync_no_delay_count | 0 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | binlog_max_flush_queue_time | 0 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | binlog_order_commits | 1 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | binlog_rows_query_log_events | OFF | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | binlog_row_image | FULL | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | binlog_stmt_cache_size | 32768 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | binlog_transaction_dependency_history_size | 25000 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | binlog_transaction_dependency_tracking | COMMIT_ORDER | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | block_encryption_mode | aes-128-ecb | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | cardinality_estimation_model | PARTIAL | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | character_sets_dir | | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | character_set_client | utf8mb4 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | character_set_connection | utf8mb4 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | character_set_database | utf8mb4 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | character_set_filesystem | binary | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | character_set_results | utf8mb4 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | character_set_server | utf8mb4 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | character_set_system | utf8mb4 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | check_proxy_users | OFF | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | collation_connection | utf8mb4_general_ci | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | collation_database | utf8mb4_general_ci | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | collation_server | utf8mb4_general_ci | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | completion_type | NO_CHAIN | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | concurrent_insert | AUTO | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | connection_control_failed_connections_threshold | 0 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | connection_control_max_connection_delay | 2147483647 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | connection_control_min_connection_delay | 1000 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | connect_timeout | 10 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | cte_max_recursion_depth | 1000 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | cursor_sharing | FORCE | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | datadir | /data/ocbase_test_cluster/oceanbase/store | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | datetime_format | %Y-%m-%d %H:%i:%s | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | date_format | %Y-%m-%d | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | debug | d:t:i:o,/tmp/mysqld.trace | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | default_authentication_plugin | mysql_native_password | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | default_collation_for_utf8mb4 | utf8mb4_general_ci | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | default_password_lifetime | 0 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | default_storage_engine | OceanBase | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | default_tmp_storage_engine | InnoDB | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | default_week_format | 0 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | delayed_insert_limit | 100 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | delayed_insert_timeout | 300 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | delayed_queue_size | 1000 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | delay_key_write | ON | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | disabled_storage_engines | | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | disconnect_on_expired_password | ON | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | div_precision_increment | 4 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | enable_sql_plan_monitor | OFF | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | enforce_gtid_consistency | OFF | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | eq_range_index_dive_limit | 200 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | error_count | 0 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | error_on_overlap_time | OFF | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | expire_logs_days | 0 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | explicit_defaults_for_timestamp | ON | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | external_user | | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | flush | OFF | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | flush_time | 0 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | foreign_key_checks | ON | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | ft_stopword_file | built-in | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | general_log | OFF | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | group_concat_max_len | 1024 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | group_replication_allow_local_disjoint_gtids_join | OFF | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | group_replication_allow_local_lower_version_join | OFF | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | group_replication_auto_increment_increment | 7 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | group_replication_bootstrap_group | OFF | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | group_replication_components_stop_timeout | 31536000 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | group_replication_compression_threshold | 1000000 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | group_replication_enforce_update_everywhere_checks | OFF | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | group_replication_exit_state_action | READ_ONLY | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | group_replication_flow_control_applier_threshold | 25000 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | group_replication_flow_control_certifier_threshold | 25000 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | group_replication_flow_control_mode | QUOTA | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | group_replication_force_members | | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | group_replication_group_name | | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | group_replication_group_seeds | | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | group_replication_gtid_assignment_block_size | | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | group_replication_ip_whitelist | AUTOMATIC | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | group_replication_local_address | | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | group_replication_member_weight | 50 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | group_replication_poll_spin_loops | 0 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | group_replication_recovery_complete_at | TRANSACTIONS_APPLIED | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | group_replication_recovery_reconnect_interval | 60 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | group_replication_recovery_retry_count | 10 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | group_replication_recovery_ssl_ca | | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | group_replication_recovery_ssl_capath | | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | group_replication_recovery_ssl_cert | | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | group_replication_recovery_ssl_cipher | | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | group_replication_recovery_ssl_crl | | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | group_replication_recovery_ssl_crlpath | | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | group_replication_recovery_ssl_key | | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | group_replication_recovery_ssl_verify_server_cert | OFF | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | group_replication_recovery_use_ssl | OFF | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | group_replication_single_primary_mode | OFF | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | group_replication_ssl_mode | DISABLED | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | group_replication_start_on_boot | OFF | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | group_replication_transaction_size_limit | 0 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | group_replication_unreachable_majority_timeout | 0 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | gtid_executed | | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | gtid_executed_compression_period | 1000 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | gtid_mode | OFF | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | gtid_next | AUTOMATIC | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | gtid_owned | | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | gtid_purged | | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | have_crypt | YES | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | have_dynamic_loading | YES | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | have_openssl | YES | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | have_profiling | NO | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | have_query_cache | NO | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | have_ssl | YES | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | have_symlink | YES | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | hostname | | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | identity | 0 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | ignore_builtin_innodb | NO | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | information_schema_stats_expiry | 86400 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | init_connect | | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_adaptive_flushing | ON | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_adaptive_flushing_lwm | 10 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_adaptive_hash_index | ON | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_adaptive_hash_index_parts | 8 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_adaptive_max_sleep_delay | 150000 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_api_bk_commit_interval | 5 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_api_disable_rowlock | OFF | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_api_trx_level | 0 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_autoextend_increment | 64 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_autoinc_lock_mode | 1 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_background_drop_list_empty | OFF | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_buffer_pool_chunk_size | 134217728 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_buffer_pool_dump_at_shutdown | ON | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_buffer_pool_dump_now | OFF | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_buffer_pool_dump_pct | 25 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_buffer_pool_filename | ib_buffer_pool | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_buffer_pool_instances | 8 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_buffer_pool_load_abort | OFF | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_buffer_pool_load_at_startup | ON | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_buffer_pool_load_now | OFF | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_buffer_pool_size | 134217728 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_change_buffering | all | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_change_buffering_debug | 0 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_change_buffer_max_size | 25 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_checksums | ON | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_checksum_algorithm | crc32 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_cmp_per_index_enabled | OFF | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_commit_concurrency | 0 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_compression_failure_threshold_pct | 5 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_compression_level | 6 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_compression_pad_pct_max | 50 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_compress_debug | NONE | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_concurrency_tickets | 5000 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_data_file_path | ibdata1:12M:autoextend | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_data_home_dir | | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_deadlock_detect | 1 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_default_row_format | DYNAMIC | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_disable_resize_buffer_pool_debug | ON | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_disable_sort_file_cache | OFF | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_doublewrite | ON | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_file_format | Barracuda | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_file_format_check | ON | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_file_format_max | Barracuda | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_file_per_table | ON | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_fill_factor | 100 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_fil_make_page_dirty_debug | 0 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_flushing_avg_loops | 30 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_flush_log_at_timeout | 1 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_flush_log_at_trx_commit | 1 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_flush_method | null | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_flush_neighbors | 1 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_flush_sync | ON | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_force_load_corrupted | OFF | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_force_recovery | 0 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_ft_cache_size | 8000000 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_ft_enable_diag_print | OFF | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_ft_num_word_optimize | 2000 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_ft_result_cache_limit | 2000000000 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_ft_server_stopword_table | | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_ft_sort_pll_degree | 2 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_ft_total_cache_size | 640000000 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_large_prefix | ON | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_limit_optimistic_insert_debug | 0 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_lock_wait_timeout | 50 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_log_checkpoint_now | OFF | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_log_checksums | 1 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_log_compressed_pages | 1 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_log_write_ahead_size | 8192 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_lru_scan_depth | 1024 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_max_dirty_pages_pct | 75 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_max_dirty_pages_pct_lwm | 0 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_max_purge_lag | 0 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_max_purge_lag_delay | 0 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_max_undo_log_size | 1073741824 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_merge_threshold_set_all_debug | 50 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_online_alter_log_max_size | 134217728 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_optimize_fulltext_only | OFF | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_page_size | 16384 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_print_all_deadlocks | 0 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_read_only | OFF | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_replication_delay | 0 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_rollback_on_timeout | OFF | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_saved_page_number_debug | 0 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_sort_buffer_size | 1048576 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_stats_auto_recalc | ON | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_stats_include_delete_marked | OFF | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_stats_method | nulls_equal | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_stats_on_metadata | OFF | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_stats_persistent | ON | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_stats_persistent_sample_pages | 20 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_stats_sample_pages | 8 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_stats_transient_sample_pages | 8 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_strict_mode | ON | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_support_xa | ON | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_sync_debug | OFF | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_table_locks | 1 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_temp_data_file_path | ibtmp1:12M:autoextend | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_tmpdir | | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_trx_purge_view_update_only_debug | OFF | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_trx_rseg_n_slots_debug | 0 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_undo_logs | 128 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_undo_log_truncate | 0 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | innodb_version | 5.7.38 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | insert_id | 0 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | interactive_timeout | 28800 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | is_result_accurate | ON | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | join_buffer_size | 262144 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | keyring_aws_cmk_id | | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | keyring_aws_conf_file | | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | keyring_aws_data_file | | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | keyring_aws_region | us-east-1 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | keyring_encrypted_file_data | | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | keyring_encrypted_file_password | | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | keyring_file_data | | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | keyring_okv_conf_dir | | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | keyring_operations | ON | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | key_buffer_size | 8388608 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | key_cache_age_threshold | 300 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | key_cache_block_size | 1024 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | key_cache_division_limit | 100 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | language | | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | last_insert_id | 0 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | lc_messages | en_US | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | lc_messages_dir | | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | lc_time_names | en_US | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | license | | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | local_infile | ON | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | lock_wait_timeout | 31536000 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | log_bin | ON | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | log_bin_trust_function_creators | 0 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | log_bin_use_v1_row_events | 0 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | log_builtin_as_identified_by_password | 0 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | log_row_value_options | | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | long_query_time | 10 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | lower_case_file_system | OFF | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | lower_case_table_names | 2 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | master_info_repository | FILE | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | master_verify_checksum | OFF | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | max_allowed_packet | 16777216 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | max_binlog_cache_size | 18446744073709500416 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | max_binlog_size | 1073741824 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | max_binlog_stmt_cache_size | 18446744073709500416 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | max_connections | 2147483647 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | max_connect_errors | 100 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | max_digest_length | 1024 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | max_execution_time | 0 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | max_join_size | 18446744073709547520 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | max_length_for_sort_data | 1024 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | max_prepared_stmt_count | 16382 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | max_relay_log_size | 0 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | max_seeks_for_key | 18446744073709551615 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | max_sort_length | 1024 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | max_sp_recursion_depth | 0 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | max_tmp_tables | 32 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | max_user_connections | 0 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | max_write_lock_count | 18446744073709500416 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | mecab_rc_file | | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | metadata_locks_cache_size | 1024 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | metadata_locks_hash_instances | 8 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | min_examined_row_limit | 0 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | multi_range_count | 256 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | myisam_mmap_size | 18446744073709551615 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | mysqlx_connect_timeout | 30 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | mysqlx_idle_worker_thread_timeout | 60 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | mysqlx_max_allowed_packet | 67108864 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | mysqlx_max_connections | 100 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | mysqlx_min_worker_threads | 2 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | mysql_firewall_mode | OFF | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | mysql_firewall_trace | OFF | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | mysql_native_password_proxy_users | OFF | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | ndbinfo_database | ndbinfo | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | ndbinfo_table_prefix | ndb$ | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | ndbinfo_version | | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | ndb_batch_size | 32768 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | ndb_cluster_connection_pool | 1 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | ndb_cluster_connection_pool_nodeids | | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | ndb_log_apply_status | OFF | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | ndb_log_bin | ON | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | ndb_log_fail_terminate | OFF | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | ndb_log_orig | OFF | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | ndb_log_transaction_id | OFF | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | ndb_optimized_node_selection | 3 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | Ndb_system_name | | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | ndb_use_copying_alter_table | OFF | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | ndb_version | | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | ndb_version_string | | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | ndb_wait_connected | 30 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | ndb_wait_setup | 30 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | net_buffer_length | 16384 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | net_read_timeout | 30 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | net_retry_count | 10 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | net_write_timeout | 60 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | new | OFF | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | ob_bnl_join_cache_size | 10485760 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | ob_check_sys_variable | ON | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | ob_compatibility_control | MYSQL5.7 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | ob_compatibility_mode | MYSQL | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | ob_compatibility_version | 4.3.4.0 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | ob_default_lob_inrow_threshold | 8192 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | ob_early_lock_release | OFF | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | ob_enable_aggregation_pushdown | ON | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | ob_enable_index_direct_select | OFF | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | ob_enable_jit | OFF | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | ob_enable_parameter_anonymous_block | ON | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | ob_enable_plan_cache | ON | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | ob_enable_pl_cache | ON | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | ob_enable_rich_error_msg | OFF | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | ob_enable_show_trace | OFF | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | ob_enable_sql_audit | ON | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | ob_enable_transformation | ON | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | ob_enable_transmission_checksum | ON | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | ob_enable_truncate_flashback | OFF | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | ob_hnsw_ef_search | 64 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | ob_interm_result_mem_limit | 2147483648 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | ob_kv_mode | ALL | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | ob_last_schema_version | 0 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | ob_log_level | disabled | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | ob_max_read_stale_time | -1 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | ob_org_cluster_id | 0 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | ob_plan_cache_evict_high_percentage | 90 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | ob_plan_cache_evict_low_percentage | 50 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | ob_plan_cache_percentage | 5 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | ob_pl_block_timeout | 3216672000000000 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | ob_query_timeout | 10000000000 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | ob_read_consistency | STRONG | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | ob_reserved_meta_memory_percentage | 10 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | ob_route_policy | READONLY_ZONE_FIRST | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | ob_security_version | 4.3.4.0 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | ob_sql_audit_percentage | 3 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | ob_sql_work_area_percentage | 5 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | ob_table_access_policy | AUTO | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | ob_tcp_invited_nodes | % | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | ob_temp_tablespace_size_percentage | 0 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | ob_trace_info | | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | ob_trx_idle_timeout | 86400000000 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | ob_trx_lock_timeout | -1 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | ob_trx_timeout | 10000000000 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | old_alter_table | OFF | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | old_passwords | 0 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | optimizer_capture_sql_plan_baselines | OFF | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | optimizer_dynamic_sampling | 1 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | optimizer_features_enable | 4.3.4.0 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | optimizer_prune_level | 1 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | optimizer_search_depth | 62 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | optimizer_switch | | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | optimizer_trace | | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | optimizer_trace_features | | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | optimizer_trace_limit | 1 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | optimizer_trace_max_mem_size | 16384 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | optimizer_trace_offset | -1 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | optimizer_use_sql_plan_baselines | OFF | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | parallel_degree_limit | 0 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | parallel_degree_policy | MANUAL | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | parallel_min_scan_time_threshold | 1000 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | parallel_servers_target | 30 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | parser_max_mem_size | 18446744073709551615 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | partition_index_dive_limit | 10 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | performance_schema | OFF | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | performance_schema_show_processlist | OFF | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | plsql_optimize_level | 2 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | plugin_dir | ./plugin_dir/ | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | plugin_load | | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | plugin_load_add | | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | privilege_features_enable | 4.3.4.0 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | profiling | OFF | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | profiling_history_size | 15 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | protocol_version | 10 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | proxy_user | | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | pseudo_slave_mode | OFF | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | pseudo_thread_id | 2147483647 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | query_alloc_block_size | 8192 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | query_cache_limit | 0 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | query_cache_min_res_unit | 0 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | query_cache_size | 0 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | query_cache_type | OFF | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | query_cache_wlock_invalidate | OFF | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | query_prealloc_size | 8192 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | query_rewrite_enabled | FALSE | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | query_rewrite_integrity | ENFORCED | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | rand_seed1 | 0 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | rand_seed2 | 0 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | range_alloc_block_size | 4096 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | range_index_dive_limit | 10 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | range_optimizer_max_mem_size | 8388608 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | rbr_exec_mode | STRICT | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | read_only | OFF | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | recyclebin | OFF | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | regexp_stack_limit | 8000000 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | regexp_time_limit | 32 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | relay_log_info_repository | FILE | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | relay_log_purge | 1 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | replication_optimize_for_static_plugin_config | OFF | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | replication_sender_observe_commit_only | OFF | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | resource_manager_plan | | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | rewriter_enabled | ON | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | rewriter_verbose | 0 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | rpl_semi_sync_master_enabled | OFF | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | rpl_semi_sync_master_timeout | 10000 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | rpl_semi_sync_master_trace_level | 32 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | rpl_semi_sync_master_wait_for_slave_count | 1 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | rpl_semi_sync_master_wait_no_slave | OFF | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | rpl_semi_sync_master_wait_point | AFTER_SYNC | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | rpl_semi_sync_slave_enabled | OFF | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | rpl_semi_sync_slave_trace_level | 32 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | rpl_stop_slave_timeout | 31536000 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | runtime_bloom_filter_max_size | 2147483648 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | runtime_filter_max_in_num | 1024 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | runtime_filter_type | BLOOM_FILTER,RANGE,IN | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | runtime_filter_wait_time_ms | 10 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | secure_auth | ON | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | secure_file_priv | | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | server_id | 1 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | server_uuid | 7ae4d230-b3e1-11ef-9746-0050568f5f32 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | session_track_gtids | OFF | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | session_track_schema | ON | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | session_track_state_change | OFF | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | session_track_system_variables | time_zone, autocommit, character_set_client, character_set_results, character_set_connection | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | session_track_transaction_info | OFF | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | sha256_password_auto_generate_rsa_keys | ON | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | sha256_password_private_key_path | private_key.pem | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | sha256_password_proxy_users | OFF | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | sha256_password_public_key_path | public_key.pem | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | show_compatibility_56 | OFF | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | show_create_table_verbosity | OFF | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | show_old_temporals | OFF | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | skip_external_locking | ON | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | skip_show_database | 0 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | skip_slave_start | OFF | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | slave_allow_batching | OFF | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | slave_checkpoint_group | 512 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | slave_checkpoint_period | 300 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | slave_compressed_protocol | OFF | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | slave_exec_mode | STRICT | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | slave_load_tmpdir | | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | slave_max_allowed_packet | 1073741824 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | slave_net_timeout | 60 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | slave_parallel_type | DATABASE | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | slave_parallel_workers | 0 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | slave_pending_jobs_size_max | 16777216 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | slave_preserve_commit_order | OFF | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | slave_rows_search_algorithms | TABLE_SCAN,INDEX_SCAN | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | slave_skip_errors | OFF | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | slave_sql_verify_checksum | OFF | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | slave_transaction_retries | 10 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | slave_type_conversions | ALL_LOSSY | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | slow_query_log | 0 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | slow_query_log_file | /usr/local/mysql/data/obrd-slow.log | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | sort_buffer_size | 262144 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | sql_auto_is_null | OFF | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | sql_big_selects | ON | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | sql_buffer_result | 0 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | sql_mode | STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_AUTO_CREATE_USER | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | sql_notes | OFF | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | sql_quote_show_create | ON | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | sql_safe_updates | OFF | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | sql_select_limit | 9223372036854775807 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | sql_slave_skip_counter | 0 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | sql_throttle_cpu | -1 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | sql_throttle_current_priority | 100 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | sql_throttle_io | -1 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | sql_throttle_logical_reads | -1 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | sql_throttle_network | -1 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | sql_throttle_priority | -1 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | sql_throttle_rt | -1 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | sql_warnings | OFF | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | ssl_ca | | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | ssl_capath | | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | ssl_cert | | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | ssl_cipher | | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | ssl_crl | | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | ssl_crlpath | | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | ssl_key | | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | stored_program_cache | 256 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | super_read_only | OFF | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | sync_binlog | 1 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | sync_relay_log | 10000 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | sync_relay_log_info | 10000 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | system_time_zone | +08:00 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | table_definition_cache | -1 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | table_open_cache_instances | 16 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | timestamp | 0 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | time_format | %H:%i:%s | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | time_zone | +08:00 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | tls_version | | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | tmpdir | | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | tmp_table_size | 16777216 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | tracefile_identifier | | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | transaction_alloc_block_size | 8192 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | transaction_allow_batching | OFF | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | transaction_isolation | READ-COMMITTED | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | transaction_prealloc_size | 4096 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | transaction_read_only | OFF | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | transaction_write_set_extraction | OFF | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | tx_isolation | READ-COMMITTED | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | tx_read_only | OFF | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | unique_checks | ON | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | updatable_views_with_limit | ON | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | validate_password_check_user_name | on | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | validate_password_dictionary_file | | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | validate_password_length | 0 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | validate_password_mixed_case_count | 0 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | validate_password_number_count | 0 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | validate_password_policy | low | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | validate_password_special_char_count | 0 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | version | 5.7.25-OceanBase_CE-v4.3.4.0 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | version_comment | OceanBase_CE 4.3.4.0 (r100000162024110717-82547d6edc6ea98ba710e376a736a9a850499a06) (Built Nov 7 2024 17:28:11) | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | version_compile_machine | | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | version_compile_os | | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | version_tokens_session | | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | wait_timeout | 28800 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | warning_count | 0 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | _aggregation_optimization_settings | 0 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | _enable_mysql_pl_priv_check | ON | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | _enable_storage_cardinality_estimation | ON | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | _optimizer_gather_stats_on_load | ON | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | _optimizer_null_aware_antijoin | ON | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | _priv_control | | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | _show_ddl_in_compat_mode | OFF | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+ | _windowfunc_optimization_settings | 0 | +----------------------------------------------------+------------------------------------------------------------------------------------------------------------------+