一、命名空间
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