通过本文您可以了解云数据库OceanBase版的监控项。

当您调用云监控的API接口时,需要获取当前云产品的NamespacePeriod,具体取值如下:

  • Namespaceacs_oceanbase
  • Period默认为60秒,也可以为60的整数倍。

当前云产品的MetricNameDimensions的取值如下表所示。

监控项 单位 监控项分类 MetricName Dimensions Statistics
活跃memstore内存使用率 % 租户 active_memstore_percent_by_trigger_tenant userId、obClusterId、obTenantId Average
集群活跃连接数 Count 集群 active_sessions userId、obClusterId Sum
active_sessions_instance Count 节点 active_sessions_instance userId、obClusterId、obInstanceId Average
active_sessions_max_tenant % 节点 active_sessions_max_tenant userId、obClusterId、obTenantId Max
active_sessions_tenant Count 租户 active_sessions_tenant userId、obClusterId、obTenantId Sum
core_count_instance Count 节点 core_count_instance userId、obClusterId、obInstanceId Average
平均CPU使用核数 % 租户 cpu_usage_avg_tenant userId、obClusterId、obTenantId Average
最大CPU使用核数 % 租户 cpu_usage_max_tenant userId、obClusterId、obTenantId Max
CPU最大使用率 % 租户 cpu_usage_percent_max_tenant userId、obClusterId、obTenantId Max
CPU使用率 % 租户 cpu_usage_percent_tenant userId、obClusterId、obTenantId Average
CPU使用率 % 节点 cpu_util_instance userId、obClusterId、obInstanceId Average
disk_data_size_instance GB 节点 disk_data_size_instance userId、obClusterId、obInstanceId Average
disk_data_usage_instance % 节点 disk_data_usage_instance userId、obClusterId、obInstanceId Average
disk_genernal_size_instance GB 节点 disk_genernal_size_instance userId、obClusterId、obInstanceId Average
disk_genernal_usage_instance % 节点 disk_genernal_usage_instance userId、obClusterId、obInstanceId Average
日志盘使用量 GB 节点 disk_log_size_instance userId、obClusterId、obInstanceId Average
日志盘使用率 % 节点 disk_log_usage_instance userId、obClusterId、obInstanceId Average
最大磁盘使用量 Byte 集群 disk_ob_data_size userId、obClusterId Max
磁盘使用量 GB 节点 disk_ob_data_size_instance userId、obClusterId、obInstanceId Average
最大磁盘使用量 Byte 租户 disk_ob_data_size_tenant userId、obClusterId、obTenantId、obZoneId Max
最大磁盘使用率 % 集群 disk_ob_data_usage userId、obClusterId Max
磁盘使用率 % 节点 disk_ob_data_usage_instance userId、obClusterId、obInstanceId Average
election_event_history_row_count Count 集群 election_event_history_row_count userId、obClusterId Average
idle_sessions_instance Count 节点 idle_sessions_instance userId、obClusterId、obInstanceId Average
磁盘IO等待 Millisecond 节点 io_await_instance userId、obClusterId、obInstanceId Average
io_read_bytes Count 集群 io_read_bytes userId、obClusterId Sum
磁盘读 Byte/s 节点 io_read_bytes_instance userId、obClusterId、obInstanceId Average
io_read_bytes_tenant Count 租户 io_read_bytes_tenant userId、obClusterId、obTenantId Sum
io_read_count Count 集群 io_read_count userId、obClusterId Sum
读磁盘次数 % 节点 io_read_count_instance userId、obClusterId、obInstanceId Average
读磁盘次数 Count 租户 io_read_count_tenant userId、obClusterId、obTenantId Sum
io_read_delay Millisecond 集群 io_read_delay userId、obClusterId Sum
io_read_delay_instance % 节点 io_read_delay_instance userId、obClusterId、obInstanceId Average
io_read_delay_tenant Count 租户 io_read_delay_tenant userId、obClusterId、obTenantId Sum
io_read_rt Millisecond 集群 io_read_rt userId、obClusterId Average
读磁盘响应时间 Millisecond 节点 io_read_rt_instance userId、obClusterId、obInstanceId Average
读磁盘响应时间 Millisecond 租户 io_read_rt_tenant userId、obClusterId、obTenantId Average
io_write_bytes Count 集群 io_write_bytes userId、obClusterId Sum
磁盘写 Byte/s 节点 io_write_bytes_instance userId、obClusterId、obInstanceId Average
io_write_bytes_tenant Count 租户 io_write_bytes_tenant userId、obClusterId、obTenantId Sum
io_write_count Count 集群 io_write_count userId、obClusterId Sum
写磁盘次数 % 节点 io_write_count_instance userId、obClusterId、obInstanceId Average
写磁盘次数 Count 租户 io_write_count_tenant userId、obClusterId、obTenantId Sum
io_write_delay ms 集群 io_write_delay userId、obClusterId Sum
io_write_delay_instance % 节点 io_write_delay_instance userId、obClusterId、obInstanceId Average
io_write_delay_tenant Count 租户 io_write_delay_tenant userId、obClusterId、obTenantId Sum
io_write_rt Millisecond 集群 io_write_rt userId、obClusterId Average
写磁盘响应时间 Millisecond 节点 io_write_rt_instance userId、obClusterId、obInstanceId Average
写磁盘响应时间 Millisecond 租户 io_write_rt_tenant userId、obClusterId、obTenantId Average
Load % 节点 load_load1_instance userId、obClusterId、obInstanceId Average
location_cache_hit_percent % 集群 location_cache_hit_percent userId、obClusterId Average
location_cache_hit_percent_instance % 节点 location_cache_hit_percent_instance userId、obClusterId、obInstanceId Average
location_cache_hit_percent_tenant % 租户 location_cache_hit_percent_tenant userId、obClusterId、obTenantId Average
机器内存使用率 % 节点 machine_mem_used_percent_instance userId、obClusterId、obInstanceId Average
内存使用率 % 租户 memory_usage_tenant userId、obClusterId、obTenantId Max
ntp时钟偏移 Millisecond 节点 ntp_offset_instance userId、obClusterId、obInstanceId Average
ob_server_inactive_count_instance Count 节点 ob_server_inactive_count_instance userId、obClusterId、obInstanceId Average
ob_sys_clog_unsync_instance Count 节点 ob_sys_clog_unsync_instance userId、obClusterId、obInstanceId Average
ob_sys_daily_merge_error_instance Count 节点 ob_sys_daily_merge_error_instance userId、obClusterId、obInstanceId Average
ob_sys_daily_merge_stopped_instance Count 节点 ob_sys_daily_merge_stopped_instance userId、obClusterId、obInstanceId Average
ob_sys_daily_merge_timeout_instance Count 节点 ob_sys_daily_merge_timeout_instance userId、obClusterId、obInstanceId Average
ob_sys_disk_invalid_instance Count 节点 ob_sys_disk_invalid_instance userId、obClusterId、obInstanceId Average
ob_sys_election_info_instance Count 节点 ob_sys_election_info_instance userId、obClusterId、obInstanceId Average
ob_sys_leader_election_instance Count 节点 ob_sys_leader_election_instance userId、obClusterId、obInstanceId Average
租户单节点活跃内存百分比 % 租户 ob_tenant.active_memstore_percent_by_node userId、obClusterId、obTenantId、obInstanceId Average
租户单节点负载 % 租户 ob_tenant.cpu_percent_by_node userId、obClusterId、obTenantId、obInstanceId Average
租户单节点memstore百分比 % 租户 ob_tenant.total_memstore_percent_by_node userId、obClusterId、obTenantId、obInstanceId Average
OBServer进程ID Count 节点 observer_process_id userId、obClusterId、obInstanceId Average
OBServer进程状态 Count 节点 observer_process_kernel_status userId、obClusterId、obInstanceId Average
qps Count 集群 qps userId、obClusterId Sum
读请求量 Count 节点 qps_instance userId、obClusterId、obInstanceId Average
qps_rt Millisecond 集群 qps_rt userId、obClusterId Average
读请求响应时间 Millisecond 节点 qps_rt_instance userId、obClusterId、obInstanceId Average
读请求响应时间 Millisecond 租户 qps_rt_tenant userId、obClusterId、obTenantId Average
读请求量 Count 租户 qps_tenant userId、obClusterId、obTenantId Sum
request_dequeue_count_tenant Count 租户 request_dequeue_count_tenant userId、obClusterId、obTenantId Sum
等待队列 Millisecond 集群 request_queue_rt userId、obClusterId Average
等待队列 Millisecond 租户 request_queue_rt_tenant userId、obClusterId、obTenantId Average
rootservice_event_history_row_count Count 集群 rootservice_event_history_row_count userId、obClusterId Average
rpc_packet_in_bytes_ps_tenant Count 租户 rpc_packet_in_bytes_ps_tenant userId、obClusterId、obTenantId Sum
server_event_history_row_count Count 集群 server_event_history_row_count userId、obClusterId Average
delete请求量 Count 集群 sql_delete_count userId、obClusterId Sum
sql_delete_count_instance Count 节点 sql_delete_count_instance userId、obClusterId、obInstanceId Average
delete请求量 Count 租户 sql_delete_count_tenant userId、obClusterId、obTenantId Sum
delete请求响应时间 Millisecond 集群 sql_delete_rt userId、obClusterId Average
sql_delete_rt_instance Millisecond 节点 sql_delete_rt_instance userId、obClusterId、obInstanceId Average
delete请求响应时间 Millisecond 租户 sql_delete_rt_tenant userId、obClusterId、obTenantId Average
分布式计划请求量 Count 集群 sql_distributed_count userId、obClusterId Sum
sql_distributed_count_instance Count 节点 sql_distributed_count_instance userId、obClusterId、obInstanceId Average
分布式计划请求量 Count 租户 sql_distributed_count_tenant userId、obClusterId、obTenantId Sum
sql_dml_rt Millisecond 集群 sql_dml_rt userId、obClusterId Sum
sql_dml_rt_instance Millisecond 节点 sql_dml_rt_instance userId、obClusterId、obInstanceId Average
sql_dml_rt_tenant Millisecond 租户 sql_dml_rt_tenant userId、obClusterId、obTenantId Average
insert请求量 Count 集群 sql_insert_count userId、obClusterId Sum
sql_insert_count_instance Count 节点 sql_insert_count_instance userId、obClusterId、obInstanceId Average
insert请求量 Count 租户 sql_insert_count_tenant userId、obClusterId、obTenantId Sum
insert请求响应时间 Millisecond 集群 sql_insert_rt userId、obClusterId Average
sql_insert_rt_instance Millisecond 节点 sql_insert_rt_instance userId、obClusterId、obInstanceId Average
insert请求响应时间 Millisecond 租户 sql_insert_rt_tenant userId、obClusterId、obTenantId Average
远程计划请求数量 Count 集群 sql_remote_count userId、obClusterId Sum
sql_remote_count_instance Count 节点 sql_remote_count_instance userId、obClusterId、obInstanceId Average
远程计划请求量 Count 租户 sql_remote_count_tenant userId、obClusterId、obTenantId Sum
replace请求量 Count 集群 sql_replace_count userId、obClusterId Sum
sql_replace_count_instance Count 节点 sql_replace_count_instance userId、obClusterId、obInstanceId Average
replace请求量 Count 租户 sql_replace_count_tenant userId、obClusterId、obTenantId Sum
replace请求响应时间 Millisecond 集群 sql_replace_rt userId、obClusterId Average
sql_replace_rt_instance Millisecond 节点 sql_replace_rt_instance userId、obClusterId、obInstanceId Average
replace请求响应时间 Millisecond 租户 sql_replace_rt_tenant userId、obClusterId、obTenantId Average
select请求量 Count 集群 sql_select_count userId、obClusterId Sum
sql_select_count_instance Count 节点 sql_select_count_instance userId、obClusterId、obInstanceId Average
select请求量 Count 租户 sql_select_count_tenant userId、obClusterId、obTenantId Sum
select请求响应时间 Millisecond 集群 sql_select_rt userId、obClusterId Average
sql_select_rt_instance Microsecond 节点 sql_select_rt_instance userId、obClusterId、obInstanceId Average
select请求响应时间 Millisecond 租户 sql_select_rt_tenant userId、obClusterId、obTenantId Average
update请求量 Count 集群 sql_update_count userId、obClusterId Sum
sql_update_count_instance Count 节点 sql_update_count_instance userId、obClusterId、obInstanceId Average
update请求量 Count 租户 sql_update_count_tenant userId、obClusterId、obTenantId Sum
update请求响应时间 Millisecond 集群 sql_update_rt userId、obClusterId Average
sql_update_rt_instance Microsecond 节点 sql_update_rt_instance userId、obClusterId、obInstanceId Average
update请求响应时间 Millisecond 节点 sql_update_rt_tenant userId、obClusterId、obTenantId Average
storage_delete_row_count Count 集群 storage_delete_row_count userId、obClusterId Sum
storage_delete_row_count_instance Count 节点 storage_delete_row_count_instance userId、obClusterId、obInstanceId Average
storage_delete_row_count_tenant Count 租户 storage_delete_row_count_tenant userId、obClusterId、obTenantId Sum
storage_insert_row_count Count 集群 storage_insert_row_count userId、obClusterId Sum
storage_insert_row_count_instance Count 节点 storage_insert_row_count_instance userId、obClusterId、obInstanceId Average
storage_insert_row_count_tenant Count 租户 storage_insert_row_count_tenant userId、obClusterId、obTenantId Sum
storage_read_row_count Count 租户 storage_read_row_count userId、obClusterId、obTenantId Sum
storage_read_row_count_instance Count 节点 storage_read_row_count_instance userId、obClusterId、obInstanceId Average
storage_update_row_count Count 集群 storage_update_row_count userId、obClusterId Sum
storage_update_row_count_instance Count 节点 storage_update_row_count_instance userId、obClusterId、obInstanceId Average
storage_update_row_count_tenant Count 租户 storage_update_row_count_tenant userId、obClusterId、obTenantId Sum
机器的TCP包重传率 % 节点 tcp_retran_instance userId、obClusterId、obInstanceId Average
memstore内存使用率 % 租户 total_memstore_percent_by_limit_tenant userId、obClusterId、obTenantId Max
total_memstore_used_instance Byte 节点 total_memstore_used_instance userId、obClusterId、obInstanceId Average
memstore内存使用量 Count 租户 total_memstore_used_tenant userId、obClusterId、obTenantId Sum
total_sessions_instance Count 节点 total_sessions_instance userId、obClusterId、obInstanceId Average
tps Count 集群 tps userId、obClusterId Sum
写请求量 Count 节点 tps_instance userId、obClusterId、obInstanceId Average
tps_rt Millisecond 集群 tps_rt userId、obClusterId Average
写请求响应时间 Millisecond 节点 tps_rt_instance userId、obClusterId、obInstanceId Average
写请求响应时间 Millisecond 租户 tps_rt_tenant userId、obClusterId、obTenantId Max
写请求量 Count 租户 tps_tenant userId、obClusterId、obTenantId Sum
机器的包流入速率 Byte/s 节点 traffic_bytin_instance userId、obClusterId、obInstanceId Average
机器的包流出速率 Byte/s 节点 traffic_bytout_instance userId、obClusterId、obInstanceId Average
事务提交量 Count 集群 trans_commit_count userId、obClusterId Sum
trans_commit_count_instance Count 节点 trans_commit_count_instance userId、obClusterId、obInstanceId Average
事务提交量 Count 租户 trans_commit_count_tenant userId、obClusterId、obTenantId Sum
事务提交响应时间 Millisecond 集群 trans_commit_rt userId、obClusterId Average
trans_commit_rt_instance Millisecond 节点 trans_commit_rt_instance userId、obClusterId、obInstanceId Average
事务提交响应时间 Millisecond 租户 trans_commit_rt_tenant userId、obClusterId、obTenantId Max
trans_multi_partition_count Count 节点 trans_multi_partition_count userId、obClusterId、obInstanceId Average
trans_multi_partition_count_tenant Count 租户 trans_multi_partition_count_tenant userId、obClusterId、obTenantId Sum
事务回滚量 Count 集群 trans_rollback_count userId、obClusterId Sum
trans_rollback_count_instance Count 节点 trans_rollback_count_instance userId、obClusterId、obInstanceId Average
事务回滚量 Count 租户 trans_rollback_count_tenant userId、obClusterId、obTenantId Sum
事务回滚响应时间 Millisecond 集群 trans_rollback_rt userId、obClusterId Average
trans_rollback_rt_instance Millisecond 节点 trans_rollback_rt_instance userId、obClusterId、obInstanceId Average
事务回滚响应时间 Millisecond 租户 trans_rollback_rt_tenant userId、obClusterId、obTenantId Average
trans_single_partition_count Count 集群 trans_single_partition_count userId、obClusterId Sum
trans_single_partition_count_instance Count 节点 trans_single_partition_count_instance userId、obClusterId、obInstanceId Average
trans_single_partition_count_tenant Count 租户 trans_single_partition_count_tenant userId、obClusterId、obTenantId Sum
事务超时量 Count 集群 trans_timeout_count userId、obClusterId Sum
trans_timeout_count_instance Count 节点 trans_timeout_count_instance userId、obClusterId、obInstanceId Average
事务超时量 Count 租户 trans_timeout_count_tenant userId、obClusterId、obTenantId Sum