腾讯云可观测平台 弹性 MapReduce(PrestoSQL)

这篇说说了腾讯云弹性 MapReduce(PrestoSQL)监控数据的查询方法,包括不同维度下的入参设置。文中详细列出了查询概览、Worker 和 Coordinator 监控数据时的具体参数取值方式。查询弹性 MapReduce(PrestoSQL-概览)监控数据,需设置 Namespace 为 QCE/TXMR_PRESTOSQL ,并指定 Instances.N.Dimensions.0.Name 为 id4。

相关产品
腾讯云可观测平台 产品页,含版本规格、价格与购买入口。

一、命名空间

Namespace = QCE/TXMR_PRESTOSQL

二、监控指标

指标英文名 指标中文名 说明 单位 维度 统计规则
[period, statType]
PrestosqlMDataRateInputdatasizeoneminute PrestoSQLM_数据输入输出速率_InputDataSizeOneMinute 数据输入输出速率_InputDataSizeOneMinute GiBytes id4prestosqloverview [ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
PrestosqlMDataRateOutputdatasizeoneminute PrestoSQLM_数据输入输出速率_OutputDataSizeOneMinute 数据输入输出速率_OutputDataSizeOneMinute GiBytes id4prestosqloverview [ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
PrestosqlMGcUtilGcCountFgc PrestoSQLM_GC次数_FGC GC次数_FGC Count host4prestosqlprestosqlcoordinator
id4prestosqlprestosqlcoordinator
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
PrestosqlMGcUtilGcCountYgc PrestoSQLM_GC次数_YGC GC次数_YGC Count host4prestosqlprestosqlcoordinator
id4prestosqlprestosqlcoordinator
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
PrestosqlMGcUtilGcTimeFgct PrestoSQLM_GC时间_FGCT GC时间_FGCT s host4prestosqlprestosqlcoordinator
id4prestosqlprestosqlcoordinator
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
PrestosqlMGcUtilGcTimeGct PrestoSQLM_GC时间_GCT GC时间_GCT s id4prestosqlprestosqlcoordinator
host4prestosqlprestosqlcoordinator
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
PrestosqlMGcUtilGcTimeYgct PrestoSQLM_GC时间_YGCT GC时间_YGCT s host4prestosqlprestosqlcoordinator
id4prestosqlprestosqlcoordinator
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
PrestosqlMGcUtilMemoryCcs PrestoSQLM_内存区域占比_CCS 内存区域占比_CCS % host4prestosqlprestosqlcoordinator
id4prestosqlprestosqlcoordinator
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
PrestosqlMGcUtilMemoryE PretoSQLM_内存区域占比_E 内存区域占比_E % id4prestosqlprestosqlcoordinator
host4prestosqlprestosqlcoordinator
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
PrestosqlMGcUtilMemoryM PrestoSQLM_内存区域占比_M 内存区域占比_M % host4prestosqlprestosqlcoordinator
id4prestosqlprestosqlcoordinator
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
PrestosqlMGcUtilMemoryO PrestoSQLM_内存区域占比_O 内存区域占比_O % host4prestosqlprestosqlcoordinator
id4prestosqlprestosqlcoordinator
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
PrestosqlMGcUtilMemoryS0 PrestoSQLM_内存区域占比_S0 内存区域占比_S0 % host4prestosqlprestosqlcoordinator
id4prestosqlprestosqlcoordinator
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
PrestosqlMGcUtilMemoryS1 PrestoSQLM_内存区域占比_S1 内存区域占比_S1 % host4prestosqlprestosqlcoordinator
id4prestosqlprestosqlcoordinator
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
PrestosqlMJvmMemMemheapcommittedm PrestoSQLM_JVM内存_MemHeapCommittedM JVM内存_MemHeapCommittedM MiBytes host4prestosqlprestosqlcoordinator
id4prestosqlprestosqlcoordinator
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
PrestosqlMJvmMemMemheapinitm PrestoSQLM_JVM内存_MemHeapInitM JVM内存_MemHeapInitM MiBytes host4prestosqlprestosqlcoordinator
id4prestosqlprestosqlcoordinator
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
PrestosqlMJvmMemMemheapmaxm PrestoSQLM_JVM内存_MemHeapMaxM JVM内存_MemHeapMaxM MiBytes host4prestosqlprestosqlcoordinator
id4prestosqlprestosqlcoordinator
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
PrestosqlMJvmMemMemheapusedm PrestoSQLM_JVM内存_MemHeapUsedM JVM内存_MemHeapUsedM MiBytes host4prestosqlprestosqlcoordinator
id4prestosqlprestosqlcoordinator
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
PrestosqlMJvmMemMemnonheapcommittedm PrestoSQLM_JVM内存_MemNonHeapCommittedM JVM内存_MemNonHeapCommittedM MiBytes id4prestosqlprestosqlcoordinator
host4prestosqlprestosqlcoordinator
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
PrestosqlMJvmMemMemnonheapinitm PrestoSQLM_JVM内存_MemNonHeapInitM JVM内存_MemNonHeapInitM MiBytes host4prestosqlprestosqlcoordinator
id4prestosqlprestosqlcoordinator
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
PrestosqlMJvmMemMemnonheapusedm PrestoSQLM_JVM内存_MemNonHeapUsedM JVM内存_MemNonHeapUsedM MiBytes host4prestosqlprestosqlcoordinator
id4prestosqlprestosqlcoordinator
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
PrestosqlMNodesActive 节点数量_Active 节点数量_Active Count id4prestosqloverview [ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
PrestosqlMNodesFailed PrestoSQLM_节点数量_Failed 节点数量_Failed Count id4prestosqloverview [ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
PrestosqlMNodesTotal PrestoSQLM_节点数量_Total 节点数量_Total Count id4prestosqloverview [ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
PrestosqlMOsFdCountMaxfiledescriptorcount PrestoSQLM_文件描述符数_MaxFileDescriptorCount 文件描述符数_MaxFileDescriptorCount Count host4prestosqlprestosqlcoordinator
id4prestosqlprestosqlcoordinator
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
PrestosqlMOsFdCountOpenfiledescriptorcount PrestoSQLM_文件描述符数_OpenFileDescriptorCount 文件描述符数_OpenFileDescriptorCount Count id4prestosqlprestosqlcoordinator
host4prestosqlprestosqlcoordinator
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
PrestosqlMQueriesOneMinuteAbandonedqueries PrestoSQLM_查询频度_AbandonedQueries 查询频度_AbandonedQueries Count id4prestosqloverview [ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
PrestosqlMQueriesOneMinuteCanceledqueries PrestoSQLM_查询频度_CanceledQueries 查询频度_CanceledQueries Count id4prestosqloverview [ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
PrestosqlMQueriesOneMinuteCompletedqueries PrestoSQLM_查询频度_CompletedQueries 查询频度_CompletedQueries Count id4prestosqloverview [ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
PrestosqlMQueriesOneMinuteFailedqueries PrestoSQLM_查询频度_FailedQueries 查询频度_FailedQueries Count id4prestosqloverview [ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
PrestosqlMQueriesOneMinuteStartedqueries PrestoSQLM_查询频度_StartedQueries 查询频度_StartedQueries Count id4prestosqloverview [ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
PrestosqlMQueriesOneMinuteSubmittedqueries PrestoSQLM_查询频度_SubmittedQueries 查询频度_SubmittedQueries Count id4prestosqloverview [ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
PrestosqlMQueriesQueuedqueries PrestoSQLM_查询_QueuedQueries 查询_ QueuedQueries Count id4prestosqloverview [ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
PrestosqlMQueriesRunningqueries PrestoSQLM_查询_RunningQueries 查询_RunningQueries Count id4prestosqloverview [ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
PrestosqlMRtUptimeUptime PrestoSQLM_进程运行时间_Uptime 进程运行时间_Uptime s id4prestosqlprestosqlcoordinator
host4prestosqlprestosqlcoordinator
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
PrestosqlMStartTimeStarttime PrestoSQLM_进程启动时间_StartTime 进程启动时间_StartTime s host4prestosqlprestosqlcoordinator
id4prestosqlprestosqlcoordinator
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
PrestosqlMThreadCountDaemonthreadcount PrestoSQLM_线程数量_DaemonThreadCount 线程数量_DaemonThreadCount Count host4prestosqlprestosqlcoordinator
id4prestosqlprestosqlcoordinator
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
PrestosqlMThreadCountPeakthreadcount PrestoSQLM_线程数量_PeakThreadCount 线程数量_PeakThreadCount Count host4prestosqlprestosqlcoordinator
id4prestosqlprestosqlcoordinator
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
PrestosqlMThreadCountThreadcount PrestoSQLM_线程数量_ThreadCount 线程数量_ThreadCount Count host4prestosqlprestosqlcoordinator
id4prestosqlprestosqlcoordinator
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
PrestosqlWDataRateInputdatasizeoneminute PrestoSQLW_数据输入输出速率_InputDataSizeOneMinute 数据输入输出速率_InputDataSizeOneMinute GiBytes id4prestosqlprestosqlworker
host4prestosqlprestosqlworker
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
PrestosqlWDataRateOutputdatasizeoneminute PrestoSQLW_数据输入输出速率_OutputDataSizeOneMinute 数据输入输出速率_OutputDataSizeOneMinute GiBytes host4prestosqlprestosqlworker
id4prestosqlprestosqlworker
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
PrestosqlWGcUtilGcCountFgc PrestoSQLW_GC次数_FGC GC次数_FGC Count host4prestosqlprestosqlworker
id4prestosqlprestosqlworker
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
PrestosqlWGcUtilGcCountYgc PrestoSQLW_GC次数_YGC GC次数_YGC Count host4prestosqlprestosqlworker
id4prestosqlprestosqlworker
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
PrestosqlWGcUtilGcTimeFgct PrestoSQLW_GC时间_FGCT GC时间_FGCT s host4prestosqlprestosqlworker
id4prestosqlprestosqlworker
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
PrestosqlWGcUtilGcTimeGct PrestoSQLW_GC时间_GCT GC时间_GCT s host4prestosqlprestosqlworker
id4prestosqlprestosqlworker
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
PrestosqlWGcUtilGcTimeYgct PrestoSQLW_GC时间_YGCT GC时间_YGCT s host4prestosqlprestosqlworker
id4prestosqlprestosqlworker
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
PrestosqlWGcUtilMemoryCcs PrestoSQLW_内存区域占比_CCS 内存区域占比_CCS % host4prestosqlprestosqlworker
id4prestosqlprestosqlworker
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
PrestosqlWGcUtilMemoryE PrestoSQLW_内存区域占比_E 内存区域占比_E % host4prestosqlprestosqlworker
id4prestosqlprestosqlworker
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
PrestosqlWGcUtilMemoryM PrestoSQLW_内存区域占比_M 内存区域占比_M % host4prestosqlprestosqlworker
id4prestosqlprestosqlworker
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
PrestosqlWGcUtilMemoryO PrestoSQLW_内存区域占比_O 内存区域占比_O % host4prestosqlprestosqlworker
id4prestosqlprestosqlworker
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
PrestosqlWGcUtilMemoryS0 PrestoSQLW_内存区域占比_S0 内存区域占比_S0 % host4prestosqlprestosqlworker
id4prestosqlprestosqlworker
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
PrestosqlWGcUtilMemoryS1 PrestoSQLW_内存区域占比_S1 内存区域占比_S1 % id4prestosqlprestosqlworker
host4prestosqlprestosqlworker
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
PrestosqlWJvmMemMemheapcommittedm PrestoSQLW_JVM内存_MemHeapCommittedM JVM内存_MemHeapCommittedM MiBytes host4prestosqlprestosqlworker
id4prestosqlprestosqlworker
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
PrestosqlWJvmMemMemheapinitm PrestoSQLW_JVM内存_MemHeapInitM JVM内存_MemHeapInitM MiBytes host4prestosqlprestosqlworker
id4prestosqlprestosqlworker
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
PrestosqlWJvmMemMemheapmaxm PrestoSQLW_JVM内存_MemHeapMaxM JVM内存_MemHeapMaxM MiBytes host4prestosqlprestosqlworker
id4prestosqlprestosqlworker
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
PrestosqlWJvmMemMemheapusedm PrestoSQLW_JVM内存_MemHeapUsedM JVM内存_MemHeapUsedM MiBytes host4prestosqlprestosqlworker
id4prestosqlprestosqlworker
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
PrestosqlWJvmMemMemnonheapcommittedm PrestoSQLW_JVM内存_MemNonHeapCommittedM JVM内存_MemNonHeapCommittedM MiBytes id4prestosqlprestosqlworker
host4prestosqlprestosqlworker
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
PrestosqlWJvmMemMemnonheapinitm PrestoSQLW_JVM内存_MemNonHeapInitM JVM内存_MemNonHeapInitM MiBytes host4prestosqlprestosqlworker
id4prestosqlprestosqlworker
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
PrestosqlWJvmMemMemnonheapusedm PrestoSQLW_JVM内存_MemNonHeapUsedM JVM内存_MemNonHeapUsedM MiBytes host4prestosqlprestosqlworker
id4prestosqlprestosqlworker
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
PrestosqlWOsFdCountMaxfiledescriptorcount PrestoSQLW_文件描述符数_MaxFileDescriptorCount 文件描述符数_MaxFileDescriptorCount Count host4prestosqlprestosqlworker
id4prestosqlprestosqlworker
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
PrestosqlWOsFdCountOpenfiledescriptorcount PrestoSQLW_文件描述符数_OpenFileDescriptorCount 文件描述符数_OpenFileDescriptorCount Count host4prestosqlprestosqlworker
id4prestosqlprestosqlworker
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
PrestosqlWRtUptimeUptime PrestoSQLW_进程运行时间_Uptime 进程运行时间_Uptime s host4prestosqlprestosqlworker
id4prestosqlprestosqlworker
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
PrestosqlWStartTimeStarttime PrestoSQLW_进程启动时间_StartTime 进程启动时间_StartTime s host4prestosqlprestosqlworker
id4prestosqlprestosqlworker
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
PrestosqlWThreadCountDaemonthreadcount PrestoSQLW_线程数量_DaemonThreadCount 线程数量_DaemonThreadCount Count host4prestosqlprestosqlworker
id4prestosqlprestosqlworker
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
PrestosqlWThreadCountPeakthreadcount PrestoSQLW_线程数量_PeakThreadCount 线程数量_PeakThreadCount Count host4prestosqlprestosqlworker
id4prestosqlprestosqlworker
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
PrestosqlWThreadCountThreadcount PrestoSQLW_线程数量_ThreadCount 线程数量_ThreadCount Count host4prestosqlprestosqlworker
id4prestosqlprestosqlworker
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]

三、各维度对应参数总览

参数名称 维度名称 维度解释 格式
Instances.N.Dimensions.0.Name id4prestosqloverview EMR 实例 ID 的维度名称 输入 String 类型维度名称:id4prestosqloverview
Instances.N.Dimensions.0.Value id4prestosqloverview EMR 实例具体 ID 输入 EMR 具体实例 ID,例如:emr-mm8bs222
Instances.N.Dimensions.0.Name host4prestosqlprestosqlcoordinator EMR 实例中节点 IP 的维度名称 输入 String 类型维度名称:host4prestosqlprestosqlcoordinator
Instances.N.Dimensions.0.Value host4prestosqlprestosqlcoordinator EMR 实例中具体节点 IP 输入 EMR 实例中具体节点 IP,可从控制台获取,登录 腾讯云 MapReduce 控制台,单击实例 > 集群资源 > 资源管理 > 节点内网 IP。也可通过 查询节点信息 API 获取。
Instances.N.Dimensions.0.Name id4prestosqlprestosqlcoordinator EMR 实例 ID 的维度名称 输入 String 类型维度名称:id4prestosqlprestosqlcoordinator
Instances.N.Dimensions.0.Value id4prestosqlprestosqlcoordinator EMR 实例具体 ID 输入 EMR 具体实例 ID,例如:emr-mm8bs222
Instances.N.Dimensions.0.Name host4prestosqlprestosqlworker EMR 实例中节点 IP 的维度名称 输入 String 类型维度名称:host4prestosqlprestosqlworker
Instances.N.Dimensions.0.Value host4prestosqlprestosqlworker EMR 实例中具体节点 IP 输入 EMR 实例中具体节点 IP,可从控制台获取,登录 腾讯云 MapReduce 控制台,单击实例 > 集群资源 > 资源管理 > 节点内网 IP。也可通过 查询节点信息 API 获取。
Instances.N.Dimensions.0.Name id4prestosqlprestosqlworker EMR 实例 ID 的维度名称 输入 String 类型维度名称:id4prestosqlprestosqlworker
Instances.N.Dimensions.0.Value id4prestosqlprestosqlworker EMR 实例具体 ID 输入 EMR 具体实例 ID,例如:emr-mm8bs222

四、入参说明

查询弹性 MapReduce(PrestoSQL-概览)监控数据,入参取值如下:
Namespace=QCE/TXMR_PRESTOSQL
&Instances.N.Dimensions.0.Name=id4prestosqloverview
&Instances.N.Dimensions.0.Value=EMR 实例具体 ID

查询弹性 MapReduce(PrestoSQL-Worker)监控数据,入参取值如下:

Namespace=QCE/TXMR_PRESTOSQL
&Instances.N.Dimensions.0.Name=host4prestosqlprestosqlcoordinator
&Instances.N.Dimensions.0.Value=EMR 实例中具体节点 IP
&Instances.N.Dimensions.1.Name=id4prestosqlprestosqlcoordinator
&Instances.N.Dimensions.1.Value=EMR 实例具体 ID

查询弹性 MapReduce(PRESTOSQL-Coordinator)监控数据,入参取值如下:

Namespace=QCE/TXMR_PRESTOSQL
&Instances.N.Dimensions.0.Name=host4prestosqlprestosqlworker
&Instances.N.Dimensions.0.Value=EMR 实例中具体节点 IP
&Instances.N.Dimensions.1.Name=id4prestosqlprestosqlworker
&Instances.N.Dimensions.1.Value=EMR 实例具体 ID

赞 (0)
上一篇 5天前
下一篇 5天前