PrevNext
search by keyword

Recent Pages

Documentation
Basic Cloud Monitor
    Documentation
    Download PDF

    Node

    Last updated: 2021-04-23 10:11:44
    Download PDF

      Namespace

      Namespace=QCE/TDMYSQL

      Monitoring Metrics

      Metric Meaning Description Unit Dimension Statistical Periods
      ActiveThread
      CountNode      		 Number of active threads Number of active threads in the thread pool of the node Threads InstanceId,
      NodeId      		 60s, 300s, 3600s, 86400s
      BinlogDisk
      AvailableNode      		 Available binlog disk space Available binlog disk space
      in the node      		 GB InstanceId,
      NodeId      		 60s, 300s, 3600s, 86400s
      BinlogUsedDiskNode Used binlog disk space Used binlog disk space
      in the node      		 GB InstanceId,
      NodeId      		 60s, 300s, 3600s, 86400s
      ConnUsageRateNode Connection usage Connection usage in the node, whose value is ThreadsConnected/ConnMax. % InstanceId,
      NodeId      		 60s, 300s, 3600s, 86400s
      CpuUsageRateNode CPU usage CPU usage of the node % InstanceId,
      NodeId      		 60s, 300s, 3600s, 86400s
      DataDisk
      AvailableNode      		 Available data disk space Available data disk space in the node GB InstanceId,
      NodeId      		 60s, 300s, 3600s, 86400s
      DataDisk
      UsedRateNode      		 Data disk usage Data disk usage in the node % InstanceId,
      NodeId      		 60s, 300s, 3600s, 86400s
      DeleteTotalNode Number of DELETE queries Number of DELETE queries executed in the node Queries/sec InstanceId,
      NodeId      		 60s, 300s, 3600s, 86400s
      IOUsageRateNode IO usage IO usage of the node % InstanceId,
      NodeId      		 60s, 300s, 3600s, 86400s
      InnodbBuffer
      PoolReadsNode      		 Number of InnoDB disk page reads Number of InnoDB disk page reads
      in the node      		 Times InstanceId,
      NodeId      		 60s, 300s, 3600s, 86400s
      InnodbBufferPool
      ReadAheadNode      		 Page read-ahead count of the InnoDB buffer pool Number of read-aheads in the InnoDB buffer pool of the node Times InstanceId,
      NodeId      		 60s, 300s, 3600s, 86400s
      InnodbBufferPool
      ReadRequestsNode      		 Page read count of the InnoDB buffer pool Number of page reads
      in the InnoDB buffer pool of the node      		 Times InstanceId,
      NodeId      		 60s, 300s, 3600s, 86400s
      InnodbRows
      DeletedNode      		 Number of rows deleted by InnoDB Number of rows deleted by InnoDB
      in the node      		 Rows InstanceId,
      NodeId      		 60s, 300s, 3600s, 86400s
      InnodbRows
      InsertedNode      		 Number of rows inserted by InnoDB Number of rows inserted by InnoDB in the node Rows InstanceId,
      NodeId      		 60s, 300s, 3600s, 86400s
      InnodbRowsReadNode Number of rows read by InnoDB Number of rows read by InnoDB
      in the node      		 Rows InstanceId,
      NodeId      		 60s, 300s, 3600s, 86400s
      InnodbRows
      UpdatedNode      		 Number of rows updated by InnoDB Number of rows updated by InnoDB
      in the node      		 Rows InstanceId,
      NodeId      		 60s, 300s, 3600s, 86400s
      InsertTotalNode Number of INSERT queries Number of INSERT queries executed in the node Queries/sec InstanceId,
      NodeId      		 60s, 300s, 3600s, 86400s
      LongQueryCountNode Slow queries Number of slow queries in the node Queries InstanceId,
      NodeId      		 60s, 300s, 3600s, 86400s
      MemAvailableNode Available memory Available memory in the node GB InstanceId,
      NodeId      		 60s, 300s, 3600s, 86400s
      MemHitRateNode Cache hit ratio Cache hit ratio in the node % InstanceId,
      NodeId      		 60s, 300s, 3600s, 86400s
      ReplaceSelect
      TotalNode      		 Number of REPLACE_SELECT queries Number of REPLACE_SELECT queries executed in the node Queries/sec InstanceId,
      NodeId      		 60s, 300s, 3600s, 86400s
      ReplaceTotalNode Number of REPLACE queries Number of REPLACE queries executed in the node Queries/sec InstanceId,
      NodeId      		 60s, 300s, 3600s, 86400s
      RequestTotalNode Total number of requests Total number of requests executed in the node Queries/sec InstanceId,
      NodeId      		 60s, 300s, 3600s, 86400s
      SelectTotalNode Number of SELECT queries Number of SELECT queries executed in the node Queries/sec InstanceId,
      NodeId      		 60s, 300s, 3600s, 86400s
      SlaveDelayNode Primary-replica synchronization delay Primary-replica synchronization delay of the node Sec InstanceId,
      NodeId      		 60s, 300s, 3600s, 86400s
      UpdateTotalNode Number of UPDATE queries Number of UPDATE queries executed in the node Queries/sec InstanceId,
      NodeId      		 60s, 300s, 3600s, 86400s
      Threads
      ConnectedNode      		 Number of threads currently connected Number of threads currently connected, which is the number of sessions obtained using the SHOW PROCESSLIST statement Threads InstanceId,
      NodeId      		 60s, 300s, 3600s, 86400s
      ConnMaxNode Maximum number of connections Maximum number of connections allowed by the node Connections InstanceId,
      NodeId      		 60s, 300s, 3600s, 86400s
      IsMaster Whether the node is a primary database Whether the node is a primary database - InstanceId,
      NodeId      		 60s

      Note：

      Statistical periods (Period) may vary from metric to metric. You can get the periods different metrics support by calling the DescribeBaseMetrics API.

      Dimensions and Parameters

      Parameter Dimension Name Dimension Description Format
      Instances.N.Dimensions.0.Name InstanceId Dimension name of the instance Enter a string-type dimension name: InstanceId
      Instances.N.Dimensions.0.Value InstanceId Instance ID Enter an instance ID, e.g. tdsqlshard-9kjauqq1
      Instances.N.Dimensions.1.Name NodeId Dimension name of the node Enter a string-type dimension name, e.g., NodeId.
      Instances.N.Dimensions.1.Value NodeId Node ID Enter a node ID, e.g., 877adc0ada3e.

      Input Parameters

      To query the node-level monitoring metrics of TDSQL for MySQL, use the following input parameters:

      &Namespace=QCE/TDMYSQL
      &Instances.N.Dimensions.0.Name=InstanceId
      &Instances.N.Dimensions.0.Value=Instance ID
      &Instances.N.Dimensions.1.Name=NodeId
      &Instances.N.Dimensions.1.Value=Node ID

      tencent
      Copyright © 2013-2021 Tencent Cloud. All Rights Reserved.
      Privacy PolicyLegalCookie Policy