A comprehensive execution view for OceanBase parallel query.
Report generate at 2023-01-06 17:08:31 Tenant SQL compatibility mode is mysql
| TRACE_ID | QUERY_SQL | RETURN_ROWS | REQUEST_TIME | REQUEST_END_TIME | ELAPSED_TIME | TENANT_NAME | USER_NAME | DB_NAME | PLAN_ID | TENANT_ID | MYSQL_VERSION | SVR_IP | SVR_PORT |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Y4C360B9E1F4D-0005F192D9891CC0-0-0 | select /*+ parallel(4) */ count(*) from (select a.c1 from t1 a, t1 b where a.c2 = b.c3) | 1 | 2023-01-06 16:57:43.219200 | 2023-01-06 17:04:15.739500 | 392520309 | mysql | admin | test | 463 | 1004 | 5.7.25-OceanBase-v4.1.0.0 | 192.168.1.77 | 19510 |
explain select /*+ parallel(4) */ count(*) from (select a.c1 from t1 a, t1 b where a.c2 = b.c3); +----------------------------------------------------------------------------+ | Query Plan | +----------------------------------------------------------------------------+ | ============================================================ | | |ID|OPERATOR |NAME |EST. ROWS|COST| | | ------------------------------------------------------------ | | |0 |SCALAR GROUP BY | |1 |5 | | | |1 | PX COORDINATOR | |4 |5 | | | |2 | EXCHANGE OUT DISTR |:EX10002|4 |5 | | | |3 | MERGE GROUP BY | |4 |4 | | | |4 | HASH JOIN | |1 |4 | | | |5 | EXCHANGE IN DISTR | |1 |2 | | | |6 | EXCHANGE OUT DISTR (HASH)|:EX10000|1 |2 | | | |7 | PX BLOCK ITERATOR | |1 |2 | | | |8 | TABLE SCAN |a |1 |2 | | | |9 | EXCHANGE IN DISTR | |1 |2 | | | |10| EXCHANGE OUT DISTR (HASH)|:EX10001|1 |2 | | | |11| PX BLOCK ITERATOR | |1 |2 | | | |12| TABLE SCAN |b |1 |2 | | | ============================================================ | | | | Outputs & filters: | | ------------------------------------- | | 0 - output([T_FUN_COUNT_SUM(T_FUN_COUNT(*))]), filter(nil), rowset=256, | | group(nil), agg_func([T_FUN_COUNT_SUM(T_FUN_COUNT(*))]) | | 1 - output([T_FUN_COUNT(*)]), filter(nil), rowset=256 | | 2 - output([T_FUN_COUNT(*)]), filter(nil), rowset=256, dop=4 | | 3 - output([T_FUN_COUNT(*)]), filter(nil), rowset=256, | | group(nil), agg_func([T_FUN_COUNT(*)]) | | 4 - output(nil), filter(nil), rowset=256, | | equal_conds([a.c2 = b.c3]), other_conds(nil) | | 5 - output([a.c2]), filter(nil), rowset=256 | | 6 - (#keys=1, [a.c2]), output([a.c2]), filter(nil), rowset=256, dop=4 | | 7 - output([a.c2]), filter(nil), rowset=256 | | 8 - output([a.c2]), filter(nil), rowset=256, | | access([a.c2]), partitions(p[0-3]) | | 9 - output([b.c3]), filter(nil), rowset=256 | | 10 - (#keys=1, [b.c3]), output([b.c3]), filter(nil), rowset=256, dop=4 | | 11 - output([b.c3]), filter(nil), rowset=256 | | 12 - output([b.c3]), filter(nil), rowset=256, | | access([b.c3]), partitions(p[0-3]) | | | +----------------------------------------------------------------------------+
select * from oceanbase.gv$ob_plan_cache_plan_explain where tenant_id = 1004 and plan_id = 463 and svr_ip = '192.168.1.77' and svr_port = 19510 +-----------+--------------+----------+---------+------------+--------------+-----------------------------+------+------+------+-----------------------------------------------------------------------------------------------------------------------------------------------+ | TENANT_ID | SVR_IP | SVR_PORT | PLAN_ID | PLAN_DEPTH | PLAN_LINE_ID | OPERATOR | NAME | ROWS | COST | PROPERTY | +-----------+--------------+----------+---------+------------+--------------+-----------------------------+------+------+------+-----------------------------------------------------------------------------------------------------------------------------------------------+ | 1004 | 192.168.1.77 | 19510 | 463 | 0 | 0 | PHY_SCALAR_AGGREGATE | NULL | 1 | 4 | NULL | | 1004 | 192.168.1.77 | 19510 | 463 | 1 | 1 | PHY_PX_FIFO_COORD | NULL | 4 | 4 | NULL | | 1004 | 192.168.1.77 | 19510 | 463 | 2 | 2 | PHY_PX_REDUCE_TRANSMIT | NULL | 4 | 4 | NULL | | 1004 | 192.168.1.77 | 19510 | 463 | 3 | 3 | PHY_MERGE_GROUP_BY | NULL | 4 | 3 | NULL | | 1004 | 192.168.1.77 | 19510 | 463 | 4 | 4 | PHY_HASH_JOIN | NULL | 1 | 3 | NULL | | 1004 | 192.168.1.77 | 19510 | 463 | 5 | 5 | PHY_PX_FIFO_RECEIVE | NULL | 1 | 1 | NULL | | 1004 | 192.168.1.77 | 19510 | 463 | 6 | 6 | PHY_PX_DIST_TRANSMIT | NULL | 1 | 1 | NULL | | 1004 | 192.168.1.77 | 19510 | 463 | 7 | 7 | PHY_GRANULE_ITERATOR | NULL | 1 | 1 | NULL | | 1004 | 192.168.1.77 | 19510 | 463 | 8 | 8 | PHY_TABLE_SCAN | a | 1 | 1 | table_rows:1, physical_range_rows:1, logical_range_rows:1, index_back_rows:0, output_rows:1, est_method:default_stat, avaiable_index_name[t1] | | 1004 | 192.168.1.77 | 19510 | 463 | 5 | 9 | PHY_PX_FIFO_RECEIVE | NULL | 1 | 1 | NULL | | 1004 | 192.168.1.77 | 19510 | 463 | 6 | 10 | PHY_PX_DIST_TRANSMIT | NULL | 1 | 1 | NULL | | 1004 | 192.168.1.77 | 19510 | 463 | 7 | 11 | PHY_GRANULE_ITERATOR | NULL | 1 | 1 | NULL | | 1004 | 192.168.1.77 | 19510 | 463 | 8 | 12 | PHY_TABLE_SCAN | b | 1 | 1 | table_rows:1, physical_range_rows:1, logical_range_rows:1, index_back_rows:0, output_rows:1, est_method:default_stat, avaiable_index_name[t1] | +-----------+--------------+----------+---------+------------+--------------+-----------------------------+------+------+------+-----------------------------------------------------------------------------------------------------------------------------------------------+
CREATE TABLE `t1` ( `c1` int(11) NOT NULL, `c2` int(11) DEFAULT NULL, `c3` int(11) DEFAULT NULL, PRIMARY KEY (`c1`) ) DEFAULT CHARSET = utf8mb4 ROW_FORMAT = DYNAMIC COMPRESSION = 'zstd_1.3.8' REPLICA_NUM = 2 BLOCK_SIZE = 16384 USE_BLOOM_FILTER = FALSE TABLET_SIZE = 134217728 PCTFREE = 0 partition by hash(c1) (partition p0, partition p1, partition p2, partition p3)
+-------------------------+-------+ | Variable_name | Value | +-------------------------+-------+ | parallel_servers_target | 10 | +-------------------------+-------+
+--------------------------------------+----------------------------------------------------------------------------------------------+ | Variable_name | Value | +--------------------------------------+----------------------------------------------------------------------------------------------+ | autocommit | OFF | | auto_increment_cache_size | 1000000 | | auto_increment_increment | 1 | | auto_increment_offset | 1 | | binlog_checksum | CRC32 | | binlog_format | ROW | | binlog_rows_query_log_events | OFF | | binlog_row_image | FULL | | block_encryption_mode | aes-128-ecb | | 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 | | collation_connection | utf8mb4_general_ci | | collation_database | utf8mb4_general_ci | | collation_server | utf8mb4_general_ci | | concurrent_insert | AUTO | | connect_timeout | 10 | | cte_max_recursion_depth | 1000 | | cursor_sharing | FORCE | | datadir | /home/xiaochu.yh/deploy//ob2.obs0/store | | default_authentication_plugin | mysql_native_password | | default_password_lifetime | 0 | | default_storage_engine | OceanBase | | disabled_storage_engines | | | div_precision_increment | 4 | | error_count | 0 | | error_on_overlap_time | OFF | | explicit_defaults_for_timestamp | ON | | foreign_key_checks | ON | | general_log | OFF | | group_concat_max_len | 1024 | | have_openssl | YES | | have_profiling | YES | | have_query_cache | NO | | have_ssl | YES | | hostname | | | identity | 0 | | init_connect | | | innodb_strict_mode | ON | | interactive_timeout | 28800 | | is_result_accurate | ON | | last_insert_id | 0 | | lc_messages | en_US | | license | | | local_infile | ON | | lock_wait_timeout | 31536000 | | log_bin | ON | | log_row_value_options | | | long_query_time | 10 | | lower_case_table_names | 1 | | max_allowed_packet | 4194304 | | max_connections | 2147483647 | | max_execution_time | 0 | | max_sp_recursion_depth | 0 | | max_user_connections | 0 | | net_buffer_length | 16384 | | net_read_timeout | 30 | | net_write_timeout | 60 | | ob_bnl_join_cache_size | 10485760 | | ob_check_sys_variable | ON | | ob_compatibility_mode | MYSQL | | ob_early_lock_release | OFF | | ob_enable_aggregation_pushdown | ON | | ob_enable_index_direct_select | OFF | | ob_enable_jit | OFF | | ob_enable_plan_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 | ON | | ob_interm_result_mem_limit | 2147483648 | | ob_last_schema_version | 0 | | ob_log_level | disabled | | ob_max_read_stale_time | 5000000 | | 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 | 10000000 | | ob_read_consistency | STRONG | | ob_reserved_meta_memory_percentage | 10 | | ob_route_policy | READONLY_ZONE_FIRST | | ob_sql_audit_percentage | 3 | | ob_sql_plan_memory_percentage | 5 | | ob_sql_work_area_percentage | 5 | | 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 | 86400000000 | | optimizer_capture_sql_plan_baselines | OFF | | optimizer_use_sql_plan_baselines | OFF | | parallel_servers_target | 10 | | performance_schema | OFF | | plugin_dir | ./plugin_dir/ | | protocol_version | 10 | | query_cache_limit | 0 | | query_cache_min_res_unit | 0 | | query_cache_size | 0 | | query_cache_type | OFF | | query_cache_wlock_invalidate | OFF | | read_only | OFF | | recyclebin | ON | | regexp_stack_limit | 8000000 | | regexp_time_limit | 32 | | resource_manager_plan | | | secure_file_priv | | | server_id | 1 | | server_uuid | 17bb3c81-8d8e-11ed-a599-02420b9e1f4d | | 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 | | sql_auto_is_null | OFF | | sql_mode | STRICT_ALL_TABLES,NO_ZERO_IN_DATE | | sql_notes | OFF | | sql_quote_show_create | ON | | sql_safe_updates | OFF | | sql_select_limit | 9223372036854775807 | | 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 | | | system_time_zone | +08:00 | | timestamp | 0 | | time_format | %H:%i:%s | | time_zone | +8:00 | | tls_version | | | tmpdir | | | tmp_table_size | 16777216 | | tracefile_identifier | | | transaction_isolation | READ-COMMITTED | | transaction_read_only | OFF | | tx_isolation | READ-COMMITTED | | tx_read_only | OFF | | unique_checks | ON | | validate_password_check_user_name | on | | 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-v4.1.0.0 | | version_comment | OceanBase 4.1.0.0 (r1-f6a88f68b2a449ca3ad1818d9c3fe920c222c824) (Built Jan 6 2023 14:44:11) | | version_compile_machine | | | version_compile_os | | | wait_timeout | 28800 | | warning_count | 0 | | _aggregation_optimization_settings | 0 | | _optimizer_null_aware_antijoin | ON | | _windowfunc_optimization_settings | 0 | +--------------------------------------+----------------------------------------------------------------------------------------------+
+-------+----------+--------------+----------+-------------------------------------------------+-----------+---------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+---------+-------------------+ | zone | svr_type | svr_ip | svr_port | name | data_type | value | info | section | scope | source | edit_level | +-------+----------+--------------+----------+-------------------------------------------------+-----------+---------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+---------+-------------------+ | zone1 | observer | 192.168.1.77 | 19510 | enable_cgroup | None | True | when set to false, cgroup will not init; when set to true but cgroup root dir is not ready, print ERROR | OBSERVER | CLUSTER | DEFAULT | STATIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | sql_login_thread_count | None | 0 | the number of threads for sql login request. Range: [0, 32] in integer, 0 stands for use default thread count defined in TG.the default thread count for login request in TG is normal:6 mini-mode:2 | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | tcp_keepcnt | None | 10 | The maximum number of keepalive probes TCP should send before dropping the connection. Take effect for new established connections. Range: [1,+∞) | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | tcp_keepintvl | None | 6s | The time (in seconds) between individual keepalive probes. Take effect for new established connections. Range: [1s, +∞] | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | tcp_keepidle | None | 7200s | The time (in seconds) the connection needs to remain idle before TCP starts sending keepalive probe. Take effect for new established connections. Range: [1s, +∞] | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | enable_tcp_keepalive | None | True | enable TCP keepalive for the TCP connection of sql protocol. Take effect for new established connections. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | ob_ratelimit_stat_period | None | 1s | the time interval to update observer's maximum bandwidth to a certain region. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | enable_ob_ratelimit | None | False | enable ratelimit between regions for RPC connection. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | ssl_external_kms_info | None | | when using the external key management center for ssl, this parameter will store some key management information | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | use_large_pages | None | false | used to manage the database's use of large pages, values: false, true, only | OBSERVER | CLUSTER | DEFAULT | STATIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | schema_history_recycle_interval | None | 10m | the time interval between the schedules of schema history recyle task. Range: [0s, +∞) | LOAD_BALANCE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | backup_data_file_size | None | 4G | backup data file size. Range: [512M, 4G] in integer | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | use_ipv6 | None | False | Whether this server uses ipv6 address | OBSERVER | CLUSTER | DEFAULT | STATIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | ssl_client_authentication | None | False | enable server SSL support. Takes effect after ca/cert/key file is configured correctly. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | stack_size | None | 512K | the size of routine execution stackRange: [512K, 20M] | OBSERVER | CLUSTER | DEFAULT | STATIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | px_task_size | None | 2M | to be removed | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | dtl_buffer_size | None | 64K | to be removed | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | micro_block_merge_verify_level | None | 2 | specify what kind of verification should be done when merging micro block. 0 : no verification will be done 1 : verify encoding algorithm, encoded micro block will be read to ensure data is correct 2 : verify encoding and compression algorithm, besides encoding verification, compressed block will be decompressed to ensure data is correct3 : verify encoding, compression algorithm and lost write protect | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | builtin_db_data_verify_cycle | None | 20 | check cycle of db data. Range: [0, 360] in integer. Unit: day. 0: check nothing. 1-360: check all data every specified days. The default value is 20. The real check cycle maybe longer than the specified value for insuring performance. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | tablet_size | None | 128M | default tablet size, has to be a multiple of 2M | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | sys_bkgd_migration_change_member_list_timeout | None | 20s | the timeout for migration change member list retry. The default value is 20s. Range: [0s,24h] | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | sys_bkgd_migration_retry_num | None | 3 | retry num limit during migration. Range: [3, 100] in integer | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | restore_concurrency | None | 0 | the current work thread num of restore macro block. Range: [0,512] in integer | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | disk_io_thread_count | None | 8 | The number of io threads on each disk. The default value is 8. Range: [2,32] in even integer | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | sys_bkgd_net_percentage | None | 60 | the net percentage of sys background net. Range: [0, 100] in integer | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | data_disk_usage_limit_percentage | None | 90 | the safe use percentage of data diskRange: [50,100] in integer | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | data_storage_error_tolerance_time | None | 300s | time to tolerate disk read failure, after that, the disk status will be set error. Range [10s,7200s]. The default value is 300s | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | data_storage_warning_tolerance_time | None | 30s | time to tolerate disk read failure, after that, the disk status will be set warning. Range [10s,300s]. The default value is 30s | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | fuse_row_cache_priority | None | 1 | fuse row cache priority. Range:[1, ) | CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | bf_cache_miss_count_threshold | None | 100 | bf cache miss count threshold, 0 means disable bf cache. Range:[0, ) | CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | bf_cache_priority | None | 1 | bf cache priority. Range:[1, ) | CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | user_row_cache_priority | None | 1 | user row cache priority. Range:[1, ) | CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | user_block_cache_priority | None | 1 | user block cache priority. Range:[1, ) | CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | index_block_cache_priority | None | 10 | index cache priority. Range:[1, ) | CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | opt_tab_stat_cache_priority | None | 1 | tab stat cache priority. Range:[1, ) | CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | tablet_ls_cache_priority | None | 1000 | tablet ls cache priority. Range:[1, ) | CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | location_cache_refresh_sql_timeout | None | 1s | The timeout used for refreshing location cache by SQL. Range: [1ms, +∞) | LOCATION_CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | location_cache_refresh_rpc_timeout | None | 500ms | The timeout used for refreshing location cache by RPC. Range: [1ms, +∞) | LOCATION_CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | all_server_list | None | 192.168.1.77:19510,192.168.1.77:19512 | all server addr in cluster | LOCATION_CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | location_cache_refresh_min_interval | None | 100ms | the time interval in which no request for location cache renewal will be executed. The default value is 100 milliseconds. [0s, +∞) | LOCATION_CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | location_fetch_concurrency | None | 20 | the maximum number of the tasks for fetching location cache concurrently. Range: [1, 1000] | LOCATION_CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | location_refresh_thread_count | None | 4 | the number of threads for fetching location cache in the background. Range: (1, 64] | LOCATION_CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | virtual_table_location_cache_expire_time | None | 8s | expiration time for virtual table location info in partiton location cache. Range: [1s, +∞) | LOCATION_CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | rpc_timeout | None | 2s | the time during which a RPC request is permitted to execute before it is terminated | RPC | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | ignore_replay_checksum_error | None | False | specifies whether error raised from the memtable replay checksum validation can be ignored. Value: True:ignored; False: not ignored | TRANS | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | row_compaction_update_limit | None | 6 | maximum update count before trigger row compaction. Range: [1, 6400] | TRANS | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | clog_sync_time_warn_threshold | None | 100ms | the time given to the commit log synchronization between a leader and its followers before a \'warning\' message is printed in the log file. Range: [1ms,1000ms] | TRANS | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | trx_2pc_retry_interval | None | 100ms | the time interval between the retries in case of failure during a transaction\'s two-phase commit phase. Range: [1ms,5000ms] | TRANS | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | enable_sys_unit_standalone | None | False | specifies whether sys unit standalone deployment is turned on. Value: True:turned on False: turned off | LOAD_BALANCE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | server_balance_cpu_mem_tolerance_percent | None | 5 | specifies the tolerance (in percentage) of the unbalance of the cpu/memory utilization among all servers. The average cpu/memory utilization is calculated by dividing the total cpu/memory by the number of servers. server balancer will start a rebalancing task when the deviation between the average usage and some server load is greater than this tolerance Range: [1, 100] in percentage | LOAD_BALANCE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | server_balance_disk_tolerance_percent | None | 1 | specifies the tolerance (in percentage) of the unbalance of the disk space utilization among all servers. The average disk space utilization is calculated by dividing the total space by the number of servers. server balancer will start a rebalancing task when the deviation between the average usage and some server load is greater than this tolerance Range: [1, 100] in percentage | LOAD_BALANCE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | server_balance_critical_disk_waterlevel | None | 80 | disk water level to determine server balance strategy | LOAD_BALANCE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | balancer_log_interval | None | 1m | the time interval between logging the load-balancing task\'s statistics. Range: [1s, +∞) | LOAD_BALANCE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | balancer_task_timeout | None | 20m | the time to execute the load-balancing task before it is terminated. Range: [1s, +∞) | LOAD_BALANCE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | balancer_tolerance_percentage | None | 10 | specifies the tolerance (in percentage) of the unbalance of the disk space utilization among all units. The average disk space utilization is calculated by dividing the total space by the number of units. For example, say balancer_tolerance_percentage is set to 10 and a tenant has two units in the system, the average disk use for each unit should be about the same, thus 50% of the total value. Therefore, the system will start a rebalancing task when any unit\'s disk space goes beyond +-10% of the average usage. Range: [1, 100) in percentage | LOAD_BALANCE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | balancer_idle_time | None | 10s | the time interval between the schedules of the load-balancing task. Range: [10s, +∞) | LOAD_BALANCE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | enable_rebalance | None | True | specifies whether the load-balancing is turned on. Value: True:turned on False: turned off | LOAD_BALANCE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | enable_rereplication | None | True | specifies whether the auto-replication is turned on. Value: True:turned on False: turned off | LOAD_BALANCE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | resource_hard_limit | None | 100 | system utilization should not be large than resource_hard_limit | LOAD_BALANCE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | log_disk_percentage | None | 10 | the percentage of disk space used by the log files. Range: [0,99] in integer;only effective when parameter log_disk_size is 0;when log_disk_percentage is 0: a) if the data and the log are on the same disk, means log_disk_percentage = 30 b) if the data and the log are on the different disks, means log_disk_perecentage = 90 | LOGSERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | log_disk_size | None | 0 | the size of disk space used by the log files. Range: [0, +∞) | LOGSERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | recyclebin_object_expire_time | None | 0s | recyclebin object expire time, default 0 that means auto purge recyclebin off. Range: [0s, +∞) | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | ob_event_history_recycle_interval | None | 7d | the time to recycle event history. Range: [1d, 180d] | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | enable_major_freeze | None | True | specifies whether major_freeze function is turned on. Value: True:turned on; False: turned off | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | enable_ddl | None | True | specifies whether DDL operation is turned on. Value: True:turned on; False: turned off | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | min_observer_version | None | 4.1.0.0 | the min observer version | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | tablet_meta_table_check_interval | None | 30m | the time interval that observer compares tablet meta table with local ls replica info and make adjustments to ensure the correctness of tablet meta table. Range: [1m,+∞) | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | ls_meta_table_check_interval | None | 1s | the time interval that observer compares ls meta table with local ls replica info and make adjustments to ensure the correctness of ls meta table. Range: [1ms,+∞) | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | tablet_meta_table_scan_batch_count | None | 999 | the number of tablet replica info that will be read by each request on the tablet-related system tables during procedures such as load-balancing, daily merge, election and etc. Range:(0,65536] | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | rootservice_ready_check_interval | None | 3s | the interval between the schedule of the rootservice restart task while restart failed Range: [100000us, 1m] | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | server_check_interval | None | 30s | the time interval between schedules of a task that examines the __all_server table. Range: [1s, +∞) | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | migration_disable_time | None | 3600s | the duration in which the observer stays in the \'block_migrate_in\' status, which means it is not allowed to migrate into the server. Range: [1s, +∞) | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | server_permanent_offline_time | None | 3600s | the time interval between any two heartbeats beyond which a server is considered to be \'permanently\' offline. Range: [20s,+∞) | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | enable_sys_table_ddl | None | False | specifies whether a \'system\' table is allowed be to created manually. Value: True: allowed; False: not allowed | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | rootservice_async_task_queue_size | None | 16384 | the size of the queue for all asynchronous tasks at rootserver. Range: [8, 131072] in integer | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | rootservice_async_task_thread_count | None | 4 | maximum of threads allowed for executing asynchronous task at rootserver. Range: [1, 10] | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | lease_time | None | 10s | Lease for current heartbeat. If the root server does not received any heartbeat from an observer in lease_time seconds, that observer is considered to be offline. Not recommended for modification. Range: [1s, 5m] | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | max_px_worker_count | None | 64 | maximum parallel execution worker count can be used for all parallel requests. Range:[0, 65535] | TENANT | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | plan_cache_evict_interval | None | 1s | time interval for periodic plan cache eviction. Range: [0s, +∞) | TENANT | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | plan_cache_low_watermark | None | 1500M | (don't use now) memory usage at which plan cache eviction will be stopped. Range: [0, plan_cache_high_watermark) | TENANT | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | plan_cache_high_watermark | None | 2000M | (don't use now) memory usage at which plan cache eviction will be trigger immediately. Range: [0, +∞) | TENANT | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | memstore_limit_percentage | None | 50 | used in calculating the value of MEMSTORE_LIMIT parameter: memstore_limit_percentage = memstore_limit / memory_size，memory_size, where MEMORY_SIZE is determined when the tenant is created. Range: (0, 100) | TENANT | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | px_workers_per_cpu_quota | None | 10 | the ratio(integer) between the number of system allocated px workers vs the maximum number of threads that can be scheduled concurrently. Range: [0, 20] | TENANT | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | global_write_halt_residual_memory | None | 30 | disable write to memstore when observer memstore free memory(plus memory hold by blockcache) lower than this limit, Range: (0, 100)limit calc by (memory_limit - system_memory) * global_write_halt_residual_memory/100 | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | token_reserved_percentage | None | 30 | specifies the amount of token increase allocated to a tenant based on his consumption from the last round (without exceeding his upper limit). Range: [0, 100] in percentage | TENANT | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | large_query_threshold | None | 5s | threshold for execution time beyond which a request may be paused and rescheduled as a \'large request\'. Range: [1ms, +∞) | TENANT | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | large_query_worker_percentage | None | 30 | the percentage of the workers reserved to serve large query request. Range: [0, 100] in percentage | TENANT | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | workers_per_cpu_quota | None | 10 | the ratio(integer) between the number of system allocated workers vs the maximum number of threads that can be scheduled concurrently. Range: [2, 20] | TENANT | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | location_cache_cpu_quota | None | 5 | the number of vCPUs allocated for the requests regarding location info of the core tables. Range: [0,10] in integer | TENANT | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | server_cpu_quota_max | None | 1 | the number of maximal vCPUs allocated to the server tenant(a special internal tenant that exists on every observer). Range: [1, 16] | TENANT | CLUSTER | DEFAULT | STATIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | server_cpu_quota_min | None | 1 | the number of minimal vCPUs allocated to the server tenant(a special internal tenant that exists on every observer). Range: [1, 16] | TENANT | CLUSTER | DEFAULT | STATIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | tenant_cpu_variation_per_server | None | 50 | the percentage variation for any tenant\'s CPU quota allocation on each observer. The default value is 50(%). Range: [0, 100] in percentage | TENANT | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | tableapi_transport_compress_func | None | none | compressor used for tableAPI query result. Values: none, lz4_1.0, snappy_1.0, zlib_1.0, zstd_1.0 zstd 1.3.8 | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | enable_sql_operator_dump | None | True | specifies whether sql operators (sort/hash join/material/window function/interm result/...) allowed to write to disk | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | autoinc_cache_refresh_interval | None | 3600s | auto-increment service cache refresh sync_value in this interval, with default 3600s. Range: [100ms, +∞) | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | memory_chunk_cache_size | None | 0M | the maximum size of memory cached by memory chunk cache. Range: [0M,], 0 stands for adaptive | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | cache_wash_threshold | None | 1G | size of remaining memory at which cache eviction will be triggered. Range: [0,+∞) | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | memory_limit_percentage | None | 80 | the size of the memory reserved for internal use(for testing purpose). Range: [10, 90] | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | enable_syslog_recycle | None | False | specifies whether log file recycling is turned on. Value: True：turned on; False: turned off | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | enable_syslog_wf | None | False | specifies whether any log message with a log level higher than \'WARN\' would be printed into a separate file with a suffix of \'wf\' | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | enable_async_syslog | None | True | specifies whether use async log for observer.log, elec.log and rs.log | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | max_syslog_file_count | None | 0 | specifies the maximum number of the log files that can co-exist before the log file recycling kicks in. Each log file can occupy at most 256MB disk space. When this value is set to 0, no log file will be removed. Range: [0, +∞) in integer | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | syslog_io_bandwidth_limit | None | 100000MB | Syslog IO bandwidth limitation, exceeding syslog would be truncated. Use 0 to disable ERROR log. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | syslog_level | None | INFO | specifies the current level of logging. There are DEBUG, TRACE, INFO, WARN, USER_ERR, ERROR, six different log levels. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | obconfig_url | None | | URL for OBConfig service | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | cluster_id | None | 1 | ID of the cluster | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | cluster | None | ob2.xiaochu.yh.192.168.1.77 | Name of the cluster | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | rootservice_list | None | 192.168.1.77:19510:19511;192.168.1.77:19512:19513 | a list of servers against which election candidate is checked for validation | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | weak_read_version_refresh_interval | None | 100ms | the time interval to refresh cluster weak read version Range: [50ms, +∞) | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | default_compress | None | archive | default compress strategy for create new table within oracle mode | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | default_row_format | None | dynamic | default row format in mysql mode | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | default_compress_func | None | zstd_1.3.8 | default compress function name for create new table, values: none, lz4_1.0, snappy_1.0, zlib_1.0, zstd_1.0, zstd_1.3.8 | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | schema_history_expire_time | None | 1d | the hour of expire time for schema history, from 1hour to 30days, with default 7days. Range: [1h, 30d] | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | enable_upgrade_mode | None | False | specifies whether upgrade mode is turned on. If turned on, daily merger and balancer will be disabled. Value: True: turned on; False: turned off; | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | enable_perf_event | None | True | specifies whether to enable perf event feature. The default value is True. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | dead_socket_detection_timeout | None | 3s | specify a tcp_user_timeout for RFC5482. A zero value makes the option disabled, Range: [0, 2h] | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | debug_sync_timeout | None | 0 | Enable the debug sync facility and optionally specify a default wait timeout in micro seconds. A zero value keeps the facility disabled, Range: [0, +∞] | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | enable_rich_error_msg | None | False | specifies whether add ip:port, time and trace id to user error message. The default value is FALSE. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | enable_record_trace_id | None | True | specifies whether record app trace id is turned on. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | enable_sql_audit | None | True | specifies whether SQL audit is turned on. The default value is TRUE. Value: TRUE: turned on FALSE: turned off | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | max_string_print_length | None | 500 | truncate very long string when printing to log file. Range:[0,] | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | system_trace_level | None | 1 | system trace log level, 0:none, 1:standard, 2:debug. The default log level for trace log is 1 | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | enable_record_trace_log | None | True | specifies whether to always record the trace log. The default value is True. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | trace_log_slow_query_watermark | None | 100ms | the threshold of execution time (in milliseconds) of a query beyond which it is considered to be a \'slow query\'. Range: [1ms,+∞) | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | trace_log_sampling_interval | None | 10ms | the time interval for periodically printing log info in trace log. When force_trace_log is set to FALSE, for each time interval specifies by sampling_trace_log_interval, logging info regarding ‘slow query’ and ‘white list’ will be printed out. Range: [0ms,+∞) | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | cpu_count | None | 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 | | zone1 | observer | 192.168.1.77 | 19510 | system_memory | None | 5G | the memory reserved for internal use which cannot be allocated to any outer-tenant, and should be determined to guarantee every server functions normally. Range: [0M,) | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | rootservice_memory_limit | None | 2G | max memory size which can be used by rs tenant The default value is 2G. Range: [2G,) | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | memory_limit | None | 10G | the size of the memory reserved for internal use(for testing purpose), 0 means follow memory_limit_percentage. Range: 0, [4G,). | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | tenant_task_queue_size | None | 65536 | the size of the task queue for each tenant. Range: [1024,+∞) | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | rdma_io_thread_count | None | 0 | the number of RDMA I/O threads for Libreasy. Range: [0, 8] in integer, 0 stands for RDMA being disabled. | OBSERVER | CLUSTER | DEFAULT | STATIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | high_priority_net_thread_count | None | 0 | the number of rpc I/O threads for high priority messages, 0 means set off. Range: [0, 64] in integer | OBSERVER | CLUSTER | DEFAULT | STATIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | net_thread_count | None | 4 | the number of rpc/mysql I/O threads for Libeasy. Range: [0, 64] in integer, 0 stands for max(6, CPU_NUM/8) | OBSERVER | CLUSTER | DEFAULT | STATIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | internal_sql_execute_timeout | None | 30s | the number of microseconds an internal DML request is permitted to execute before it is terminated. Range: [1000us, 1h] | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | zone | None | zone1 | specifies the zone name | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | devname | None | eth0 | name of network adapter | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | mysql_port | None | 19511 | port number for mysql connection. Range: (1024, 65536) in integer | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | rpc_port | None | 19510 | the port number for RPC protocol. Range: (1024, 65536) in integer | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | leak_mod_to_check | None | NONE | the name of the module under memory leak checks | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | config_additional_dir | None | etc2;etc3 | additional directories of configure file | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | memory_reserved | None | 500M | the size of the system memory reserved for emergency internal use. Range: [10M, total size of memory] | SSTABLE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | datafile_disk_percentage | None | 50 | the percentage of disk space used by the data files. Range: [0,99] in integer | SSTABLE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | datafile_size | None | 20G | size of the data file. Range: [0, +∞) | SSTABLE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | redundancy_level | None | NORMAL | EXTERNAL: use extrernal redundancyNORMAL: tolerate one disk failureHIGH: tolerate two disk failure if disk count is enough | SSTABLE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | data_dir | None | /home/xiaochu.yh/deploy//ob2.obs0/store | the directory for the data file | SSTABLE | CLUSTER | DEFAULT | READONLY | | zone1 | observer | 192.168.1.77 | 19510 | enable_user_defined_rewrite_rules | None | False | specify whether the user defined rewrite rules are enabled. Value: True: enable False: disable | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | query_response_time_range_base | None | 10 | Select base of log for QUERY_RESPONSE_TIME ranges. WARNING: variable change takes affect only after flush.The default value is False. Value: TRUE: trigger flush FALSE: do not trigger | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | query_response_time_flush | None | False | Flush QUERY_RESPONSE_TIME table and re-read query_response_time_range_baseThe default value is False. Value: TRUE: trigger flush FALSE: do not trigger | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | query_response_time_stats | None | False | Enable or disable QUERY_RESPONSE_TIME statistics collectingThe default value is False. Value: TRUE: turned on FALSE: turned off | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | default_enable_extended_rowid | None | False | specifies whether to create table as extended rowid mode or not | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | ob_query_switch_leader_retry_timeout | None | 0ms | max time spend on retry caused by leader swith or network disconnectionRange: [0ms, +∞) | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | default_auto_increment_mode | None | order | specifies default auto-increment mode, default is 'order' | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | enable_sql_extension | None | True | specifies whether to allow use some oracle mode features in mysql mode | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | job_queue_processes | None | 1000 | specifies the maximum number of job slaves per instance that can be created for the execution of DBMS_JOB jobs and Oracle Scheduler (DBMS_SCHEDULER) jobs. | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | ob_proxy_readonly_transaction_routing_policy | None | False | Proxy route policy for readonly sql: whether regard begining read only stmts as in transaction | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | connection_control_max_connection_delay | None | 2147483647 | The maximum delay in milliseconds for server response to failed connection attempts, if connection_control_failed_connections_threshold is greater than zero | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | connection_control_min_connection_delay | None | 1000 | The minimum delay in milliseconds for server response to failed connection attempts, if connection_control_failed_connections_threshold is greater than zero. | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | connection_control_failed_connections_threshold | None | 0 | The number of consecutive failed connection attempts permitted to accountsbefore the server adds a delay for subsequent connection attempts | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | open_cursors | None | 50 | specifies the maximum number of open cursors a session can have at once.can use this parameter to prevent a session from opening an excessive number of cursors.Range: [0, 65535] in integer | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | ob_ssl_invited_common_names | None | NONE | when server use ssl, use it to control client identity with ssl subject common name. default NONE | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | plsql_warnings | None | DISABLE::ALL | enables or disables the reporting of warning messages by thePL/SQL compiler, and specifies which warning messages to show as errors | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | plsql_v2_compatibility | None | False | allows some abnormal behavior that Version 8 disallows, not available | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | plsql_optimize_level | None | 1 | specifies the optimization level that will be used tocompile PL/SQL library units. The higher the setting of this parameter, the more effortthe compiler makes to optimize PL/SQL library units | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | plsql_debug | None | False | specifies whether or not PL/SQL library units will be compiled for debugging | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | plsql_code_type | None | native | specifies the compilation mode for PL/SQL library units | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | plsql_ccflags | None | | provides a mechanism that allows PL/SQL programmers to controlconditional compilation of each PL/SQL library unit independently | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | tde_method | None | none | none : transparent encryption is none, none means cannot use tde, internal : transparent encryption is in the form of internal tables, bkmi : transparent encryption is in the form of external bkmi | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | external_kms_info | None | | when using the external key management center, this parameter will store some key management information | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | ob_enable_batched_multi_statement | None | False | enable use of batched multi statement | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | audit_trail | None | None | enables or disables database auditing, support NONE;OS;DB;DB,EXTENDED;DB_EXTENDED | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | audit_sys_operations | None | False | whether trace sys user operations | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | sql_work_area | None | 1G | Work area memory limitation for tenant | OBSERVER | TENANT | DEFAULT | STATIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | ob_compaction_schedule_interval | None | 10s | the time interval to schedule compaction, Range: [3s,5m]Range: [3s, 5m] | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | major_compact_trigger | None | 0 | specifies how many minor freeze should be triggered between two major freeze, Range: [0,65535] in integer | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | minor_compact_trigger | None | 2 | minor_compact_trigger, Range: [0,16] in integer | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | ha_low_thread_score | None | 0 | the current work thread score of high availability low thread. Range: [0,100] in integer. Especially, 0 means default value | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | ha_mid_thread_score | None | 0 | the current work thread score of high availability mid thread. Range: [0,100] in integer. Especially, 0 means default value | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | ha_high_thread_score | None | 0 | the current work thread score of high availability high thread. Range: [0,100] in integer. Especially, 0 means default value | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | compaction_high_thread_score | None | 0 | the current work thread score of high priority compaction. Range: [0,100] in integer. Especially, 0 means default value | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | compaction_mid_thread_score | None | 0 | the current work thread score of middle priority compaction. Range: [0,100] in integer. Especially, 0 means default value | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | compaction_low_thread_score | None | 0 | the current work thread score of low priority compaction. Range: [0,100] in integer. Especially, 0 means default value | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | io_category_config | None | other: 100,100,100 | configs for different category of io request. specify with category name, minimal percentage, maximal percentage, weight percentage. devide the category with semicolon | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | enable_early_lock_release | None | True | enable early lock release | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | merger_check_interval | None | 10s | the time interval between the schedules of the task that checks on the progress of MERGE for each zone. Range: [10s, 60m] | DAILY_MERGE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | major_freeze_duty_time | None | 02:00 | the start time of system daily merge procedure. Range: [00:00, 24:00) | DAILY_MERGE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | log_disk_utilization_threshold | None | 80 | log disk utilization threshold before reuse log files, should be smaller than log_disk_utilization_limit_threshold. Range: [10, 100) | LOGSERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | log_disk_utilization_limit_threshold | None | 95 | maximum of log disk usage percentage before stop submitting or receiving logs, should be bigger than log_disk_utilization_threshold. Range: [80, 100] | LOGSERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | compatible | None | 4.1.0.0 | compatible version for persisted data | ROOT_SERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | workarea_size_policy | None | AUTO | policy used to size SQL working areas (MANUAL/AUTO) | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | default_progressive_merge_num | None | 0 | default progressive_merge_num when tenant create tableRange:[0,) | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | writing_throttling_maximum_duration | None | 2h | maximum duration of writting throttling(in minutes), max value is 3 days | TRANS | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | writing_throttling_trigger_percentage | None | 60 | the threshold of the size of the mem store when writing_limit will be triggered. Rang:(0，100]. setting 100 means turn off writing limit | TRANS | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | freeze_trigger_percentage | None | 20 | the threshold of the size of the mem store when freeze will be triggered. Rang:(0，100) | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | undo_retention | None | 1800 | the low threshold value of undo retention. The system retains undo for at least the time specified in this config. Range: [0, 4294967295] | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | cpu_quota_concurrency | None | 4 | max allowed concurrency for 1 CPU quota. Range: [1,10] | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | enable_monotonic_weak_read | None | False | specifies observer supportting atomicity and monotonic order read | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone1 | observer | 192.168.1.77 | 19510 | max_stale_time_for_weak_consistency | None | 5s | the max data stale time that cluster weak read version behind current timestamp,no smaller than weak_read_version_refresh_interval, range: [5s, +∞) | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | enable_cgroup | None | True | when set to false, cgroup will not init; when set to true but cgroup root dir is not ready, print ERROR | OBSERVER | CLUSTER | DEFAULT | STATIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | sql_login_thread_count | None | 0 | the number of threads for sql login request. Range: [0, 32] in integer, 0 stands for use default thread count defined in TG.the default thread count for login request in TG is normal:6 mini-mode:2 | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | tcp_keepcnt | None | 10 | The maximum number of keepalive probes TCP should send before dropping the connection. Take effect for new established connections. Range: [1,+∞) | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | tcp_keepintvl | None | 6s | The time (in seconds) between individual keepalive probes. Take effect for new established connections. Range: [1s, +∞] | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | tcp_keepidle | None | 7200s | The time (in seconds) the connection needs to remain idle before TCP starts sending keepalive probe. Take effect for new established connections. Range: [1s, +∞] | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | enable_tcp_keepalive | None | True | enable TCP keepalive for the TCP connection of sql protocol. Take effect for new established connections. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | ob_ratelimit_stat_period | None | 1s | the time interval to update observer's maximum bandwidth to a certain region. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | enable_ob_ratelimit | None | False | enable ratelimit between regions for RPC connection. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | ssl_external_kms_info | None | | when using the external key management center for ssl, this parameter will store some key management information | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | use_large_pages | None | false | used to manage the database's use of large pages, values: false, true, only | OBSERVER | CLUSTER | DEFAULT | STATIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | schema_history_recycle_interval | None | 10m | the time interval between the schedules of schema history recyle task. Range: [0s, +∞) | LOAD_BALANCE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | backup_data_file_size | None | 4G | backup data file size. Range: [512M, 4G] in integer | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | use_ipv6 | None | False | Whether this server uses ipv6 address | OBSERVER | CLUSTER | DEFAULT | STATIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | ssl_client_authentication | None | False | enable server SSL support. Takes effect after ca/cert/key file is configured correctly. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | stack_size | None | 512K | the size of routine execution stackRange: [512K, 20M] | OBSERVER | CLUSTER | DEFAULT | STATIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | px_task_size | None | 2M | to be removed | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | dtl_buffer_size | None | 64K | to be removed | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | micro_block_merge_verify_level | None | 2 | specify what kind of verification should be done when merging micro block. 0 : no verification will be done 1 : verify encoding algorithm, encoded micro block will be read to ensure data is correct 2 : verify encoding and compression algorithm, besides encoding verification, compressed block will be decompressed to ensure data is correct3 : verify encoding, compression algorithm and lost write protect | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | builtin_db_data_verify_cycle | None | 20 | check cycle of db data. Range: [0, 360] in integer. Unit: day. 0: check nothing. 1-360: check all data every specified days. The default value is 20. The real check cycle maybe longer than the specified value for insuring performance. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | tablet_size | None | 128M | default tablet size, has to be a multiple of 2M | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | sys_bkgd_migration_change_member_list_timeout | None | 20s | the timeout for migration change member list retry. The default value is 20s. Range: [0s,24h] | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | sys_bkgd_migration_retry_num | None | 3 | retry num limit during migration. Range: [3, 100] in integer | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | restore_concurrency | None | 0 | the current work thread num of restore macro block. Range: [0,512] in integer | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | disk_io_thread_count | None | 8 | The number of io threads on each disk. The default value is 8. Range: [2,32] in even integer | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | sys_bkgd_net_percentage | None | 60 | the net percentage of sys background net. Range: [0, 100] in integer | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | data_disk_usage_limit_percentage | None | 90 | the safe use percentage of data diskRange: [50,100] in integer | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | data_storage_error_tolerance_time | None | 300s | time to tolerate disk read failure, after that, the disk status will be set error. Range [10s,7200s]. The default value is 300s | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | data_storage_warning_tolerance_time | None | 30s | time to tolerate disk read failure, after that, the disk status will be set warning. Range [10s,300s]. The default value is 30s | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | fuse_row_cache_priority | None | 1 | fuse row cache priority. Range:[1, ) | CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | bf_cache_miss_count_threshold | None | 100 | bf cache miss count threshold, 0 means disable bf cache. Range:[0, ) | CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | bf_cache_priority | None | 1 | bf cache priority. Range:[1, ) | CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | user_row_cache_priority | None | 1 | user row cache priority. Range:[1, ) | CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | user_block_cache_priority | None | 1 | user block cache priority. Range:[1, ) | CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | index_block_cache_priority | None | 10 | index cache priority. Range:[1, ) | CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | opt_tab_stat_cache_priority | None | 1 | tab stat cache priority. Range:[1, ) | CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | tablet_ls_cache_priority | None | 1000 | tablet ls cache priority. Range:[1, ) | CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | location_cache_refresh_sql_timeout | None | 1s | The timeout used for refreshing location cache by SQL. Range: [1ms, +∞) | LOCATION_CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | location_cache_refresh_rpc_timeout | None | 500ms | The timeout used for refreshing location cache by RPC. Range: [1ms, +∞) | LOCATION_CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | all_server_list | None | 192.168.1.77:19510,192.168.1.77:19512 | all server addr in cluster | LOCATION_CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | location_cache_refresh_min_interval | None | 100ms | the time interval in which no request for location cache renewal will be executed. The default value is 100 milliseconds. [0s, +∞) | LOCATION_CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | location_fetch_concurrency | None | 20 | the maximum number of the tasks for fetching location cache concurrently. Range: [1, 1000] | LOCATION_CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | location_refresh_thread_count | None | 4 | the number of threads for fetching location cache in the background. Range: (1, 64] | LOCATION_CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | virtual_table_location_cache_expire_time | None | 8s | expiration time for virtual table location info in partiton location cache. Range: [1s, +∞) | LOCATION_CACHE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | rpc_timeout | None | 2s | the time during which a RPC request is permitted to execute before it is terminated | RPC | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | ignore_replay_checksum_error | None | False | specifies whether error raised from the memtable replay checksum validation can be ignored. Value: True:ignored; False: not ignored | TRANS | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | row_compaction_update_limit | None | 6 | maximum update count before trigger row compaction. Range: [1, 6400] | TRANS | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | clog_sync_time_warn_threshold | None | 100ms | the time given to the commit log synchronization between a leader and its followers before a \'warning\' message is printed in the log file. Range: [1ms,1000ms] | TRANS | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | trx_2pc_retry_interval | None | 100ms | the time interval between the retries in case of failure during a transaction\'s two-phase commit phase. Range: [1ms,5000ms] | TRANS | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | enable_sys_unit_standalone | None | False | specifies whether sys unit standalone deployment is turned on. Value: True:turned on False: turned off | LOAD_BALANCE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | server_balance_cpu_mem_tolerance_percent | None | 5 | specifies the tolerance (in percentage) of the unbalance of the cpu/memory utilization among all servers. The average cpu/memory utilization is calculated by dividing the total cpu/memory by the number of servers. server balancer will start a rebalancing task when the deviation between the average usage and some server load is greater than this tolerance Range: [1, 100] in percentage | LOAD_BALANCE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | server_balance_disk_tolerance_percent | None | 1 | specifies the tolerance (in percentage) of the unbalance of the disk space utilization among all servers. The average disk space utilization is calculated by dividing the total space by the number of servers. server balancer will start a rebalancing task when the deviation between the average usage and some server load is greater than this tolerance Range: [1, 100] in percentage | LOAD_BALANCE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | server_balance_critical_disk_waterlevel | None | 80 | disk water level to determine server balance strategy | LOAD_BALANCE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | balancer_log_interval | None | 1m | the time interval between logging the load-balancing task\'s statistics. Range: [1s, +∞) | LOAD_BALANCE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | balancer_task_timeout | None | 20m | the time to execute the load-balancing task before it is terminated. Range: [1s, +∞) | LOAD_BALANCE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | balancer_tolerance_percentage | None | 10 | specifies the tolerance (in percentage) of the unbalance of the disk space utilization among all units. The average disk space utilization is calculated by dividing the total space by the number of units. For example, say balancer_tolerance_percentage is set to 10 and a tenant has two units in the system, the average disk use for each unit should be about the same, thus 50% of the total value. Therefore, the system will start a rebalancing task when any unit\'s disk space goes beyond +-10% of the average usage. Range: [1, 100) in percentage | LOAD_BALANCE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | balancer_idle_time | None | 10s | the time interval between the schedules of the load-balancing task. Range: [10s, +∞) | LOAD_BALANCE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | enable_rebalance | None | True | specifies whether the load-balancing is turned on. Value: True:turned on False: turned off | LOAD_BALANCE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | enable_rereplication | None | True | specifies whether the auto-replication is turned on. Value: True:turned on False: turned off | LOAD_BALANCE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | resource_hard_limit | None | 100 | system utilization should not be large than resource_hard_limit | LOAD_BALANCE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | log_disk_percentage | None | 10 | the percentage of disk space used by the log files. Range: [0,99] in integer;only effective when parameter log_disk_size is 0;when log_disk_percentage is 0: a) if the data and the log are on the same disk, means log_disk_percentage = 30 b) if the data and the log are on the different disks, means log_disk_perecentage = 90 | LOGSERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | log_disk_size | None | 0 | the size of disk space used by the log files. Range: [0, +∞) | LOGSERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | recyclebin_object_expire_time | None | 0s | recyclebin object expire time, default 0 that means auto purge recyclebin off. Range: [0s, +∞) | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | ob_event_history_recycle_interval | None | 7d | the time to recycle event history. Range: [1d, 180d] | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | enable_major_freeze | None | True | specifies whether major_freeze function is turned on. Value: True:turned on; False: turned off | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | enable_ddl | None | True | specifies whether DDL operation is turned on. Value: True:turned on; False: turned off | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | min_observer_version | None | 4.1.0.0 | the min observer version | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | tablet_meta_table_check_interval | None | 30m | the time interval that observer compares tablet meta table with local ls replica info and make adjustments to ensure the correctness of tablet meta table. Range: [1m,+∞) | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | ls_meta_table_check_interval | None | 1s | the time interval that observer compares ls meta table with local ls replica info and make adjustments to ensure the correctness of ls meta table. Range: [1ms,+∞) | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | tablet_meta_table_scan_batch_count | None | 999 | the number of tablet replica info that will be read by each request on the tablet-related system tables during procedures such as load-balancing, daily merge, election and etc. Range:(0,65536] | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | rootservice_ready_check_interval | None | 3s | the interval between the schedule of the rootservice restart task while restart failed Range: [100000us, 1m] | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | server_check_interval | None | 30s | the time interval between schedules of a task that examines the __all_server table. Range: [1s, +∞) | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | migration_disable_time | None | 3600s | the duration in which the observer stays in the \'block_migrate_in\' status, which means it is not allowed to migrate into the server. Range: [1s, +∞) | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | server_permanent_offline_time | None | 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 | | zone2 | observer | 192.168.1.77 | 19512 | enable_sys_table_ddl | None | False | specifies whether a \'system\' table is allowed be to created manually. Value: True: allowed; False: not allowed | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | rootservice_async_task_queue_size | None | 16384 | the size of the queue for all asynchronous tasks at rootserver. Range: [8, 131072] in integer | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | rootservice_async_task_thread_count | None | 4 | maximum of threads allowed for executing asynchronous task at rootserver. Range: [1, 10] | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | lease_time | None | 10s | Lease for current heartbeat. If the root server does not received any heartbeat from an observer in lease_time seconds, that observer is considered to be offline. Not recommended for modification. Range: [1s, 5m] | ROOT_SERVICE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | max_px_worker_count | None | 64 | maximum parallel execution worker count can be used for all parallel requests. Range:[0, 65535] | TENANT | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | plan_cache_evict_interval | None | 1s | time interval for periodic plan cache eviction. Range: [0s, +∞) | TENANT | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | plan_cache_low_watermark | None | 1500M | (don't use now) memory usage at which plan cache eviction will be stopped. Range: [0, plan_cache_high_watermark) | TENANT | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | plan_cache_high_watermark | None | 2000M | (don't use now) memory usage at which plan cache eviction will be trigger immediately. Range: [0, +∞) | TENANT | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | memstore_limit_percentage | None | 50 | used in calculating the value of MEMSTORE_LIMIT parameter: memstore_limit_percentage = memstore_limit / memory_size，memory_size, where MEMORY_SIZE is determined when the tenant is created. Range: (0, 100) | TENANT | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | px_workers_per_cpu_quota | None | 10 | the ratio(integer) between the number of system allocated px workers vs the maximum number of threads that can be scheduled concurrently. Range: [0, 20] | TENANT | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | global_write_halt_residual_memory | None | 30 | disable write to memstore when observer memstore free memory(plus memory hold by blockcache) lower than this limit, Range: (0, 100)limit calc by (memory_limit - system_memory) * global_write_halt_residual_memory/100 | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | token_reserved_percentage | None | 30 | specifies the amount of token increase allocated to a tenant based on his consumption from the last round (without exceeding his upper limit). Range: [0, 100] in percentage | TENANT | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | large_query_threshold | None | 5s | threshold for execution time beyond which a request may be paused and rescheduled as a \'large request\'. Range: [1ms, +∞) | TENANT | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | large_query_worker_percentage | None | 30 | the percentage of the workers reserved to serve large query request. Range: [0, 100] in percentage | TENANT | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | workers_per_cpu_quota | None | 10 | the ratio(integer) between the number of system allocated workers vs the maximum number of threads that can be scheduled concurrently. Range: [2, 20] | TENANT | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | location_cache_cpu_quota | None | 5 | the number of vCPUs allocated for the requests regarding location info of the core tables. Range: [0,10] in integer | TENANT | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | server_cpu_quota_max | None | 1 | the number of maximal vCPUs allocated to the server tenant(a special internal tenant that exists on every observer). Range: [1, 16] | TENANT | CLUSTER | DEFAULT | STATIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | server_cpu_quota_min | None | 1 | the number of minimal vCPUs allocated to the server tenant(a special internal tenant that exists on every observer). Range: [1, 16] | TENANT | CLUSTER | DEFAULT | STATIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | tenant_cpu_variation_per_server | None | 50 | the percentage variation for any tenant\'s CPU quota allocation on each observer. The default value is 50(%). Range: [0, 100] in percentage | TENANT | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | tableapi_transport_compress_func | None | none | compressor used for tableAPI query result. Values: none, lz4_1.0, snappy_1.0, zlib_1.0, zstd_1.0 zstd 1.3.8 | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | enable_sql_operator_dump | None | True | specifies whether sql operators (sort/hash join/material/window function/interm result/...) allowed to write to disk | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | autoinc_cache_refresh_interval | None | 3600s | auto-increment service cache refresh sync_value in this interval, with default 3600s. Range: [100ms, +∞) | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | memory_chunk_cache_size | None | 0M | the maximum size of memory cached by memory chunk cache. Range: [0M,], 0 stands for adaptive | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | cache_wash_threshold | None | 1G | size of remaining memory at which cache eviction will be triggered. Range: [0,+∞) | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | memory_limit_percentage | None | 80 | the size of the memory reserved for internal use(for testing purpose). Range: [10, 90] | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | enable_syslog_recycle | None | False | specifies whether log file recycling is turned on. Value: True：turned on; False: turned off | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | enable_syslog_wf | None | 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 | | zone2 | observer | 192.168.1.77 | 19512 | enable_async_syslog | None | True | specifies whether use async log for observer.log, elec.log and rs.log | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | max_syslog_file_count | None | 0 | specifies the maximum number of the log files that can co-exist before the log file recycling kicks in. Each log file can occupy at most 256MB disk space. When this value is set to 0, no log file will be removed. Range: [0, +∞) in integer | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | syslog_io_bandwidth_limit | None | 100000MB | Syslog IO bandwidth limitation, exceeding syslog would be truncated. Use 0 to disable ERROR log. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | syslog_level | None | INFO | specifies the current level of logging. There are DEBUG, TRACE, INFO, WARN, USER_ERR, ERROR, six different log levels. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | obconfig_url | None | | URL for OBConfig service | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | cluster_id | None | 1 | ID of the cluster | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | cluster | None | ob2.xiaochu.yh.192.168.1.77 | Name of the cluster | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | rootservice_list | None | 192.168.1.77:19510:19511;192.168.1.77:19512:19513 | a list of servers against which election candidate is checked for validation | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | weak_read_version_refresh_interval | None | 100ms | the time interval to refresh cluster weak read version Range: [50ms, +∞) | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | default_compress | None | archive | default compress strategy for create new table within oracle mode | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | default_row_format | None | dynamic | default row format in mysql mode | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | default_compress_func | None | zstd_1.3.8 | default compress function name for create new table, values: none, lz4_1.0, snappy_1.0, zlib_1.0, zstd_1.0, zstd_1.3.8 | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | schema_history_expire_time | None | 1d | the hour of expire time for schema history, from 1hour to 30days, with default 7days. Range: [1h, 30d] | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | enable_upgrade_mode | None | False | specifies whether upgrade mode is turned on. If turned on, daily merger and balancer will be disabled. Value: True: turned on; False: turned off; | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | enable_perf_event | None | True | specifies whether to enable perf event feature. The default value is True. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | dead_socket_detection_timeout | None | 3s | specify a tcp_user_timeout for RFC5482. A zero value makes the option disabled, Range: [0, 2h] | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | debug_sync_timeout | None | 0 | Enable the debug sync facility and optionally specify a default wait timeout in micro seconds. A zero value keeps the facility disabled, Range: [0, +∞] | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | enable_rich_error_msg | None | False | specifies whether add ip:port, time and trace id to user error message. The default value is FALSE. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | enable_record_trace_id | None | True | specifies whether record app trace id is turned on. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | enable_sql_audit | None | True | specifies whether SQL audit is turned on. The default value is TRUE. Value: TRUE: turned on FALSE: turned off | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | max_string_print_length | None | 500 | truncate very long string when printing to log file. Range:[0,] | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | system_trace_level | None | 1 | system trace log level, 0:none, 1:standard, 2:debug. The default log level for trace log is 1 | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | enable_record_trace_log | None | True | specifies whether to always record the trace log. The default value is True. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | trace_log_slow_query_watermark | None | 100ms | the threshold of execution time (in milliseconds) of a query beyond which it is considered to be a \'slow query\'. Range: [1ms,+∞) | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | trace_log_sampling_interval | None | 10ms | the time interval for periodically printing log info in trace log. When force_trace_log is set to FALSE, for each time interval specifies by sampling_trace_log_interval, logging info regarding ‘slow query’ and ‘white list’ will be printed out. Range: [0ms,+∞) | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | cpu_count | None | 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 | | zone2 | observer | 192.168.1.77 | 19512 | system_memory | None | 5G | the memory reserved for internal use which cannot be allocated to any outer-tenant, and should be determined to guarantee every server functions normally. Range: [0M,) | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | rootservice_memory_limit | None | 2G | max memory size which can be used by rs tenant The default value is 2G. Range: [2G,) | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | memory_limit | None | 10G | the size of the memory reserved for internal use(for testing purpose), 0 means follow memory_limit_percentage. Range: 0, [4G,). | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | tenant_task_queue_size | None | 65536 | the size of the task queue for each tenant. Range: [1024,+∞) | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | rdma_io_thread_count | None | 0 | the number of RDMA I/O threads for Libreasy. Range: [0, 8] in integer, 0 stands for RDMA being disabled. | OBSERVER | CLUSTER | DEFAULT | STATIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | high_priority_net_thread_count | None | 0 | the number of rpc I/O threads for high priority messages, 0 means set off. Range: [0, 64] in integer | OBSERVER | CLUSTER | DEFAULT | STATIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | net_thread_count | None | 4 | the number of rpc/mysql I/O threads for Libeasy. Range: [0, 64] in integer, 0 stands for max(6, CPU_NUM/8) | OBSERVER | CLUSTER | DEFAULT | STATIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | internal_sql_execute_timeout | None | 30s | the number of microseconds an internal DML request is permitted to execute before it is terminated. Range: [1000us, 1h] | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | zone | None | zone2 | specifies the zone name | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | devname | None | eth0 | name of network adapter | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | mysql_port | None | 19513 | port number for mysql connection. Range: (1024, 65536) in integer | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | rpc_port | None | 19512 | the port number for RPC protocol. Range: (1024, 65536) in integer | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | leak_mod_to_check | None | NONE | the name of the module under memory leak checks | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | config_additional_dir | None | etc2;etc3 | additional directories of configure file | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | memory_reserved | None | 500M | the size of the system memory reserved for emergency internal use. Range: [10M, total size of memory] | SSTABLE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | datafile_disk_percentage | None | 50 | the percentage of disk space used by the data files. Range: [0,99] in integer | SSTABLE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | datafile_size | None | 20G | size of the data file. Range: [0, +∞) | SSTABLE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | redundancy_level | None | NORMAL | EXTERNAL: use extrernal redundancyNORMAL: tolerate one disk failureHIGH: tolerate two disk failure if disk count is enough | SSTABLE | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | data_dir | None | /home/xiaochu.yh/deploy//ob2.obs1/store | the directory for the data file | SSTABLE | CLUSTER | DEFAULT | READONLY | | zone2 | observer | 192.168.1.77 | 19512 | enable_user_defined_rewrite_rules | None | False | specify whether the user defined rewrite rules are enabled. Value: True: enable False: disable | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | query_response_time_range_base | None | 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 | | zone2 | observer | 192.168.1.77 | 19512 | query_response_time_flush | None | False | Flush QUERY_RESPONSE_TIME table and re-read query_response_time_range_baseThe default value is False. Value: TRUE: trigger flush FALSE: do not trigger | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | query_response_time_stats | None | 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 | | zone2 | observer | 192.168.1.77 | 19512 | default_enable_extended_rowid | None | False | specifies whether to create table as extended rowid mode or not | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | ob_query_switch_leader_retry_timeout | None | 0ms | max time spend on retry caused by leader swith or network disconnectionRange: [0ms, +∞) | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | default_auto_increment_mode | None | order | specifies default auto-increment mode, default is 'order' | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | enable_sql_extension | None | True | specifies whether to allow use some oracle mode features in mysql mode | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | job_queue_processes | None | 1000 | specifies the maximum number of job slaves per instance that can be created for the execution of DBMS_JOB jobs and Oracle Scheduler (DBMS_SCHEDULER) jobs. | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | ob_proxy_readonly_transaction_routing_policy | None | False | Proxy route policy for readonly sql: whether regard begining read only stmts as in transaction | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | connection_control_max_connection_delay | None | 2147483647 | The maximum delay in milliseconds for server response to failed connection attempts, if connection_control_failed_connections_threshold is greater than zero | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | connection_control_min_connection_delay | None | 1000 | The minimum delay in milliseconds for server response to failed connection attempts, if connection_control_failed_connections_threshold is greater than zero. | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | connection_control_failed_connections_threshold | None | 0 | The number of consecutive failed connection attempts permitted to accountsbefore the server adds a delay for subsequent connection attempts | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | open_cursors | None | 50 | specifies the maximum number of open cursors a session can have at once.can use this parameter to prevent a session from opening an excessive number of cursors.Range: [0, 65535] in integer | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | ob_ssl_invited_common_names | None | NONE | when server use ssl, use it to control client identity with ssl subject common name. default NONE | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | plsql_warnings | None | DISABLE::ALL | enables or disables the reporting of warning messages by thePL/SQL compiler, and specifies which warning messages to show as errors | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | plsql_v2_compatibility | None | False | allows some abnormal behavior that Version 8 disallows, not available | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | plsql_optimize_level | None | 1 | specifies the optimization level that will be used tocompile PL/SQL library units. The higher the setting of this parameter, the more effortthe compiler makes to optimize PL/SQL library units | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | plsql_debug | None | False | specifies whether or not PL/SQL library units will be compiled for debugging | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | plsql_code_type | None | native | specifies the compilation mode for PL/SQL library units | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | plsql_ccflags | None | | provides a mechanism that allows PL/SQL programmers to controlconditional compilation of each PL/SQL library unit independently | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | tde_method | None | none | none : transparent encryption is none, none means cannot use tde, internal : transparent encryption is in the form of internal tables, bkmi : transparent encryption is in the form of external bkmi | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | external_kms_info | None | | when using the external key management center, this parameter will store some key management information | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | ob_enable_batched_multi_statement | None | False | enable use of batched multi statement | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | audit_trail | None | None | enables or disables database auditing, support NONE;OS;DB;DB,EXTENDED;DB_EXTENDED | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | audit_sys_operations | None | False | whether trace sys user operations | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | sql_work_area | None | 1G | Work area memory limitation for tenant | OBSERVER | TENANT | DEFAULT | STATIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | ob_compaction_schedule_interval | None | 10s | the time interval to schedule compaction, Range: [3s,5m]Range: [3s, 5m] | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | major_compact_trigger | None | 0 | specifies how many minor freeze should be triggered between two major freeze, Range: [0,65535] in integer | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | minor_compact_trigger | None | 2 | minor_compact_trigger, Range: [0,16] in integer | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | ha_low_thread_score | None | 0 | the current work thread score of high availability low thread. Range: [0,100] in integer. Especially, 0 means default value | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | ha_mid_thread_score | None | 0 | the current work thread score of high availability mid thread. Range: [0,100] in integer. Especially, 0 means default value | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | ha_high_thread_score | None | 0 | the current work thread score of high availability high thread. Range: [0,100] in integer. Especially, 0 means default value | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | compaction_high_thread_score | None | 0 | the current work thread score of high priority compaction. Range: [0,100] in integer. Especially, 0 means default value | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | compaction_mid_thread_score | None | 0 | the current work thread score of middle priority compaction. Range: [0,100] in integer. Especially, 0 means default value | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | compaction_low_thread_score | None | 0 | the current work thread score of low priority compaction. Range: [0,100] in integer. Especially, 0 means default value | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | io_category_config | None | other: 100,100,100 | configs for different category of io request. specify with category name, minimal percentage, maximal percentage, weight percentage. devide the category with semicolon | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | enable_early_lock_release | None | True | enable early lock release | OBSERVER | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | merger_check_interval | None | 10s | the time interval between the schedules of the task that checks on the progress of MERGE for each zone. Range: [10s, 60m] | DAILY_MERGE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | major_freeze_duty_time | None | 02:00 | the start time of system daily merge procedure. Range: [00:00, 24:00) | DAILY_MERGE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | log_disk_utilization_threshold | None | 80 | log disk utilization threshold before reuse log files, should be smaller than log_disk_utilization_limit_threshold. Range: [10, 100) | LOGSERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | log_disk_utilization_limit_threshold | None | 95 | maximum of log disk usage percentage before stop submitting or receiving logs, should be bigger than log_disk_utilization_threshold. Range: [80, 100] | LOGSERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | compatible | None | 4.1.0.0 | compatible version for persisted data | ROOT_SERVICE | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | workarea_size_policy | None | AUTO | policy used to size SQL working areas (MANUAL/AUTO) | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | default_progressive_merge_num | None | 0 | default progressive_merge_num when tenant create tableRange:[0,) | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | writing_throttling_maximum_duration | None | 2h | maximum duration of writting throttling(in minutes), max value is 3 days | TRANS | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | writing_throttling_trigger_percentage | None | 60 | the threshold of the size of the mem store when writing_limit will be triggered. Rang:(0，100]. setting 100 means turn off writing limit | TRANS | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | freeze_trigger_percentage | None | 20 | the threshold of the size of the mem store when freeze will be triggered. Rang:(0，100) | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | undo_retention | None | 1800 | the low threshold value of undo retention. The system retains undo for at least the time specified in this config. Range: [0, 4294967295] | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | cpu_quota_concurrency | None | 4 | max allowed concurrency for 1 CPU quota. Range: [1,10] | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | enable_monotonic_weak_read | None | False | specifies observer supportting atomicity and monotonic order read | TENANT | TENANT | DEFAULT | DYNAMIC_EFFECTIVE | | zone2 | observer | 192.168.1.77 | 19512 | max_stale_time_for_weak_consistency | None | 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 | +-------+----------+--------------+----------+-------------------------------------------------+-----------+---------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+---------+---------+-------------------+
| SVR_IP | SVR_PORT | REQUEST_ID | SQL_EXEC_ID | TRACE_ID | SID | CLIENT_IP | CLIENT_PORT | TENANT_ID | EFFECTIVE_TENANT_ID | TENANT_NAME | USER_ID | USER_NAME | USER_CLIENT_IP | DB_ID | DB_NAME | SQL_ID | QUERY_SQL | PLAN_ID | AFFECTED_ROWS | RETURN_ROWS | PARTITION_CNT | RET_CODE | QC_ID | DFO_ID | SQC_ID | WORKER_ID | EVENT | P1TEXT | P1 | P2TEXT | P2 | P3TEXT | P3 | LEVEL | WAIT_CLASS_ID | WAIT_CLASS | STATE | WAIT_TIME_MICRO | TOTAL_WAIT_TIME_MICRO | TOTAL_WAITS | RPC_COUNT | PLAN_TYPE | IS_INNER_SQL | IS_EXECUTOR_RPC | IS_HIT_PLAN | REQUEST_TIME | ELAPSED_TIME | NET_TIME | NET_WAIT_TIME | QUEUE_TIME | DECODE_TIME | GET_PLAN_TIME | EXECUTE_TIME | APPLICATION_WAIT_TIME | CONCURRENCY_WAIT_TIME | USER_IO_WAIT_TIME | SCHEDULE_TIME | ROW_CACHE_HIT | BLOOM_FILTER_CACHE_HIT | BLOCK_CACHE_HIT | DISK_READS | RETRY_CNT | TABLE_SCAN | CONSISTENCY_LEVEL | MEMSTORE_READ_ROW_COUNT | SSSTORE_READ_ROW_COUNT | REQUEST_MEMORY_USED | EXPECTED_WORKER_COUNT | USED_WORKER_COUNT | REQUEST_TYPE | IS_BATCHED_MULTI_STMT | OB_TRACE_INFO | PLAN_HASH |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 192.168.1.77 | 19512 | 56 | 1416594 | Y4C360B9E1F4D-0005F192D9891CC0-0-0 | 3221753044 | 192.168.1.77 | 37834 | 1004 | 1004 | 500002 | 192.168.1.77 | 500001 | 25EC6726A1F4F2D304E197D1D7AA5BBB | 463 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | default condition wait | address | 140191709688216 | 0 | 0 | 0 | 104 | CONCURRENCY | WAITED SHORT TIME | 1105 | 5116 | 9 | 55 | 3 | 0 | 1 | 1 | 1672995463222657 | 64627 | 0 | 0 | 0 | 0 | 0 | 64627 | 0 | 0 | 0 | 0 | 0 | 0 | 45 | 0 | 0 | 0 | -1 | 0 | 250000 | 3792104 | 0 | 0 | 4 | 0 | None | 0 | ||||||
| 192.168.1.77 | 19512 | 57 | 1416595 | Y4C360B9E1F4D-0005F192D9891CC0-0-0 | 3221753043 | 192.168.1.77 | 37834 | 1004 | 1004 | 500002 | 192.168.1.77 | 500001 | 25EC6726A1F4F2D304E197D1D7AA5BBB | 463 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | px loop condition wait | address | 140192507449304 | 0 | 0 | 0 | 104 | CONCURRENCY | WAITED SHORT TIME | 2530 | 18610 | 37 | 56 | 3 | 0 | 1 | 1 | 1672995463222664 | 76204 | 0 | 0 | 0 | 0 | 0 | 76204 | 0 | 0 | 0 | 0 | 0 | 0 | 45 | 0 | 0 | 0 | -1 | 0 | 250000 | 3789547 | 0 | 0 | 4 | 0 | None | 0 | ||||||
| 192.168.1.77 | 19512 | 58 | 1416612 | Y4C360B9E1F4D-0005F192D9891CC0-0-0 | 3221753049 | 192.168.1.77 | 37834 | 1004 | 1004 | 500002 | 192.168.1.77 | 500001 | 25EC6726A1F4F2D304E197D1D7AA5BBB | 463 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | px loop condition wait | address | 140192507449304 | 0 | 0 | 0 | 104 | CONCURRENCY | WAITED SHORT TIME | 1061 | 3599 | 7 | 55 | 3 | 0 | 1 | 1 | 1672995463302248 | 55678 | 0 | 0 | 0 | 0 | 0 | 55678 | 0 | 0 | 0 | 0 | 0 | 0 | 45 | 0 | 0 | 0 | -1 | 0 | 250000 | 3692353 | 0 | 0 | 4 | 0 | None | 0 | ||||||
| 192.168.1.77 | 19512 | 59 | 1416616 | Y4C360B9E1F4D-0005F192D9891CC0-0-0 | 3221753050 | 192.168.1.77 | 37834 | 1004 | 1004 | 500002 | 192.168.1.77 | 500001 | 25EC6726A1F4F2D304E197D1D7AA5BBB | 463 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | px loop condition wait | address | 140191709690448 | 0 | 0 | 0 | 104 | CONCURRENCY | WAITED SHORT TIME | 7638 | 24357 | 21 | 55 | 3 | 0 | 1 | 1 | 1672995463306800 | 89639 | 0 | 0 | 0 | 0 | 0 | 89639 | 0 | 0 | 0 | 0 | 0 | 0 | 45 | 0 | 0 | 0 | -1 | 0 | 250000 | 3684161 | 0 | 0 | 4 | 0 | None | 0 | ||||||
| 192.168.1.77 | 19512 | 60 | 1416620 | Y4C360B9E1F4D-0005F192D9891CC0-0-0 | 3221753046 | 192.168.1.77 | 37834 | 1004 | 1004 | 500002 | 192.168.1.77 | 500001 | 25EC6726A1F4F2D304E197D1D7AA5BBB | 463 | 0 | 0 | 0 | 0 | 1 | 2 | 1 | 0 | sleep: dtl process channel sleep wait | sleep_interval | 1000 | 0 | 0 | 0 | 104 | CONCURRENCY | WAITED SHORT TIME | 4047 | 120323 | 139 | 1 | 3 | 0 | 1 | 1 | 1672995463223369 | 216632 | 0 | 0 | 0 | 0 | 0 | 216632 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -1 | 0 | 0 | 9706669 | 0 | 0 | 4 | 0 | None | 0 | ||||||
| 192.168.1.77 | 19512 | 65 | 1499950 | Y4C360B9E1F4D-0005F192D9891CC0-0-0 | 3221753047 | 192.168.1.77 | 37834 | 1004 | 1004 | 500002 | 192.168.1.77 | 500001 | 25EC6726A1F4F2D304E197D1D7AA5BBB | 463 | 0 | 0 | 0 | 0 | 1 | 2 | 1 | 1 | px loop condition wait | address | 140191710334608 | 0 | 0 | 0 | 104 | CONCURRENCY | WAITED SHORT TIME | 2277 | 65017 | 87 | 15 | 3 | 0 | 1 | 1 | 1672995463223402 | 392515717 | 0 | 0 | 0 | 0 | 0 | 392515717 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -1 | 0 | 0 | 6547312 | 0 | 0 | 4 | 0 | None | 0 | ||||||
| 192.168.1.77 | 19510 | 286 | 3132147 | Y4C360B9E1F4D-0005F192D9891CC0-0-0 | 3221497511 | 192.168.1.77 | 37834 | 1004 | 1004 | 500002 | 192.168.1.77 | 500001 | 25EC6726A1F4F2D304E197D1D7AA5BBB | 463 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | default condition wait | address | 140343089451416 | 0 | 0 | 0 | 104 | CONCURRENCY | WAITED SHORT TIME | 686 | 3059 | 6 | 53 | 3 | 0 | 1 | 1 | 1672995463223298 | 57050 | 0 | 0 | 0 | 0 | 0 | 57050 | 0 | 0 | 0 | 0 | 0 | 0 | 45 | 0 | 0 | 0 | -1 | 0 | 250000 | 3631657 | 0 | 0 | 4 | 0 | None | 0 | ||||||
| 192.168.1.77 | 19510 | 287 | 3132148 | Y4C360B9E1F4D-0005F192D9891CC0-0-0 | 3221497510 | 192.168.1.77 | 37834 | 1004 | 1004 | 500002 | 192.168.1.77 | 500001 | 25EC6726A1F4F2D304E197D1D7AA5BBB | 463 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | default condition wait | address | 140343237298248 | 0 | 0 | 0 | 104 | CONCURRENCY | WAITED SHORT TIME | 1339 | 6507 | 19 | 53 | 3 | 0 | 1 | 1 | 1672995463223250 | 59899 | 0 | 0 | 0 | 0 | 0 | 59899 | 0 | 0 | 0 | 0 | 0 | 0 | 45 | 0 | 0 | 0 | -1 | 0 | 250000 | 3627505 | 0 | 0 | 4 | 0 | None | 0 | ||||||
| 192.168.1.77 | 19510 | 288 | 3132166 | Y4C360B9E1F4D-0005F192D9891CC0-0-0 | 3221497536 | 192.168.1.77 | 37834 | 1004 | 1004 | 500002 | 192.168.1.77 | 500001 | 25EC6726A1F4F2D304E197D1D7AA5BBB | 463 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | default condition wait | address | 140343285180488 | 0 | 0 | 0 | 104 | CONCURRENCY | WAITED SHORT TIME | 1739 | 6481 | 14 | 55 | 3 | 0 | 1 | 1 | 1672995463300028 | 48430 | 0 | 0 | 0 | 0 | 0 | 48430 | 0 | 0 | 0 | 0 | 0 | 0 | 45 | 0 | 0 | 0 | -1 | 0 | 250000 | 3711976 | 0 | 0 | 4 | 0 | None | 0 | ||||||
| 192.168.1.77 | 19510 | 289 | 3132184 | Y4C360B9E1F4D-0005F192D9891CC0-0-0 | 3221497538 | 192.168.1.77 | 37834 | 1004 | 1004 | 500002 | 192.168.1.77 | 500001 | 25EC6726A1F4F2D304E197D1D7AA5BBB | 463 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | px loop condition wait | address | 140343826034648 | 0 | 0 | 0 | 104 | CONCURRENCY | WAITED SHORT TIME | 2390 | 37935 | 41 | 55 | 3 | 0 | 1 | 1 | 1672995463300123 | 81699 | 0 | 0 | 0 | 0 | 0 | 81699 | 0 | 0 | 0 | 0 | 0 | 0 | 45 | 0 | 0 | 0 | -1 | 0 | 250000 | 3698342 | 0 | 0 | 4 | 0 | None | 0 | ||||||
| 192.168.1.77 | 19510 | 290 | 3132195 | Y4C360B9E1F4D-0005F192D9891CC0-0-0 | 3221497514 | 192.168.1.77 | 37834 | 1004 | 1004 | 500002 | 192.168.1.77 | 500001 | 25EC6726A1F4F2D304E197D1D7AA5BBB | 463 | 0 | 0 | 0 | 0 | 1 | 2 | 0 | 1 | sleep: dtl process channel sleep wait | sleep_interval | 1000 | 0 | 0 | 0 | 104 | CONCURRENCY | WAITED SHORT TIME | 7677 | 122228 | 108 | 0 | 3 | 0 | 1 | 1 | 1672995463224012 | 215119 | 0 | 0 | 0 | 0 | 0 | 215119 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -1 | 0 | 0 | 4276472 | 0 | 0 | 4 | 0 | None | 0 | ||||||
| 192.168.1.77 | 19510 | 303 | 3284183 | Y4C360B9E1F4D-0005F192D9891CC0-0-0 | 3221497513 | 192.168.1.77 | 37834 | 1004 | 1004 | 500002 | 192.168.1.77 | 500001 | 25EC6726A1F4F2D304E197D1D7AA5BBB | 463 | 0 | 0 | 0 | 0 | 1 | 2 | 0 | 0 | row store disk write | fd | 2064384 | offset | 0 | size | 0 | 0 | 108 | USER_IO | WAITED SHORT TIME | 2951 | 40794 | 73 | 26 | 3 | 0 | 1 | 1 | 1672995463224051 | 384430747 | 0 | 0 | 0 | 0 | 0 | 384430747 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -1 | 0 | 0 | 9666342 | 0 | 0 | 4 | 0 | None | 0 | ||||
| 192.168.1.77 | 19510 | 304 | 3132125 | Y4C360B9E1F4D-0005F192D9891CC0-0-0 | 3221495503 | 192.168.1.77 | 37834 | 1004 | 1004 | mysql | 500002 | admin | 192.168.1.77 | 500001 | test | 25EC6726A1F4F2D304E197D1D7AA5BBB | select /*+ parallel(4) */ count(*) from (select a.c1 from t1 a, t1 b where a.c2 = b.c3) | 463 | 0 | 1 | 8 | 0 | 0 | 0 | 0 | 0 | px loop condition wait | address | 140342512307856 | 0 | 0 | 0 | 104 | CONCURRENCY | WAITED KNOWN TIME | 32767 | 392135290 | 355935 | 16 | 3 | 0 | 0 | 0 | 1672995463219203 | 392520309 | 0 | 2 | 26 | 0 | 2339 | 392517924 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 3 | 0 | 0 | 1889840 | 8 | 8 | 2 | 0 | None | 2265821375360871887 |
SELECT SQL_PLAN_LINE_ID OP_ID, IF(EVENT = '', 'CPU + WAIT FOR CPU', EVENT) AS EVENT, WAIT_CLASS, COUNT(1) EVENT_CNT, ROUND(COUNT(1) * 100 / SUM(COUNT(1)) OVER (), 2) AS Percent, MAX(P1TEXT) P1TEXT, MAX(P1) P1, MAX(P2TEXT) P2TEXT, MAX(P2) P2, MAX(P3TEXT) P3TEXT, MAX(P3) P3 FROM OCEANBASE.GV$ACTIVE_SESSION_HISTORY A WHERE TRACE_ID = 'Y4C360B9E1F4D-0005F192D9891CC0-0-0' GROUP BY A.SQL_PLAN_LINE_ID, A.EVENT, A.WAIT_CLASS ORDER BY 1 ASC, 4 DESC +-------+------------------------+-------------+-----------+---------+---------+-----------------+--------+----+--------+----+ | OP_ID | EVENT | WAIT_CLASS | EVENT_CNT | Percent | P1TEXT | P1 | P2TEXT | P2 | P3TEXT | P3 | +-------+------------------------+-------------+-----------+---------+---------+-----------------+--------+----+--------+----+ | 1 | px loop condition wait | CONCURRENCY | 393 | 33.56 | address | 140342512307856 | | 0 | | 0 | | 3 | CPU + WAIT FOR CPU | OTHER | 92 | 7.86 | | 0 | | 0 | | 0 | | 4 | CPU + WAIT FOR CPU | OTHER | 686 | 58.58 | | 0 | | 0 | | 0 | +-------+------------------------+-------------+-----------+---------+---------+-----------------+--------+----+--------+----+
| AVG_STAT_2 | AVG_STAT_3 | MIN_FIRST_REFRESH_TIME | AVG_STAT_6 | AVG_STAT_4 | AVG_STAT_5 | MIN_FIRST_CHANGE_TS | AVG_CHANGE_TIME | MY_DB_TIME | PLAN_OPERATION | AVG_STAT_1 | OTHERSTAT_5_ID | AVG_REFRESH_TIME | PLAN_DEPTH | OTHERSTAT_6_ID | OTHERSTAT_3_ID | MAX_REFRESH_TIME | MY_IO_TIME | MAX_STAT_1 | MAX_STAT_2 | MAX_STAT_3 | MAX_STAT_4 | MAX_STAT_5 | MAX_STAT_6 | OTHERSTAT_2_ID | SUM_STAT_1 | MAX_CHANGE_TIME | TOTAL_OUTPUT_ROWS | TOTAL_RESCAN_TIMES | OTHERSTAT_1_ID | MAX_LAST_REFRESH_TS | SKEWNESS | MY_CPU_TIME | EST_ROWS | SUM_STAT_3 | SUM_STAT_2 | SUM_STAT_5 | SUM_STAT_4 | MIN_CHANGE_TIME | SUM_STAT_6 | MIN_STAT_6 | MIN_STAT_4 | MIN_STAT_5 | MIN_STAT_2 | MIN_STAT_3 | MIN_STAT_1 | PARALLEL | MAX_LAST_REFRESH_TIME | MAX_LAST_CHANGE_TIME | MAX_LAST_CHANGE_TS | MIN_FIRST_REFRESH_TS | MIN_FIRST_CHANGE_TIME | MIN_REFRESH_TIME | OTHERSTAT_4_ID | PLAN_LINE_ID |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0.0000 | 0.0000 | 2023-01-06 16:57:43.221552 | 0.0000 | 0.0000 | 0.0000 | 1672995855.739426 | 0.0000 | 0.0000 | PHY_SCALAR_AGGREGATE | 0.0000 | 0 | 392517874.0000 | 0 | 0 | 0 | 392517874 | 0.0000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1672995855.739426 | 0.0000 | 0.0000 | None | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 2023-01-06 17:04:15.739426 | 2023-01-06 17:04:15.739426 | 1672995855.739426 | 1672995463.221552 | 2023-01-06 17:04:15.739426 | 392517874 | 0 | 0 |
| 1672995855738367.0000 | 4.0000 | 2023-01-06 16:57:43.221552 | 0.0000 | 0.0000 | 0.0000 | 1672995855.738367 | 0.0000 | 392.5035 | PHY_PX_FIFO_COORD | 0.0000 | 8 | 392517874.0000 | 1 | 7 | 19 | 392517874 | 392.2996 | 0 | 1672995855738367 | 4 | 0 | 0 | 0 | 20 | 0 | 0 | 2 | 0 | 0 | 1672995855.739426 | 0.0000 | 0.2038 | None | 4 | 1672995855738367 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1672995855738367 | 4 | 0 | 1 | 2023-01-06 17:04:15.739426 | 2023-01-06 17:04:15.738367 | 1672995855.738367 | 1672995463.221552 | 2023-01-06 17:04:15.738367 | 392517874 | 0 | 1 |
| 1672995657567471.0000 | 1.0000 | 2023-01-06 16:57:43.223357 | 0.0000 | 0.0000 | 0.0000 | 1672995847.653788 | 0.0000 | 0.1079 | PHY_PX_REDUCE_TRANSMIT | 0.0000 | 8 | 194344222.5000 | 2 | 7 | 19 | 392515749 | 0.0000 | 0 | 1672995855738074 | 1 | 0 | 0 | 0 | 20 | 0 | 0 | 2 | 0 | 0 | 1672995855.739106 | 0.0000 | 0.1079 | None | 4 | 6691982630269884 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1672995463438092 | 1 | 0 | 4 | 2023-01-06 17:04:15.739106 | 2023-01-06 17:04:15.738074 | 1672995855.738074 | 1672995463.223357 | 2023-01-06 17:04:07.653788 | 214436 | 0 | 2 |
| 0.0000 | 0.0000 | 2023-01-06 16:57:43.223357 | 0.0000 | 0.0000 | 0.0000 | 1672995847.653788 | 0.0000 | 19.9677 | PHY_MERGE_GROUP_BY | 0.0000 | 0 | 194344222.5000 | 3 | 21 | 0 | 392515749 | 0.0000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 1672995855.739106 | 0.0000 | 19.9677 | None | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 2023-01-06 17:04:15.739106 | 2023-01-06 17:04:15.738074 | 1672995855.738074 | 1672995463.223357 | 2023-01-06 17:04:07.653788 | 214436 | 0 | 3 |
| 0.0000 | 0.0000 | 2023-01-06 16:57:43.223357 | 38589.0000 | 147456.0000 | 2.2500 | 1672995463.422284 | 388245993.0000 | 174.2699 | PHY_HASH_JOIN | 0.0000 | 5 | 194344222.5000 | 4 | 6 | 3 | 392515749 | 0.0611 | 0 | 0 | 0 | 262144 | 4 | 51339 | 2 | 0 | 392260482 | 25738492256 | 0 | 1 | 1672995855.739106 | 0.0205 | 174.2087 | None | 0 | 0 | 9 | 589824 | 384231504 | 154356 | 25564 | 65536 | 1 | 0 | 0 | 0 | 4 | 2023-01-06 17:04:15.739106 | 2023-01-06 17:04:15.738074 | 1672995855.738074 | 1672995463.223357 | 2023-01-06 16:57:43.422284 | 214436 | 4 | 4 |
| 1672995463299587.0000 | 0.0000 | 2023-01-06 16:57:43.223357 | 0.0000 | 0.0000 | 0.0000 | 1672995463.225445 | 73376.7500 | 0.0361 | PHY_PX_FIFO_RECEIVE | 0.0000 | 8 | 194343964.5000 | 5 | 7 | 19 | 392514717 | 0.0090 | 0 | 1672995463300848 | 0 | 0 | 0 | 0 | 20 | 0 | 74158 | 1000000 | 0 | 0 | 1672995855.738074 | 0.0196 | 0.0270 | None | 0 | 6691981853198348 | 0 | 0 | 72701 | 0 | 0 | 0 | 0 | 1672995463298545 | 0 | 0 | 4 | 2023-01-06 17:04:15.738074 | 2023-01-06 16:57:43.300848 | 1672995463.300848 | 1672995463.223357 | 2023-01-06 16:57:43.225445 | 214436 | 0 | 5 |
| 1672995463286969.0000 | 108.7500 | 2023-01-06 16:57:43.222339 | 9.0000 | 0.0000 | 0.0000 | 1672995463.222339 | 64495.0000 | 0.0007 | PHY_PX_DIST_TRANSMIT | 0.0000 | 8 | 64495.0000 | 6 | 21 | 19 | 76206 | 0.0026 | 0 | 1672995463298545 | 109 | 0 | 0 | 36 | 20 | 0 | 76206 | 1000000 | 0 | 0 | 1672995463.298545 | 0.2445 | -0.0019 | None | 435 | 6691981853147876 | 0 | 0 | 57577 | 36 | 0 | 0 | 0 | 1672995463280186 | 108 | 0 | 4 | 2023-01-06 16:57:43.298545 | 2023-01-06 16:57:43.298545 | 1672995463.298545 | 1672995463.222339 | 2023-01-06 16:57:43.222339 | 57577 | 0 | 6 |
| 1.0000 | 0.0000 | 2023-01-06 16:57:43.222339 | 0.0000 | 0.0000 | 0.0000 | 1672995463.222339 | 63970.0000 | 0.0001 | PHY_GRANULE_ITERATOR | 0.0000 | 0 | 64495.0000 | 7 | 0 | 0 | 76206 | 0.0000 | 0 | 1 | 0 | 0 | 0 | 0 | 23 | 0 | 75129 | 1000000 | 0 | 22 | 1672995463.298545 | 0.2472 | 0.0001 | None | 0 | 4 | 0 | 0 | 56554 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 4 | 2023-01-06 16:57:43.298545 | 2023-01-06 16:57:43.297468 | 1672995463.297468 | 1672995463.222339 | 2023-01-06 16:57:43.222339 | 57577 | 0 | 7 |
| 0.0000 | 0.0000 | 2023-01-06 16:57:43.222339 | 0.0000 | 0.0000 | 0.0000 | 1672995463.222339 | 63970.0000 | 0.0092 | PHY_TABLE_SCAN | 0.0000 | 0 | 64495.0000 | 8 | 0 | 0 | 76206 | 0.0000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 75129 | 1000000 | 0 | 0 | 1672995463.298545 | 0.2472 | 0.0092 | None | 0 | 0 | 0 | 0 | 56554 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 2023-01-06 16:57:43.298545 | 2023-01-06 16:57:43.297468 | 1672995463.297468 | 1672995463.222339 | 2023-01-06 16:57:43.222339 | 57577 | 0 | 8 |
| 1672995463397036.5000 | 0.0000 | 2023-01-06 16:57:43.223357 | 0.0000 | 0.0000 | 0.0000 | 1672995463.300848 | 95788.5000 | 0.0633 | PHY_PX_FIFO_RECEIVE | 0.0000 | 8 | 194343964.5000 | 5 | 7 | 19 | 392514717 | 0.0257 | 0 | 1672995463397344 | 0 | 0 | 0 | 0 | 20 | 0 | 96407 | 1000000 | 0 | 0 | 1672995855.738074 | 0.0128 | 0.0375 | None | 0 | 6691981853588146 | 0 | 0 | 95170 | 0 | 0 | 0 | 0 | 1672995463396292 | 0 | 0 | 4 | 2023-01-06 17:04:15.738074 | 2023-01-06 16:57:43.397344 | 1672995463.397344 | 1672995463.223357 | 2023-01-06 16:57:43.300848 | 214436 | 0 | 9 |
| 1672995463370806.0000 | 110.0000 | 2023-01-06 16:57:43.299352 | 59.7500 | 0.0000 | 58.7500 | 1672995463.299352 | 68957.2500 | 0.0013 | PHY_PX_DIST_TRANSMIT | 0.0000 | 8 | 68957.2500 | 6 | 21 | 19 | 89775 | 0.0114 | 0 | 1672995463396292 | 110 | 0 | 144 | 144 | 20 | 0 | 89775 | 1000000 | 0 | 0 | 1672995463.396292 | 0.4544 | -0.0101 | None | 440 | 6691981853483224 | 235 | 0 | 48983 | 239 | 11 | 0 | 7 | 1672995463348335 | 110 | 0 | 4 | 2023-01-06 16:57:43.396292 | 2023-01-06 16:57:43.396292 | 1672995463.396292 | 1672995463.299352 | 2023-01-06 16:57:43.299352 | 48983 | 0 | 10 |
| 1.0000 | 0.0000 | 2023-01-06 16:57:43.299352 | 0.0000 | 0.0000 | 0.0000 | 1672995463.299352 | 67897.7500 | 0.0001 | PHY_GRANULE_ITERATOR | 0.0000 | 0 | 68957.2500 | 7 | 0 | 0 | 89775 | 0.0000 | 0 | 1 | 0 | 0 | 0 | 0 | 23 | 0 | 88698 | 1000000 | 0 | 22 | 1672995463.396292 | 0.4716 | 0.0001 | None | 0 | 4 | 0 | 0 | 46869 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 4 | 2023-01-06 16:57:43.396292 | 2023-01-06 16:57:43.395215 | 1672995463.395215 | 1672995463.299352 | 2023-01-06 16:57:43.299352 | 48983 | 0 | 11 |
| 0.0000 | 0.0000 | 2023-01-06 16:57:43.299352 | 0.0000 | 0.0000 | 0.0000 | 1672995463.299352 | 67897.7500 | 0.0081 | PHY_TABLE_SCAN | 0.0000 | 0 | 68957.2500 | 8 | 0 | 0 | 89775 | 0.0000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 88698 | 1000000 | 0 | 0 | 1672995463.396292 | 0.4716 | 0.0081 | None | 0 | 0 | 0 | 0 | 46869 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 2023-01-06 16:57:43.396292 | 2023-01-06 16:57:43.395215 | 1672995463.395215 | 1672995463.299352 | 2023-01-06 16:57:43.299352 | 48983 | 0 | 12 |
DFO Scheduling timeline view
DFO data output timeline
DB Time View
| AVG_STAT_2 | AVG_STAT_3 | MIN_FIRST_REFRESH_TIME | AVG_STAT_6 | AVG_STAT_4 | AVG_STAT_5 | MIN_FIRST_CHANGE_TS | AVG_CHANGE_TIME | MY_DB_TIME | PLAN_OPERATION | SVR_PORT | AVG_REFRESH_TIME | PLAN_DEPTH | MAX_REFRESH_TIME | MAX_STAT_1 | MAX_STAT_2 | MAX_STAT_3 | AVG_STAT_1 | MAX_STAT_5 | MAX_STAT_6 | MY_IO_TIME | MAX_CHANGE_TIME | TOTAL_OUTPUT_ROWS | TOTAL_RESCAN_TIMES | MAX_LAST_REFRESH_TS | SKEWNESS | MY_CPU_TIME | MAX_STAT_4 | MIN_CHANGE_TIME | MIN_STAT_6 | MIN_STAT_4 | MIN_STAT_5 | MIN_STAT_2 | MIN_STAT_3 | MIN_STAT_1 | PARALLEL | MAX_LAST_REFRESH_TIME | MAX_LAST_CHANGE_TIME | MAX_LAST_CHANGE_TS | MIN_FIRST_REFRESH_TS | MIN_FIRST_CHANGE_TIME | SVR_IP | MIN_REFRESH_TIME | PLAN_LINE_ID |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0.0000 | 0.0000 | 2023-01-06 16:57:43.221552 | 0.0000 | 0.0000 | 0.0000 | 1672995855.739426 | 0.0000 | 0.0000 | PHY_SCALAR_AGGREGATE | 19510 | 392517874.0000 | 0 | 392517874 | 0 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | 1 | 0 | 1672995855.739426 | None | 0.0000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 2023-01-06 17:04:15.739426 | 2023-01-06 17:04:15.739426 | 1672995855.739426 | 1672995463.221552 | 2023-01-06 17:04:15.739426 | 192.168.1.77 | 392517874 | 0 |
| 1672995855738367.0000 | 4.0000 | 2023-01-06 16:57:43.221552 | 0.0000 | 0.0000 | 0.0000 | 1672995855.738367 | 0.0000 | 392.5035 | PHY_PX_FIFO_COORD | 19510 | 392517874.0000 | 1 | 392517874 | 0 | 1672995855738367 | 4 | 0.0000 | 0 | 0 | 392.2996 | 0 | 2 | 0 | 1672995855.739426 | None | 0.2038 | 0 | 0 | 0 | 0 | 0 | 1672995855738367 | 4 | 0 | 1 | 2023-01-06 17:04:15.739426 | 2023-01-06 17:04:15.738367 | 1672995855.738367 | 1672995463.221552 | 2023-01-06 17:04:15.738367 | 192.168.1.77 | 392517874 | 1 |
| 1672995655545940.0000 | 1.0000 | 2023-01-06 16:57:43.223656 | 0.0000 | 0.0000 | 0.0000 | 1672995847.653788 | 0.0000 | 0.1075 | PHY_PX_REDUCE_TRANSMIT | 19510 | 192322284.0000 | 2 | 384430132 | 0 | 1672995847653788 | 1 | 0.0000 | 0 | 0 | 0.0000 | 0 | 1 | 0 | 1672995847.653788 | None | 0.1075 | 0 | 0 | 0 | 0 | 0 | 1672995463438092 | 1 | 0 | 2 | 2023-01-06 17:04:07.653788 | 2023-01-06 17:04:07.653788 | 1672995847.653788 | 1672995463.223656 | 2023-01-06 17:04:07.653788 | 192.168.1.77 | 214436 | 2 |
| 1672995659589002.0000 | 1.0000 | 2023-01-06 16:57:43.223357 | 0.0000 | 0.0000 | 0.0000 | 1672995855.738074 | 0.0000 | 0.1083 | PHY_PX_REDUCE_TRANSMIT | 19512 | 196366161.0000 | 2 | 392515749 | 0 | 1672995855738074 | 1 | 0.0000 | 0 | 0 | 0.0000 | 0 | 1 | 0 | 1672995855.739106 | None | 0.1083 | 0 | 0 | 0 | 0 | 0 | 1672995463439930 | 1 | 0 | 2 | 2023-01-06 17:04:15.739106 | 2023-01-06 17:04:15.738074 | 1672995855.738074 | 1672995463.223357 | 2023-01-06 17:04:15.738074 | 192.168.1.77 | 216573 | 2 |
| 0.0000 | 0.0000 | 2023-01-06 16:57:43.223656 | 0.0000 | 0.0000 | 0.0000 | 1672995847.653788 | 0.0000 | 19.8669 | PHY_MERGE_GROUP_BY | 19510 | 192322284.0000 | 3 | 384430132 | 0 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | 1 | 0 | 1672995847.653788 | None | 19.8669 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 2023-01-06 17:04:07.653788 | 2023-01-06 17:04:07.653788 | 1672995847.653788 | 1672995463.223656 | 2023-01-06 17:04:07.653788 | 192.168.1.77 | 214436 | 3 |
| 0.0000 | 0.0000 | 2023-01-06 16:57:43.223357 | 0.0000 | 0.0000 | 0.0000 | 1672995855.738074 | 0.0000 | 20.0685 | PHY_MERGE_GROUP_BY | 19512 | 196366161.0000 | 3 | 392515749 | 0 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | 1 | 0 | 1672995855.739106 | None | 20.0685 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 2023-01-06 17:04:15.739106 | 2023-01-06 17:04:15.738074 | 1672995855.738074 | 1672995463.223357 | 2023-01-06 17:04:15.738074 | 192.168.1.77 | 216573 | 3 |
| 0.0000 | 0.0000 | 2023-01-06 16:57:43.223656 | 38217.0000 | 98304.0000 | 1.5000 | 1672995463.422284 | 384231504.0000 | 172.3550 | PHY_HASH_JOIN | 19510 | 192322284.0000 | 4 | 384430132 | 0 | 0 | 0 | 0.0000 | 2 | 50870 | 0.0564 | 384231504 | 12853876224 | 0 | 1672995847.653788 | 0.0000 | 172.2985 | 131072 | 384231504 | 25564 | 65536 | 1 | 0 | 0 | 0 | 2 | 2023-01-06 17:04:07.653788 | 2023-01-06 17:04:07.653788 | 1672995847.653788 | 1672995463.223656 | 2023-01-06 16:57:43.422284 | 192.168.1.77 | 214436 | 4 |
| 0.0000 | 0.0000 | 2023-01-06 16:57:43.223357 | 38961.0000 | 196608.0000 | 3.0000 | 1672995463.477592 | 392260482.0000 | 176.1848 | PHY_HASH_JOIN | 19512 | 196366161.0000 | 4 | 392515749 | 0 | 0 | 0 | 0.0000 | 4 | 51339 | 0.0657 | 392260482 | 12884616032 | 0 | 1672995855.739106 | 0.0000 | 176.1190 | 262144 | 392260482 | 26583 | 131072 | 2 | 0 | 0 | 0 | 2 | 2023-01-06 17:04:15.739106 | 2023-01-06 17:04:15.738074 | 1672995855.738074 | 1672995463.223357 | 2023-01-06 16:57:43.477592 | 192.168.1.77 | 216573 | 4 |
| 1672995463300100.0000 | 0.0000 | 2023-01-06 16:57:43.223656 | 0.0000 | 0.0000 | 0.0000 | 1672995463.225804 | 73124.5000 | 0.0309 | PHY_PX_FIFO_RECEIVE | 19510 | 192322284.0000 | 5 | 384430132 | 0 | 1672995463300848 | 0 | 0.0000 | 0 | 0 | 0.0069 | 73548 | 512152 | 0 | 1672995847.653788 | 0.0115 | 0.0240 | 0 | 72701 | 0 | 0 | 0 | 1672995463299352 | 0 | 0 | 2 | 2023-01-06 17:04:07.653788 | 2023-01-06 16:57:43.300848 | 1672995463.300848 | 1672995463.223656 | 2023-01-06 16:57:43.225804 | 192.168.1.77 | 214436 | 5 |
| 1672995463299074.0000 | 0.0000 | 2023-01-06 16:57:43.223357 | 0.0000 | 0.0000 | 0.0000 | 1672995463.225445 | 73629.0000 | 0.0413 | PHY_PX_FIFO_RECEIVE | 19512 | 196365645.0000 | 5 | 392514717 | 0 | 1672995463299603 | 0 | 0.0000 | 0 | 0 | 0.0112 | 74158 | 487848 | 0 | 1672995855.738074 | 0.0143 | 0.0300 | 0 | 73100 | 0 | 0 | 0 | 1672995463298545 | 0 | 0 | 2 | 2023-01-06 17:04:15.738074 | 2023-01-06 16:57:43.299603 | 1672995463.299603 | 1672995463.223357 | 2023-01-06 16:57:43.225445 | 192.168.1.77 | 216573 | 5 |
| 1672995463281252.5000 | 108.5000 | 2023-01-06 16:57:43.222609 | 0.0000 | 0.0000 | 0.0000 | 1672995463.222609 | 58643.5000 | 0.0007 | PHY_PX_DIST_TRANSMIT | 19510 | 58643.5000 | 6 | 59710 | 0 | 1672995463282319 | 109 | 0.0000 | 0 | 0 | 0.0000 | 59710 | 500000 | 0 | 1672995463.282319 | 0.0357 | 0.0007 | 0 | 57577 | 0 | 0 | 0 | 1672995463280186 | 108 | 0 | 2 | 2023-01-06 16:57:43.282319 | 2023-01-06 16:57:43.282319 | 1672995463.282319 | 1672995463.222609 | 2023-01-06 16:57:43.222609 | 192.168.1.77 | 57577 | 6 |
| 1672995463292685.5000 | 109.0000 | 2023-01-06 16:57:43.222339 | 18.0000 | 0.0000 | 0.0000 | 1672995463.222339 | 70346.5000 | 0.0007 | PHY_PX_DIST_TRANSMIT | 19512 | 70346.5000 | 6 | 76206 | 0 | 1672995463298545 | 109 | 0.0000 | 0 | 36 | 0.0052 | 76206 | 500000 | 0 | 1672995463.298545 | 0.1538 | -0.0045 | 0 | 64487 | 0 | 0 | 0 | 1672995463286826 | 109 | 0 | 2 | 2023-01-06 16:57:43.298545 | 2023-01-06 16:57:43.298545 | 1672995463.298545 | 1672995463.222339 | 2023-01-06 16:57:43.222339 | 192.168.1.77 | 64487 | 6 |
| 1.0000 | 0.0000 | 2023-01-06 16:57:43.222609 | 0.0000 | 0.0000 | 0.0000 | 1672995463.222609 | 58132.0000 | 0.0001 | PHY_GRANULE_ITERATOR | 19510 | 58643.5000 | 7 | 59710 | 0 | 1 | 0 | 0.0000 | 0 | 0 | 0.0000 | 59710 | 500000 | 0 | 1672995463.282319 | 0.0529 | 0.0001 | 0 | 56554 | 0 | 0 | 0 | 1 | 0 | 0 | 2 | 2023-01-06 16:57:43.282319 | 2023-01-06 16:57:43.282319 | 1672995463.282319 | 1672995463.222609 | 2023-01-06 16:57:43.222609 | 192.168.1.77 | 57577 | 7 |
| 1.0000 | 0.0000 | 2023-01-06 16:57:43.222339 | 0.0000 | 0.0000 | 0.0000 | 1672995463.222339 | 69808.0000 | 0.0001 | PHY_GRANULE_ITERATOR | 19512 | 70346.5000 | 7 | 76206 | 0 | 1 | 0 | 0.0000 | 0 | 0 | 0.0000 | 75129 | 500000 | 0 | 1672995463.298545 | 0.1416 | 0.0001 | 0 | 64487 | 0 | 0 | 0 | 1 | 0 | 0 | 2 | 2023-01-06 16:57:43.298545 | 2023-01-06 16:57:43.297468 | 1672995463.297468 | 1672995463.222339 | 2023-01-06 16:57:43.222339 | 192.168.1.77 | 64487 | 7 |
| 0.0000 | 0.0000 | 2023-01-06 16:57:43.222609 | 0.0000 | 0.0000 | 0.0000 | 1672995463.222609 | 58132.0000 | 0.0102 | PHY_TABLE_SCAN | 19510 | 58643.5000 | 8 | 59710 | 0 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 59710 | 500000 | 0 | 1672995463.282319 | 0.0529 | 0.0102 | 0 | 56554 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 2023-01-06 16:57:43.282319 | 2023-01-06 16:57:43.282319 | 1672995463.282319 | 1672995463.222609 | 2023-01-06 16:57:43.222609 | 192.168.1.77 | 57577 | 8 |
| 0.0000 | 0.0000 | 2023-01-06 16:57:43.222339 | 0.0000 | 0.0000 | 0.0000 | 1672995463.222339 | 69808.0000 | 0.0081 | PHY_TABLE_SCAN | 19512 | 70346.5000 | 8 | 76206 | 0 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 75129 | 500000 | 0 | 1672995463.298545 | 0.1416 | 0.0081 | 0 | 64487 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 2023-01-06 16:57:43.298545 | 2023-01-06 16:57:43.297468 | 1672995463.297468 | 1672995463.222339 | 2023-01-06 16:57:43.222339 | 192.168.1.77 | 64487 | 8 |
| 1672995463396818.0000 | 0.0000 | 2023-01-06 16:57:43.223357 | 0.0000 | 0.0000 | 0.0000 | 1672995463.302174 | 95170.0000 | 0.0639 | PHY_PX_FIFO_RECEIVE | 19512 | 196365645.0000 | 5 | 392514717 | 0 | 1672995463397344 | 0 | 0.0000 | 0 | 0 | 0.0259 | 95170 | 500704 | 0 | 1672995855.738074 | 0.0000 | 0.0379 | 0 | 95170 | 0 | 0 | 0 | 1672995463396292 | 0 | 0 | 2 | 2023-01-06 17:04:15.738074 | 2023-01-06 16:57:43.397344 | 1672995463.397344 | 1672995463.223357 | 2023-01-06 16:57:43.302174 | 192.168.1.77 | 216573 | 9 |
| 1672995463397255.0000 | 0.0000 | 2023-01-06 16:57:43.223656 | 0.0000 | 0.0000 | 0.0000 | 1672995463.300848 | 96407.0000 | 0.0627 | PHY_PX_FIFO_RECEIVE | 19510 | 192322284.0000 | 5 | 384430132 | 0 | 1672995463397255 | 0 | 0.0000 | 0 | 0 | 0.0256 | 96407 | 499296 | 0 | 1672995847.653788 | 0.0000 | 0.0371 | 0 | 96407 | 0 | 0 | 0 | 1672995463397255 | 0 | 0 | 2 | 2023-01-06 17:04:07.653788 | 2023-01-06 16:57:43.397255 | 1672995463.397255 | 1672995463.223656 | 2023-01-06 16:57:43.300848 | 192.168.1.77 | 214436 | 9 |
| 1672995463364881.5000 | 110.0000 | 2023-01-06 16:57:43.299352 | 77.5000 | 0.0000 | 75.5000 | 1672995463.299352 | 65529.5000 | 0.0012 | PHY_PX_DIST_TRANSMIT | 19510 | 65529.5000 | 6 | 82076 | 0 | 1672995463381428 | 110 | 0.0000 | 144 | 144 | 0.0156 | 82076 | 500000 | 0 | 1672995463.381428 | 0.4032 | -0.0143 | 0 | 48983 | 11 | 0 | 7 | 1672995463348335 | 110 | 0 | 2 | 2023-01-06 16:57:43.381428 | 2023-01-06 16:57:43.381428 | 1672995463.381428 | 1672995463.299352 | 2023-01-06 16:57:43.299352 | 192.168.1.77 | 48983 | 10 |
| 1672995463376730.5000 | 110.0000 | 2023-01-06 16:57:43.302174 | 42.0000 | 0.0000 | 42.0000 | 1672995463.302174 | 72385.0000 | 0.0014 | PHY_PX_DIST_TRANSMIT | 19512 | 72385.0000 | 6 | 89775 | 0 | 1672995463396292 | 110 | 0.0000 | 64 | 64 | 0.0073 | 89775 | 500000 | 0 | 1672995463.396292 | 0.3874 | -0.0059 | 0 | 54995 | 20 | 0 | 20 | 1672995463357169 | 110 | 0 | 2 | 2023-01-06 16:57:43.396292 | 2023-01-06 16:57:43.396292 | 1672995463.396292 | 1672995463.302174 | 2023-01-06 16:57:43.302174 | 192.168.1.77 | 54995 | 10 |
| 1.0000 | 0.0000 | 2023-01-06 16:57:43.299352 | 0.0000 | 0.0000 | 0.0000 | 1672995463.299352 | 64472.5000 | 0.0001 | PHY_GRANULE_ITERATOR | 19510 | 65529.5000 | 7 | 82076 | 0 | 1 | 0 | 0.0000 | 0 | 0 | 0.0000 | 82076 | 500000 | 0 | 1672995463.381428 | 0.4290 | 0.0001 | 0 | 46869 | 0 | 0 | 0 | 1 | 0 | 0 | 2 | 2023-01-06 16:57:43.381428 | 2023-01-06 16:57:43.381428 | 1672995463.381428 | 1672995463.299352 | 2023-01-06 16:57:43.299352 | 192.168.1.77 | 48983 | 11 |
| 1.0000 | 0.0000 | 2023-01-06 16:57:43.302174 | 0.0000 | 0.0000 | 0.0000 | 1672995463.302174 | 71323.0000 | 0.0001 | PHY_GRANULE_ITERATOR | 19512 | 72385.0000 | 7 | 89775 | 0 | 1 | 0 | 0.0000 | 0 | 0 | 0.0000 | 88698 | 500000 | 0 | 1672995463.396292 | 0.3918 | 0.0001 | 0 | 53948 | 0 | 0 | 0 | 1 | 0 | 0 | 2 | 2023-01-06 16:57:43.396292 | 2023-01-06 16:57:43.395215 | 1672995463.395215 | 1672995463.302174 | 2023-01-06 16:57:43.302174 | 192.168.1.77 | 54995 | 11 |
| 0.0000 | 0.0000 | 2023-01-06 16:57:43.299352 | 0.0000 | 0.0000 | 0.0000 | 1672995463.299352 | 64472.5000 | 0.0078 | PHY_TABLE_SCAN | 19510 | 65529.5000 | 8 | 82076 | 0 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 82076 | 500000 | 0 | 1672995463.381428 | 0.4290 | 0.0078 | 0 | 46869 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 2023-01-06 16:57:43.381428 | 2023-01-06 16:57:43.381428 | 1672995463.381428 | 1672995463.299352 | 2023-01-06 16:57:43.299352 | 192.168.1.77 | 48983 | 12 |
| 0.0000 | 0.0000 | 2023-01-06 16:57:43.302174 | 0.0000 | 0.0000 | 0.0000 | 1672995463.302174 | 71323.0000 | 0.0084 | PHY_TABLE_SCAN | 19512 | 72385.0000 | 8 | 89775 | 0 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 88698 | 500000 | 0 | 1672995463.396292 | 0.3918 | 0.0084 | 0 | 53948 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 2023-01-06 16:57:43.396292 | 2023-01-06 16:57:43.395215 | 1672995463.395215 | 1672995463.302174 | 2023-01-06 16:57:43.302174 | 192.168.1.77 | 54995 | 12 |
View Ordered by Operator
View Ordered by Server
| MY_DB_TIME | FIRST_REFRESH_TS | REFRESH_TS | OTHERSTAT_5_ID | PLAN_DEPTH | FIRST_CHANGE_TIME | OTHERSTAT_3_ID | OTHERSTAT_2_ID | MY_IO_TIME | OTHERSTAT_1_VALUE | OTHERSTAT_1_ID | SVR_PORT | MY_CPU_TIME | OTHERSTAT_3_VALUE | OTHERSTAT_5_VALUE | FIRST_CHANGE_TS | OTHERSTAT_6_ID | OUTPUT_ROWS | FIRST_REFRESH_TIME | OTHERSTAT_6_VALUE | LAST_REFRESH_TS | LAST_REFRESH_TIME | PLAN_OPERATION | CHANGE_TS | PROCESS_NAME | OTHERSTAT_4_VALUE | OTHERSTAT_4_ID | LAST_CHANGE_TS | OTHERSTAT_2_VALUE | RESCAN_TIMES | SVR_IP | LAST_CHANGE_TIME | PLAN_LINE_ID |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0.0000 | 1672995463.221552 | 392.517874 | 0 | 0 | 2023-01-06 17:04:15.739426 | 0 | 0 | 0.0000 | 0 | 0 | 19510 | 0.0000 | 0 | 0 | 1672995855.739426 | 0 | 1 | 2023-01-06 16:57:43.221552 | 0 | 1672995855.739426 | 2023-01-06 17:04:15.739426 | PHY_SCALAR_AGGREGATE | 0.000000 | 87724 | 0 | 0 | 1672995855.739426 | 0 | 0 | 192.168.1.77 | 2023-01-06 17:04:15.739426 | 0 |
| 392.5035 | 1672995463.221552 | 392.517874 | 8 | 1 | 2023-01-06 17:04:15.738367 | 19 | 20 | 392.2996 | 0 | 0 | 19510 | 0.2038 | 4 | 0 | 1672995855.738367 | 7 | 2 | 2023-01-06 16:57:43.221552 | 0 | 1672995855.739426 | 2023-01-06 17:04:15.739426 | PHY_PX_FIFO_COORD | 0.000000 | 87724 | 0 | 0 | 1672995855.738367 | 1672995855738367 | 0 | 192.168.1.77 | 2023-01-06 17:04:15.738367 | 1 |
| 0.2150 | 1672995463.223656 | 0.214436 | 8 | 2 | None | 19 | 20 | 0.0000 | 0 | 0 | 19510 | 0.2150 | 1 | 0 | None | 7 | 0 | 2023-01-06 16:57:43.223656 | 0 | 1672995463.438092 | 2023-01-06 16:57:43.438092 | PHY_PX_REDUCE_TRANSMIT | None | 115160 | 0 | 0 | 1672995463.438092 | 1672995463438092 | 0 | 192.168.1.77 | 2023-01-06 16:57:43.438092 | 2 |
| 0.0000 | 1672995463.223656 | 384.430132 | 8 | 2 | 2023-01-06 17:04:07.653788 | 19 | 20 | 0.0000 | 0 | 0 | 19510 | 0.0000 | 1 | 0 | 1672995847.653788 | 7 | 1 | 2023-01-06 16:57:43.223656 | 0 | 1672995847.653788 | 2023-01-06 17:04:07.653788 | PHY_PX_REDUCE_TRANSMIT | 0.000000 | 115158 | 0 | 0 | 1672995847.653788 | 1672995847653788 | 0 | 192.168.1.77 | 2023-01-06 17:04:07.653788 | 2 |
| 0.2165 | 1672995463.223357 | 0.216573 | 8 | 2 | None | 19 | 20 | 0.0000 | 0 | 0 | 19512 | 0.2165 | 1 | 0 | None | 7 | 0 | 2023-01-06 16:57:43.223357 | 0 | 1672995463.439930 | 2023-01-06 16:57:43.439930 | PHY_PX_REDUCE_TRANSMIT | None | 115159 | 0 | 0 | 1672995463.439930 | 1672995463439930 | 0 | 192.168.1.77 | 2023-01-06 16:57:43.439930 | 2 |
| 0.0001 | 1672995463.223357 | 392.515749 | 8 | 2 | 2023-01-06 17:04:15.738074 | 19 | 20 | 0.0000 | 0 | 0 | 19512 | 0.0001 | 1 | 0 | 1672995855.738074 | 7 | 1 | 2023-01-06 16:57:43.223357 | 0 | 1672995855.739106 | 2023-01-06 17:04:15.739106 | PHY_PX_REDUCE_TRANSMIT | 0.000000 | 115161 | 0 | 0 | 1672995855.738074 | 1672995855738074 | 0 | 192.168.1.77 | 2023-01-06 17:04:15.738074 | 2 |
| 0.0000 | 1672995463.223656 | 0.214436 | 0 | 3 | None | 0 | 0 | 0.0000 | 0 | 0 | 19510 | 0.0000 | 0 | 0 | None | 21 | 0 | 2023-01-06 16:57:43.223656 | 0 | 1672995463.438092 | 2023-01-06 16:57:43.438092 | PHY_MERGE_GROUP_BY | None | 115160 | 0 | 0 | 1672995463.438092 | 0 | 0 | 192.168.1.77 | 2023-01-06 16:57:43.438092 | 3 |
| 39.7339 | 1672995463.223656 | 384.430132 | 0 | 3 | 2023-01-06 17:04:07.653788 | 0 | 0 | 0.0000 | 0 | 0 | 19510 | 39.7339 | 0 | 0 | 1672995847.653788 | 21 | 1 | 2023-01-06 16:57:43.223656 | 0 | 1672995847.653788 | 2023-01-06 17:04:07.653788 | PHY_MERGE_GROUP_BY | 0.000000 | 115158 | 0 | 0 | 1672995847.653788 | 0 | 0 | 192.168.1.77 | 2023-01-06 17:04:07.653788 | 3 |
| 0.0000 | 1672995463.223357 | 0.216573 | 0 | 3 | None | 0 | 0 | 0.0000 | 0 | 0 | 19512 | 0.0000 | 0 | 0 | None | 21 | 0 | 2023-01-06 16:57:43.223357 | 0 | 1672995463.439930 | 2023-01-06 16:57:43.439930 | PHY_MERGE_GROUP_BY | None | 115159 | 0 | 0 | 1672995463.438888 | 0 | 0 | 192.168.1.77 | 2023-01-06 16:57:43.438888 | 3 |
| 40.1371 | 1672995463.223357 | 392.515749 | 0 | 3 | 2023-01-06 17:04:15.738074 | 0 | 0 | 0.0000 | 0 | 0 | 19512 | 40.1371 | 0 | 0 | 1672995855.738074 | 21 | 1 | 2023-01-06 16:57:43.223357 | 0 | 1672995855.739106 | 2023-01-06 17:04:15.739106 | PHY_MERGE_GROUP_BY | 0.000000 | 115161 | 0 | 0 | 1672995855.738074 | 0 | 0 | 192.168.1.77 | 2023-01-06 17:04:15.738074 | 3 |
| 0.0857 | 1672995463.223656 | 0.214436 | 5 | 4 | None | 3 | 2 | 0.0331 | 0 | 1 | 19510 | 0.0526 | 0 | 2 | None | 6 | 0 | 2023-01-06 16:57:43.223656 | 50870 | 1672995463.438092 | 2023-01-06 16:57:43.438092 | PHY_HASH_JOIN | None | 115160 | 131072 | 4 | 1672995463.438092 | 0 | 0 | 192.168.1.77 | 2023-01-06 16:57:43.438092 | 4 |
| 344.6242 | 1672995463.223656 | 384.430132 | 5 | 4 | 2023-01-06 16:57:43.422284 | 3 | 2 | 0.0797 | 0 | 1 | 19510 | 344.5444 | 0 | 1 | 1672995463.422284 | 6 | 12853876224 | 2023-01-06 16:57:43.223656 | 25564 | 1672995847.653788 | 2023-01-06 17:04:07.653788 | PHY_HASH_JOIN | 384.231504 | 115158 | 65536 | 4 | 1672995847.653788 | 0 | 0 | 192.168.1.77 | 2023-01-06 17:04:07.653788 | 4 |
| 0.0868 | 1672995463.223357 | 0.216573 | 5 | 4 | None | 3 | 2 | 0.0374 | 0 | 1 | 19512 | 0.0494 | 0 | 4 | None | 6 | 0 | 2023-01-06 16:57:43.223357 | 26583 | 1672995463.439930 | 2023-01-06 16:57:43.439930 | PHY_HASH_JOIN | None | 115159 | 262144 | 4 | 1672995463.438888 | 0 | 0 | 192.168.1.77 | 2023-01-06 16:57:43.438888 | 4 |
| 352.2828 | 1672995463.223357 | 392.515749 | 5 | 4 | 2023-01-06 16:57:43.477592 | 3 | 2 | 0.0941 | 0 | 1 | 19512 | 352.1886 | 0 | 2 | 1672995463.477592 | 6 | 12884616032 | 2023-01-06 16:57:43.223357 | 51339 | 1672995855.739106 | 2023-01-06 17:04:15.739106 | PHY_HASH_JOIN | 392.260482 | 115161 | 131072 | 4 | 1672995855.738074 | 0 | 0 | 192.168.1.77 | 2023-01-06 17:04:15.738074 | 4 |
| 0.0332 | 1672995463.223656 | 0.214436 | 8 | 5 | 2023-01-06 16:57:43.228147 | 19 | 20 | 0.0068 | 0 | 0 | 19510 | 0.0264 | 0 | 0 | 1672995463.228147 | 7 | 230735 | 2023-01-06 16:57:43.223656 | 0 | 1672995463.438092 | 2023-01-06 16:57:43.438092 | PHY_PX_FIFO_RECEIVE | 0.072701 | 115160 | 0 | 0 | 1672995463.300848 | 1672995463300848 | 0 | 192.168.1.77 | 2023-01-06 16:57:43.300848 | 5 |
| 0.0287 | 1672995463.223656 | 384.430132 | 8 | 5 | 2023-01-06 16:57:43.225804 | 19 | 20 | 0.0070 | 0 | 0 | 19510 | 0.0216 | 0 | 0 | 1672995463.225804 | 7 | 281417 | 2023-01-06 16:57:43.223656 | 0 | 1672995847.653788 | 2023-01-06 17:04:07.653788 | PHY_PX_FIFO_RECEIVE | 0.073548 | 115158 | 0 | 0 | 1672995463.299352 | 1672995463299352 | 0 | 192.168.1.77 | 2023-01-06 16:57:43.299352 | 5 |
| 0.0308 | 1672995463.223357 | 0.216573 | 8 | 5 | 2023-01-06 16:57:43.225445 | 19 | 20 | 0.0053 | 0 | 0 | 19512 | 0.0255 | 0 | 0 | 1672995463.225445 | 7 | 308268 | 2023-01-06 16:57:43.223357 | 0 | 1672995463.439930 | 2023-01-06 16:57:43.439930 | PHY_PX_FIFO_RECEIVE | 0.073100 | 115159 | 0 | 0 | 1672995463.298545 | 1672995463298545 | 0 | 192.168.1.77 | 2023-01-06 16:57:43.298545 | 5 |
| 0.0518 | 1672995463.223357 | 392.514717 | 8 | 5 | 2023-01-06 16:57:43.225445 | 19 | 20 | 0.0172 | 0 | 0 | 19512 | 0.0346 | 0 | 0 | 1672995463.225445 | 7 | 179580 | 2023-01-06 16:57:43.223357 | 0 | 1672995855.738074 | 2023-01-06 17:04:15.738074 | PHY_PX_FIFO_RECEIVE | 0.074158 | 115161 | 0 | 0 | 1672995463.299603 | 1672995463299603 | 0 | 192.168.1.77 | 2023-01-06 16:57:43.299603 | 5 |
| 0.0008 | 1672995463.222609 | 0.057577 | 8 | 6 | 2023-01-06 16:57:43.222609 | 19 | 20 | 0.0000 | 0 | 0 | 19510 | 0.0008 | 108 | 0 | 1672995463.222609 | 21 | 250000 | 2023-01-06 16:57:43.222609 | 0 | 1672995463.280186 | 2023-01-06 16:57:43.280186 | PHY_PX_DIST_TRANSMIT | 0.057577 | 114403 | 0 | 0 | 1672995463.280186 | 1672995463280186 | 0 | 192.168.1.77 | 2023-01-06 16:57:43.280186 | 6 |
| 0.0007 | 1672995463.222609 | 0.059710 | 8 | 6 | 2023-01-06 16:57:43.222609 | 19 | 20 | 0.0000 | 0 | 0 | 19510 | 0.0007 | 109 | 0 | 1672995463.222609 | 21 | 250000 | 2023-01-06 16:57:43.222609 | 0 | 1672995463.282319 | 2023-01-06 16:57:43.282319 | PHY_PX_DIST_TRANSMIT | 0.059710 | 114401 | 0 | 0 | 1672995463.282319 | 1672995463282319 | 0 | 192.168.1.77 | 2023-01-06 16:57:43.282319 | 6 |
| 0.0004 | 1672995463.222339 | 0.064487 | 8 | 6 | 2023-01-06 16:57:43.222339 | 19 | 20 | 0.0000 | 0 | 0 | 19512 | 0.0004 | 109 | 0 | 1672995463.222339 | 21 | 250000 | 2023-01-06 16:57:43.222339 | 0 | 1672995463.286826 | 2023-01-06 16:57:43.286826 | PHY_PX_DIST_TRANSMIT | 0.064487 | 114402 | 0 | 0 | 1672995463.286826 | 1672995463286826 | 0 | 192.168.1.77 | 2023-01-06 16:57:43.286826 | 6 |
| 0.0009 | 1672995463.222339 | 0.076206 | 8 | 6 | 2023-01-06 16:57:43.222339 | 19 | 20 | 0.0105 | 0 | 0 | 19512 | -0.0096 | 109 | 0 | 1672995463.222339 | 21 | 250000 | 2023-01-06 16:57:43.222339 | 36 | 1672995463.298545 | 2023-01-06 16:57:43.298545 | PHY_PX_DIST_TRANSMIT | 0.076206 | 114400 | 0 | 0 | 1672995463.298545 | 1672995463298545 | 0 | 192.168.1.77 | 2023-01-06 16:57:43.298545 | 6 |
| 0.0001 | 1672995463.222609 | 0.057577 | 0 | 7 | 2023-01-06 16:57:43.222609 | 0 | 23 | 0.0000 | 0 | 22 | 19510 | 0.0001 | 0 | 0 | 1672995463.222609 | 0 | 250000 | 2023-01-06 16:57:43.222609 | 0 | 1672995463.280186 | 2023-01-06 16:57:43.280186 | PHY_GRANULE_ITERATOR | 0.056554 | 114403 | 0 | 0 | 1672995463.279163 | 1 | 0 | 192.168.1.77 | 2023-01-06 16:57:43.279163 | 7 |
| 0.0001 | 1672995463.222609 | 0.059710 | 0 | 7 | 2023-01-06 16:57:43.222609 | 0 | 23 | 0.0000 | 0 | 22 | 19510 | 0.0001 | 0 | 0 | 1672995463.222609 | 0 | 250000 | 2023-01-06 16:57:43.222609 | 0 | 1672995463.282319 | 2023-01-06 16:57:43.282319 | PHY_GRANULE_ITERATOR | 0.059710 | 114401 | 0 | 0 | 1672995463.282319 | 1 | 0 | 192.168.1.77 | 2023-01-06 16:57:43.282319 | 7 |
| 0.0001 | 1672995463.222339 | 0.064487 | 0 | 7 | 2023-01-06 16:57:43.222339 | 0 | 23 | 0.0000 | 0 | 22 | 19512 | 0.0001 | 0 | 0 | 1672995463.222339 | 0 | 250000 | 2023-01-06 16:57:43.222339 | 0 | 1672995463.286826 | 2023-01-06 16:57:43.286826 | PHY_GRANULE_ITERATOR | 0.064487 | 114402 | 0 | 0 | 1672995463.286826 | 1 | 0 | 192.168.1.77 | 2023-01-06 16:57:43.286826 | 7 |
| 0.0001 | 1672995463.222339 | 0.076206 | 0 | 7 | 2023-01-06 16:57:43.222339 | 0 | 23 | 0.0000 | 0 | 22 | 19512 | 0.0001 | 0 | 0 | 1672995463.222339 | 0 | 250000 | 2023-01-06 16:57:43.222339 | 0 | 1672995463.298545 | 2023-01-06 16:57:43.298545 | PHY_GRANULE_ITERATOR | 0.075129 | 114400 | 0 | 0 | 1672995463.297468 | 1 | 0 | 192.168.1.77 | 2023-01-06 16:57:43.297468 | 7 |
| 0.0096 | 1672995463.222609 | 0.057577 | 0 | 8 | 2023-01-06 16:57:43.222609 | 0 | 0 | 0.0000 | 0 | 0 | 19510 | 0.0096 | 0 | 0 | 1672995463.222609 | 0 | 250000 | 2023-01-06 16:57:43.222609 | 0 | 1672995463.280186 | 2023-01-06 16:57:43.280186 | PHY_TABLE_SCAN | 0.056554 | 114403 | 0 | 0 | 1672995463.279163 | 0 | 0 | 192.168.1.77 | 2023-01-06 16:57:43.279163 | 8 |
| 0.0108 | 1672995463.222609 | 0.059710 | 0 | 8 | 2023-01-06 16:57:43.222609 | 0 | 0 | 0.0000 | 0 | 0 | 19510 | 0.0108 | 0 | 0 | 1672995463.222609 | 0 | 250000 | 2023-01-06 16:57:43.222609 | 0 | 1672995463.282319 | 2023-01-06 16:57:43.282319 | PHY_TABLE_SCAN | 0.059710 | 114401 | 0 | 0 | 1672995463.282319 | 0 | 0 | 192.168.1.77 | 2023-01-06 16:57:43.282319 | 8 |
| 0.0075 | 1672995463.222339 | 0.064487 | 0 | 8 | 2023-01-06 16:57:43.222339 | 0 | 0 | 0.0000 | 0 | 0 | 19512 | 0.0075 | 0 | 0 | 1672995463.222339 | 0 | 250000 | 2023-01-06 16:57:43.222339 | 0 | 1672995463.286826 | 2023-01-06 16:57:43.286826 | PHY_TABLE_SCAN | 0.064487 | 114402 | 0 | 0 | 1672995463.286826 | 0 | 0 | 192.168.1.77 | 2023-01-06 16:57:43.286826 | 8 |
| 0.0088 | 1672995463.222339 | 0.076206 | 0 | 8 | 2023-01-06 16:57:43.222339 | 0 | 0 | 0.0000 | 0 | 0 | 19512 | 0.0088 | 0 | 0 | 1672995463.222339 | 0 | 250000 | 2023-01-06 16:57:43.222339 | 0 | 1672995463.298545 | 2023-01-06 16:57:43.298545 | PHY_TABLE_SCAN | 0.075129 | 114400 | 0 | 0 | 1672995463.297468 | 0 | 0 | 192.168.1.77 | 2023-01-06 16:57:43.297468 | 8 |
| 0.0958 | 1672995463.223656 | 0.214436 | 8 | 5 | None | 19 | 20 | 0.0470 | 0 | 0 | 19510 | 0.0487 | 0 | 0 | None | 7 | 0 | 2023-01-06 16:57:43.223656 | 0 | 1672995463.438092 | 2023-01-06 16:57:43.438092 | PHY_PX_FIFO_RECEIVE | None | 115160 | 0 | 0 | 1672995463.397255 | 1672995463397255 | 0 | 192.168.1.77 | 2023-01-06 16:57:43.397255 | 9 |
| 0.0297 | 1672995463.223656 | 384.430132 | 8 | 5 | 2023-01-06 16:57:43.300848 | 19 | 20 | 0.0042 | 0 | 0 | 19510 | 0.0254 | 0 | 0 | 1672995463.300848 | 7 | 499296 | 2023-01-06 16:57:43.223656 | 0 | 1672995847.653788 | 2023-01-06 17:04:07.653788 | PHY_PX_FIFO_RECEIVE | 0.096407 | 115158 | 0 | 0 | 1672995463.397255 | 1672995463397255 | 0 | 192.168.1.77 | 2023-01-06 16:57:43.397255 | 9 |
| 0.0984 | 1672995463.223357 | 0.216573 | 8 | 5 | None | 19 | 20 | 0.0462 | 0 | 0 | 19512 | 0.0522 | 0 | 0 | None | 7 | 0 | 2023-01-06 16:57:43.223357 | 0 | 1672995463.439930 | 2023-01-06 16:57:43.439930 | PHY_PX_FIFO_RECEIVE | None | 115159 | 0 | 0 | 1672995463.396292 | 1672995463396292 | 0 | 192.168.1.77 | 2023-01-06 16:57:43.396292 | 9 |
| 0.0293 | 1672995463.223357 | 392.514717 | 8 | 5 | 2023-01-06 16:57:43.302174 | 19 | 20 | 0.0055 | 0 | 0 | 19512 | 0.0237 | 0 | 0 | 1672995463.302174 | 7 | 500704 | 2023-01-06 16:57:43.223357 | 0 | 1672995855.738074 | 2023-01-06 17:04:15.738074 | PHY_PX_FIFO_RECEIVE | 0.095170 | 115161 | 0 | 0 | 1672995463.397344 | 1672995463397344 | 0 | 192.168.1.77 | 2023-01-06 16:57:43.397344 | 9 |
| 0.0021 | 1672995463.299352 | 0.048983 | 8 | 6 | 2023-01-06 16:57:43.299352 | 19 | 20 | 0.0007 | 0 | 0 | 19510 | 0.0013 | 110 | 7 | 1672995463.299352 | 21 | 250000 | 2023-01-06 16:57:43.299352 | 11 | 1672995463.348335 | 2023-01-06 16:57:43.348335 | PHY_PX_DIST_TRANSMIT | 0.048983 | 114401 | 0 | 0 | 1672995463.348335 | 1672995463348335 | 0 | 192.168.1.77 | 2023-01-06 16:57:43.348335 | 10 |
| 0.0003 | 1672995463.299352 | 0.082076 | 8 | 6 | 2023-01-06 16:57:43.299352 | 19 | 20 | 0.0304 | 0 | 0 | 19510 | -0.0300 | 110 | 144 | 1672995463.299352 | 21 | 250000 | 2023-01-06 16:57:43.299352 | 144 | 1672995463.381428 | 2023-01-06 16:57:43.381428 | PHY_PX_DIST_TRANSMIT | 0.082076 | 114403 | 0 | 0 | 1672995463.381428 | 1672995463381428 | 0 | 192.168.1.77 | 2023-01-06 16:57:43.381428 | 10 |
| 0.0024 | 1672995463.302174 | 0.054995 | 8 | 6 | 2023-01-06 16:57:43.302174 | 19 | 20 | 0.0030 | 0 | 0 | 19512 | -0.0006 | 110 | 20 | 1672995463.302174 | 21 | 250000 | 2023-01-06 16:57:43.302174 | 20 | 1672995463.357169 | 2023-01-06 16:57:43.357169 | PHY_PX_DIST_TRANSMIT | 0.054995 | 114400 | 0 | 0 | 1672995463.357169 | 1672995463357169 | 0 | 192.168.1.77 | 2023-01-06 16:57:43.357169 | 10 |
| 0.0004 | 1672995463.306517 | 0.089775 | 8 | 6 | 2023-01-06 16:57:43.306517 | 19 | 20 | 0.0115 | 0 | 0 | 19512 | -0.0111 | 110 | 64 | 1672995463.306517 | 21 | 250000 | 2023-01-06 16:57:43.306517 | 64 | 1672995463.396292 | 2023-01-06 16:57:43.396292 | PHY_PX_DIST_TRANSMIT | 0.089775 | 114402 | 0 | 0 | 1672995463.396292 | 1672995463396292 | 0 | 192.168.1.77 | 2023-01-06 16:57:43.396292 | 10 |
| 0.0001 | 1672995463.299352 | 0.048983 | 0 | 7 | 2023-01-06 16:57:43.299352 | 0 | 23 | 0.0000 | 0 | 22 | 19510 | 0.0001 | 0 | 0 | 1672995463.299352 | 0 | 250000 | 2023-01-06 16:57:43.299352 | 0 | 1672995463.348335 | 2023-01-06 16:57:43.348335 | PHY_GRANULE_ITERATOR | 0.046869 | 114401 | 0 | 0 | 1672995463.346221 | 1 | 0 | 192.168.1.77 | 2023-01-06 16:57:43.346221 | 11 |
| 0.0001 | 1672995463.299352 | 0.082076 | 0 | 7 | 2023-01-06 16:57:43.299352 | 0 | 23 | 0.0000 | 0 | 22 | 19510 | 0.0001 | 0 | 0 | 1672995463.299352 | 0 | 250000 | 2023-01-06 16:57:43.299352 | 0 | 1672995463.381428 | 2023-01-06 16:57:43.381428 | PHY_GRANULE_ITERATOR | 0.082076 | 114403 | 0 | 0 | 1672995463.381428 | 1 | 0 | 192.168.1.77 | 2023-01-06 16:57:43.381428 | 11 |
| 0.0001 | 1672995463.302174 | 0.054995 | 0 | 7 | 2023-01-06 16:57:43.302174 | 0 | 23 | 0.0000 | 0 | 22 | 19512 | 0.0001 | 0 | 0 | 1672995463.302174 | 0 | 250000 | 2023-01-06 16:57:43.302174 | 0 | 1672995463.357169 | 2023-01-06 16:57:43.357169 | PHY_GRANULE_ITERATOR | 0.053948 | 114400 | 0 | 0 | 1672995463.356122 | 1 | 0 | 192.168.1.77 | 2023-01-06 16:57:43.356122 | 11 |
| 0.0001 | 1672995463.306517 | 0.089775 | 0 | 7 | 2023-01-06 16:57:43.306517 | 0 | 23 | 0.0000 | 0 | 22 | 19512 | 0.0001 | 0 | 0 | 1672995463.306517 | 0 | 250000 | 2023-01-06 16:57:43.306517 | 0 | 1672995463.396292 | 2023-01-06 16:57:43.396292 | PHY_GRANULE_ITERATOR | 0.088698 | 114402 | 0 | 0 | 1672995463.395215 | 1 | 0 | 192.168.1.77 | 2023-01-06 16:57:43.395215 | 11 |
| 0.0082 | 1672995463.299352 | 0.048983 | 0 | 8 | 2023-01-06 16:57:43.299352 | 0 | 0 | 0.0000 | 0 | 0 | 19510 | 0.0082 | 0 | 0 | 1672995463.299352 | 0 | 250000 | 2023-01-06 16:57:43.299352 | 0 | 1672995463.348335 | 2023-01-06 16:57:43.348335 | PHY_TABLE_SCAN | 0.046869 | 114401 | 0 | 0 | 1672995463.346221 | 0 | 0 | 192.168.1.77 | 2023-01-06 16:57:43.346221 | 12 |
| 0.0074 | 1672995463.299352 | 0.082076 | 0 | 8 | 2023-01-06 16:57:43.299352 | 0 | 0 | 0.0000 | 0 | 0 | 19510 | 0.0074 | 0 | 0 | 1672995463.299352 | 0 | 250000 | 2023-01-06 16:57:43.299352 | 0 | 1672995463.381428 | 2023-01-06 16:57:43.381428 | PHY_TABLE_SCAN | 0.082076 | 114403 | 0 | 0 | 1672995463.381428 | 0 | 0 | 192.168.1.77 | 2023-01-06 16:57:43.381428 | 12 |
| 0.0087 | 1672995463.302174 | 0.054995 | 0 | 8 | 2023-01-06 16:57:43.302174 | 0 | 0 | 0.0000 | 0 | 0 | 19512 | 0.0087 | 0 | 0 | 1672995463.302174 | 0 | 250000 | 2023-01-06 16:57:43.302174 | 0 | 1672995463.357169 | 2023-01-06 16:57:43.357169 | PHY_TABLE_SCAN | 0.053948 | 114400 | 0 | 0 | 1672995463.356122 | 0 | 0 | 192.168.1.77 | 2023-01-06 16:57:43.356122 | 12 |
| 0.0081 | 1672995463.306517 | 0.089775 | 0 | 8 | 2023-01-06 16:57:43.306517 | 0 | 0 | 0.0000 | 0 | 0 | 19512 | 0.0081 | 0 | 0 | 1672995463.306517 | 0 | 250000 | 2023-01-06 16:57:43.306517 | 0 | 1672995463.396292 | 2023-01-06 16:57:43.396292 | PHY_TABLE_SCAN | 0.088698 | 114402 | 0 | 0 | 1672995463.395215 | 0 | 0 | 192.168.1.77 | 2023-01-06 16:57:43.395215 | 12 |
View Ordered by Operator
View Ordered by Threads
select AVG(ROWS) EST_ROWS, /*0*/ plan_monitor.PLAN_DEPTH PLAN_DEPTH, plan_monitor.PLAN_LINE_ID PLAN_LINE_ID, PLAN_OPERATION, COUNT(*) PARALLEL, MIN(FIRST_REFRESH_TIME) MIN_FIRST_REFRESH_TIME,/*5*/ MAX(LAST_REFRESH_TIME) MAX_LAST_REFRESH_TIME, MIN(FIRST_CHANGE_TIME) MIN_FIRST_CHANGE_TIME, MAX(LAST_CHANGE_TIME) MAX_LAST_CHANGE_TIME, UNIX_TIMESTAMP(MIN(FIRST_REFRESH_TIME)) MIN_FIRST_REFRESH_TS, UNIX_TIMESTAMP(MAX(LAST_REFRESH_TIME)) MAX_LAST_REFRESH_TS, /*10*/ UNIX_TIMESTAMP(MIN(FIRST_CHANGE_TIME)) MIN_FIRST_CHANGE_TS, UNIX_TIMESTAMP(MAX(LAST_CHANGE_TIME)) MAX_LAST_CHANGE_TS, AVG(TIMESTAMPDIFF(MICROSECOND, FIRST_REFRESH_TIME, LAST_REFRESH_TIME)) AVG_REFRESH_TIME, MAX(TIMESTAMPDIFF(MICROSECOND, FIRST_REFRESH_TIME, LAST_REFRESH_TIME)) MAX_REFRESH_TIME, MIN(TIMESTAMPDIFF(MICROSECOND, FIRST_REFRESH_TIME, LAST_REFRESH_TIME)) MIN_REFRESH_TIME, /*15 */ AVG(TIMESTAMPDIFF(MICROSECOND, FIRST_CHANGE_TIME, LAST_CHANGE_TIME)) AVG_CHANGE_TIME, MAX(TIMESTAMPDIFF(MICROSECOND, FIRST_CHANGE_TIME, LAST_CHANGE_TIME)) MAX_CHANGE_TIME, MIN(TIMESTAMPDIFF(MICROSECOND, FIRST_CHANGE_TIME, LAST_CHANGE_TIME)) MIN_CHANGE_TIME, SUM(OUTPUT_ROWS) TOTAL_OUTPUT_ROWS, (MAX(TIMESTAMPDIFF(MICROSECOND, FIRST_CHANGE_TIME, LAST_CHANGE_TIME)) - MIN(TIMESTAMPDIFF(MICROSECOND, FIRST_CHANGE_TIME, LAST_CHANGE_TIME))) / MAX(TIMESTAMPDIFF(MICROSECOND, FIRST_CHANGE_TIME, LAST_CHANGE_TIME)+0.00000001) SKEWNESS, SUM(STARTS) TOTAL_RESCAN_TIMES,/* 20 */ MAX(OTHERSTAT_1_ID) OTHERSTAT_1_ID, SUM(OTHERSTAT_1_VALUE) SUM_STAT_1, MAX(OTHERSTAT_1_VALUE) MAX_STAT_1, MIN(OTHERSTAT_1_VALUE) MIN_STAT_1, AVG(OTHERSTAT_1_VALUE) AVG_STAT_1, /* 25 */ MAX(OTHERSTAT_2_ID) OTHERSTAT_2_ID, SUM(OTHERSTAT_2_VALUE) SUM_STAT_2, MAX(OTHERSTAT_2_VALUE) MAX_STAT_2, MIN(OTHERSTAT_2_VALUE) MIN_STAT_2, AVG(OTHERSTAT_2_VALUE) AVG_STAT_2, /* 30 */ MAX(OTHERSTAT_3_ID) OTHERSTAT_3_ID, SUM(OTHERSTAT_3_VALUE) SUM_STAT_3, MAX(OTHERSTAT_3_VALUE) MAX_STAT_3, MIN(OTHERSTAT_3_VALUE) MIN_STAT_3, AVG(OTHERSTAT_3_VALUE) AVG_STAT_3, /* 35 */ MAX(OTHERSTAT_4_ID) OTHERSTAT_4_ID, SUM(OTHERSTAT_4_VALUE) SUM_STAT_4, MAX(OTHERSTAT_4_VALUE) MAX_STAT_4, MIN(OTHERSTAT_4_VALUE) MIN_STAT_4, AVG(OTHERSTAT_4_VALUE) AVG_STAT_4, /* 40 */ MAX(OTHERSTAT_5_ID) OTHERSTAT_5_ID, SUM(OTHERSTAT_5_VALUE) SUM_STAT_5, MAX(OTHERSTAT_5_VALUE) MAX_STAT_5, MIN(OTHERSTAT_5_VALUE) MIN_STAT_5, AVG(OTHERSTAT_5_VALUE) AVG_STAT_5, /* 45*/ MAX(OTHERSTAT_6_ID) OTHERSTAT_6_ID, SUM(OTHERSTAT_6_VALUE) SUM_STAT_6, MAX(OTHERSTAT_6_VALUE) MAX_STAT_6, MIN(OTHERSTAT_6_VALUE) MIN_STAT_6, AVG(OTHERSTAT_6_VALUE) AVG_STAT_6 /* 50 */, TRUNCATE(AVG(DB_TIME)/1000000000.0/2.5, 4) MY_DB_TIME, TRUNCATE(AVG(DB_TIME-USER_IO_WAIT_TIME)/1000000000.0/2.5, 4) MY_CPU_TIME, TRUNCATE(AVG(USER_IO_WAIT_TIME)/1000000000.0/2.5, 4) MY_IO_TIME from ( select * FROM oceanbase.gv$sql_plan_monitor where trace_id = 'Y4C360B9E1F4D-0005F192D9891CC0-0-0' ) plan_monitor LEFT JOIN ( SELECT ROWS, PLAN_LINE_ID FROM oceanbase.gv$ob_plan_cache_plan_explain WHERE plan_id = 463 AND tenant_id = 1004 ) plan_explain ON plan_monitor.PLAN_LINE_ID = plan_explain.PLAN_LINE_ID GROUP BY plan_monitor.PLAN_LINE_ID, plan_monitor.PLAN_OPERATION ORDER BY plan_monitor.PLAN_LINE_ID ASC;
select PLAN_DEPTH, PLAN_LINE_ID, PLAN_OPERATION, COUNT(*) PARALLEL, MIN(FIRST_REFRESH_TIME) MIN_FIRST_REFRESH_TIME, MAX(LAST_REFRESH_TIME) MAX_LAST_REFRESH_TIME, MIN(FIRST_CHANGE_TIME) MIN_FIRST_CHANGE_TIME, MAX(LAST_CHANGE_TIME) MAX_LAST_CHANGE_TIME, UNIX_TIMESTAMP(MIN(FIRST_REFRESH_TIME)) MIN_FIRST_REFRESH_TS, UNIX_TIMESTAMP(MAX(LAST_REFRESH_TIME)) MAX_LAST_REFRESH_TS, UNIX_TIMESTAMP(MIN(FIRST_CHANGE_TIME)) MIN_FIRST_CHANGE_TS, UNIX_TIMESTAMP(MAX(LAST_CHANGE_TIME)) MAX_LAST_CHANGE_TS, AVG(TIMESTAMPDIFF(MICROSECOND, FIRST_REFRESH_TIME, LAST_REFRESH_TIME)) AVG_REFRESH_TIME, MAX(TIMESTAMPDIFF(MICROSECOND, FIRST_REFRESH_TIME, LAST_REFRESH_TIME)) MAX_REFRESH_TIME, MIN(TIMESTAMPDIFF(MICROSECOND, FIRST_REFRESH_TIME, LAST_REFRESH_TIME)) MIN_REFRESH_TIME, AVG(TIMESTAMPDIFF(MICROSECOND, FIRST_CHANGE_TIME, LAST_CHANGE_TIME)) AVG_CHANGE_TIME, MAX(TIMESTAMPDIFF(MICROSECOND, FIRST_CHANGE_TIME, LAST_CHANGE_TIME)) MAX_CHANGE_TIME, MIN(TIMESTAMPDIFF(MICROSECOND, FIRST_CHANGE_TIME, LAST_CHANGE_TIME)) MIN_CHANGE_TIME, SUM(OUTPUT_ROWS) TOTAL_OUTPUT_ROWS, (MAX(TIMESTAMPDIFF(MICROSECOND, FIRST_CHANGE_TIME, LAST_CHANGE_TIME)) - MIN(TIMESTAMPDIFF(MICROSECOND, FIRST_CHANGE_TIME, LAST_CHANGE_TIME))) / MAX(TIMESTAMPDIFF(MICROSECOND, FIRST_CHANGE_TIME, LAST_CHANGE_TIME)) SKEWNESS, SUM(STARTS) TOTAL_RESCAN_TIMES, SVR_IP, SVR_PORT, MAX(OTHERSTAT_1_VALUE) MAX_STAT_1, MIN(OTHERSTAT_1_VALUE) MIN_STAT_1, AVG(OTHERSTAT_1_VALUE) AVG_STAT_1, MAX(OTHERSTAT_2_VALUE) MAX_STAT_2, MIN(OTHERSTAT_2_VALUE) MIN_STAT_2, AVG(OTHERSTAT_2_VALUE) AVG_STAT_2, MAX(OTHERSTAT_3_VALUE) MAX_STAT_3, MIN(OTHERSTAT_3_VALUE) MIN_STAT_3, AVG(OTHERSTAT_3_VALUE) AVG_STAT_3, MAX(OTHERSTAT_4_VALUE) MAX_STAT_4, MIN(OTHERSTAT_4_VALUE) MIN_STAT_4, AVG(OTHERSTAT_4_VALUE) AVG_STAT_4, MAX(OTHERSTAT_5_VALUE) MAX_STAT_5, MIN(OTHERSTAT_5_VALUE) MIN_STAT_5, AVG(OTHERSTAT_5_VALUE) AVG_STAT_5, MAX(OTHERSTAT_6_VALUE) MAX_STAT_6, MIN(OTHERSTAT_6_VALUE) MIN_STAT_6, AVG(OTHERSTAT_6_VALUE) AVG_STAT_6, TRUNCATE(AVG(DB_TIME)/1000000000.0/2.5, 4) MY_DB_TIME, TRUNCATE(AVG(DB_TIME-USER_IO_WAIT_TIME)/1000000000.0/2.5, 4) MY_CPU_TIME, TRUNCATE(AVG(USER_IO_WAIT_TIME)/1000000000.0/2.5, 4) MY_IO_TIME from oceanbase.gv$sql_plan_monitor where trace_id = 'Y4C360B9E1F4D-0005F192D9891CC0-0-0' GROUP BY PLAN_LINE_ID,PLAN_OPERATION,SVR_IP,SVR_PORT ORDER BY PLAN_LINE_ID ASC, MAX_CHANGE_TIME ASC, SVR_IP, SVR_PORT;
select
PLAN_DEPTH,/*0*/
SVR_IP,
SVR_PORT,
PROCESS_NAME,
PLAN_LINE_ID,
PLAN_OPERATION, /*5*/
OUTPUT_ROWS,
STARTS RESCAN_TIMES,
FIRST_REFRESH_TIME,
LAST_REFRESH_TIME,
FIRST_CHANGE_TIME,/*10*/
LAST_CHANGE_TIME,
UNIX_TIMESTAMP(FIRST_REFRESH_TIME) FIRST_REFRESH_TS,
UNIX_TIMESTAMP(LAST_REFRESH_TIME) LAST_REFRESH_TS,
UNIX_TIMESTAMP(LAST_REFRESH_TIME) - UNIX_TIMESTAMP(FIRST_REFRESH_TIME) REFRESH_TS,
UNIX_TIMESTAMP(FIRST_CHANGE_TIME) FIRST_CHANGE_TS, /*15*/
UNIX_TIMESTAMP(LAST_CHANGE_TIME) LAST_CHANGE_TS,
UNIX_TIMESTAMP(LAST_CHANGE_TIME) - UNIX_TIMESTAMP(FIRST_CHANGE_TIME) CHANGE_TS,
OTHERSTAT_1_ID,
OTHERSTAT_1_VALUE,
OTHERSTAT_2_ID, /*20*/
OTHERSTAT_2_VALUE,
OTHERSTAT_3_ID,
OTHERSTAT_3_VALUE,
OTHERSTAT_4_ID,
OTHERSTAT_4_VALUE, /*25*/
OTHERSTAT_5_ID,
OTHERSTAT_5_VALUE,
OTHERSTAT_6_ID,
OTHERSTAT_6_VALUE,
TRUNCATE((DB_TIME)/1000000000.0/2.5, 4) MY_DB_TIME,
TRUNCATE((DB_TIME-USER_IO_WAIT_TIME)/1000000000.0/2.5, 4) MY_CPU_TIME,
TRUNCATE((USER_IO_WAIT_TIME)/1000000000.0/2.5, 4) MY_IO_TIME
from
oceanbase.gv$sql_plan_monitor
where
trace_id = 'Y4C360B9E1F4D-0005F192D9891CC0-0-0'
ORDER BY
PLAN_LINE_ID ASC, SVR_IP, SVR_PORT, CHANGE_TS, PROCESS_NAME ASC;