tencent cloud

PrevNext

Feedback

search by keyword

Recent Pages

Documentation
Tencent Cloud Observability Platform
    Documentation
    Download PDF

    Node

    Last updated: 2024-01-27 17:44:48
    Download PDF

      Namespace

      Namespace=QCE/TDMYSQL

      Monitoring Metrics

      Metric
      Meaning
      Description
      Unit
      Dimension
      Statistical Periods
      ActiveThreadCountNode
      Number of active threads
      Number of active threads in the thread pool of the node
      Threads
      InstanceId,NodeId
      60s, 300s, 3600s, 86400s
      BinlogDiskAvailableNode
      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
      DataDiskAvailableNode
      Available data disk space
      Available data disk space in the node
      GB
      InstanceId,NodeId
      60s, 300s, 3600s, 86400s
      DataDiskUsedRateNode
      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
      InnodbBufferPoolReadsNode
      Number of InnoDB disk page reads
      Number of InnoDB disk page reads in the node
      Times
      InstanceId,NodeId
      60s, 300s, 3600s, 86400s
      InnodbBufferPoolReadAheadNode
      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
      InnodbBufferPoolReadRequestsNode
      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
      InnodbRowsDeletedNode
      Number of rows deleted by InnoDB
      Number of rows deleted by InnoDB in the node
      Rows
      InstanceId,NodeId
      60s, 300s, 3600s, 86400s
      InnodbRowsInsertedNode
      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
      InnodbRowsUpdatedNode
      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
      ReplaceSelectTotalNode
      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
      ThreadsConnectedNode
      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
      Contact Us

      Contact our sales team or business advisors to help your business.

      Contact Us
      Technical Support

      Open a ticket if you're looking for further assistance. Our Ticket is 7x24 avaliable.

      Submit a Ticket
      7x24 Phone Support
      Copyright © 2013-2024 Tencent Cloud. All Rights Reserved.
      Privacy PolicyLegalCookie Policy