弹性 MapReduce(PrestoSQL)

最近更新时间:2024-05-11 18:29:11

我的收藏

命名空间

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
host4prestosqlprestosqlcoordinator id4prestosqlprestosqlcoordinator
[ 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
%
host4prestosqlprestosqlcoordinator id4prestosqlprestosqlcoordinator
[ 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
id4prestosqlprestosqlcoordinator host4prestosqlprestosqlcoordinator
[ 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
host4prestosqlprestosqlcoordinator id4prestosqlprestosqlcoordinator
[ 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
id4prestosqlprestosqlcoordinator host4prestosqlprestosqlcoordinator
[ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ]
PrestosqlMOsFdCountOpenfiledescriptorcount
PrestoSQLM_文件描述符数_OpenFileDescriptorCount
文件描述符数_OpenFileDescriptorCount
Count
host4prestosqlprestosqlcoordinator id4prestosqlprestosqlcoordinator
[ 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
host4prestosqlprestosqlcoordinator id4prestosqlprestosqlcoordinator
[ 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
id4prestosqlprestosqlcoordinator host4prestosqlprestosqlcoordinator
[ 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
host4prestosqlprestosqlworker id4prestosqlprestosqlworker
[ 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
%
id4prestosqlprestosqlworker host4prestosqlprestosqlworker
[ 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
%
id4prestosqlprestosqlworker host4prestosqlprestosqlworker
[ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ]
PrestosqlWGcUtilMemoryS1
PrestoSQLW_内存区域占比_S1
内存区域占比_S1
%
host4prestosqlprestosqlworker id4prestosqlprestosqlworker
[ 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
host4prestosqlprestosqlworker id4prestosqlprestosqlworker
[ 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