tencent cloud

PrevNext

Feedback

search by keyword

Recent Pages

Documentation
Tencent Cloud Observability Platform
    Documentation
    Download PDF

    Instance

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

      Namespace

      Namespace=QCE/TDMYSQL

      Monitoring Metrics

      Metric
      Meaning
      Description
      Unit
      Dimension
      Statistical Periods
      ActiveThreadCount
      Number of active threads
      Instance-level metric, which is the sum of active threads in all the shards’ primary and replica nodes
      Threads
      InstanceId
      60s, 300s, 3600s, 86400s
      BinlogDiskAvailable
      Available binlog disk space
      Instance-level metric, which is the sum of the value of `BinlogDiskAvailableShard` in all the shards
      GB
      InstanceId
      60s, 300s, 3600s, 86400s
      BinlogUsedDisk
      Used binlog disk space
      Instance-level metric, whose value is the sum of binlog disk space used in all the shards’ primary nodes
      GB
      InstanceId
      60s, 300s, 3600s, 86400s
      ConnUsageRate
      Connection usage
      Instance-level metric, whose value is the highest connection usage among all the shards’ primary and replica nodes
      %
      InstanceId
      60s, 300s, 3600s, 86400s
      CpuUsageRate
      CPU usage
      Instance-level metric, whose value is the highest CPU usage in all the shards’ primary nodes
      %
      InstanceId
      60s, 300s, 3600s, 86400s
      DataDiskAvailable
      Available data disk space
      Instance-level metric, which is the sum of the available data disk space in all the shards’ primary nodes
      GB
      InstanceId
      60s, 300s, 3600s, 86400s
      DataDiskUsedRate
      Data disk usage
      Instance-level metric, whose value is the highest data disk usage in all the shards’ primary nodes
      %
      InstanceId
      60s, 300s, 3600s, 86400s
      DeleteTotal
      Number of DELETE queries
      Instance-level metric, which is the sum of DELETE queries executed in all the shards’ primary nodes
      Queries/sec
      InstanceId
      60s, 300s, 3600s, 86400s
      InnodbBufferPoolReads
      Number of InnoDB disk page reads
      Instance-level metric, which is the sum of InnoDB disk page reads in all the shards’ primary and replica nodes
      Times
      InstanceId
      60s, 300s, 3600s, 86400s
      InnodbBufferPoolReadAhead
      Page read-ahead count of the InnoDB buffer pool
      Instance-level metric, which is the sum of page read-aheads in the InnoDB buffer pool in all the shards’ primary and replica nodes
      Times
      InstanceId
      60s, 300s, 3600s, 86400s
      InnodbBufferPoolReadRequests
      Page read count of the InnoDB buffer pool
      Instance-level metric, which is the sum of page reads in the InnoDB buffer pool in the instance's primary and replica nodes
      Times
      InstanceId
      60s, 300s, 3600s, 86400s
      InnodbRowsDeleted
      Number of rows deleted by InnoDB
      Instance-level metric, which is the sum of rows deleted by InnoDB in all the shards’ primary nodes
      Rows
      InstanceId
      60s, 300s, 3600s, 86400s
      InnodbRowsInserted
      Number of rows inserted by InnoDB
      Instance-level metric, which is the sum of rows inserted by InnoDB in all the shards’ primary nodes
      Rows
      InstanceId
      60s, 300s, 3600s, 86400s
      InnodbRowsRead
      Number of rows read by InnoDB
      Instance-level metric, which is the sum of rows read by InnoDB in all the shards’ primary and replica nodes
      Rows
      InstanceId
      60s, 300s, 3600s, 86400s
      InnodbRowsUpdated
      Number of rows updated by InnoDB
      Instance-level metric, which is the sum of rows updated by InnoDB in all the shards’ primary nodes
      Rows
      InstanceId
      60s, 300s, 3600s, 86400s
      InsertTotal
      Number of INSERT queries
      Instance-level metric, which is the sum of INSERT queries executed in all the shards’ primary nodes
      Queries/sec
      InstanceId
      60s, 300s, 3600s, 86400s
      LongQueryCount
      Slow queries
      Instance-level metric, which is the sum of slow queries executed in all the shards’ primary nodes
      Queries
      InstanceId
      60s, 300s, 3600s, 86400s
      MemAvailable
      Available memory
      Instance-level metric, which is the sum of available memory in all the shards’ primary nodes
      GB
      InstanceId
      60s, 300s, 3600s, 86400s
      MemHitRate
      Cache hit ratio
      Instance-level metric, whose value is the lowest cache hit ratio in all the shards’ primary nodes
      %
      InstanceId
      60s, 300s, 3600s, 86400s
      ReplaceSelectTotal
      Number of REPLACE_SELECT queries
      Instance-level metric, which is the sum of REPLACE-SELECT queries executed in all the shards’ primary nodes
      Queries/sec
      InstanceId
      60s, 300s, 3600s, 86400s
      ReplaceTotal
      Number of REPLACE queries
      Instance-level metric, which is the sum of REPLACE queries executed in all the shards’ primary nodes
      Queries/sec
      InstanceId
      60s, 300s, 3600s, 86400s
      RequestTotal
      Total requests
      Instance-level metric, which is the total number of queries executed in the instance's primary node plus the number of SELECT queries executed in the replica nodes
      Queries/sec
      InstanceId
      60s, 300s, 3600s, 86400s
      SelectTotal
      Number of SELECT queries
      Instance-level metric, which is the sum of SELECT queries executed in all the shards’ primary and replica nodes
      Queries/sec
      InstanceId
      60s, 300s, 3600s, 86400s
      SlaveDelay
      Primary-replica synchronization delay
      Instance-level metric. Instance-level synchronization delay is the delay of whichever shard has the longest delay, and shard-level synchronization delay is the shortest delay among the shard’s all replica nodes.
      Sec
      InstanceId
      60s, 300s, 3600s, 86400s
      UpdateTotal
      Number of UPDATE queries
      Instance-level metric, which is the sum of UPDATE queries executed in all the shards’ primary nodes
      Queries/sec
      InstanceId
      60s, 300s, 3600s, 86400s
      ThreadsConnected
      Number of threads currently connected
      Instance-level metric, which is the sum of threads currently connected in all the shards’ primary and replica nodes
      Threads
      InstanceId
      60s, 300s, 3600s, 86400s
      ConnMax
      Maximum connections
      Instance-level metric, which is the sum of the maximum number of connections of all the shards’ primary and replica nodes
      Connections
      InstanceId
      60s, 300s, 3600s, 86400s
      ClientConnTotal
      Number of client connections
      Instance-level metric, which is the sum of connections in the instance’s proxy. This metric represents the actual number of clients connected to the database instance.
      Connections
      InstanceId
      60s, 300s, 3600s, 86400s
      SQLTotal
      Total number of SQL queries
      Instance-level metric, which represents the number of SQL queries sent to the instance
      Queries
      InstanceId
      60s, 300s, 3600s, 86400s
      ErrorSQLTotal
      SQL error count
      Instance-level metric, which represents the number of queries with execution errors
      Queries
      InstanceId
      60s, 300s, 3600s, 86400s
      SuccessSQLTotal
      Number of successful SQL queries
      Instance-level metric, which represents the number of SQL queries executed successfully
      Queries
      InstanceId
      60s, 300s, 3600s, 86400s
      TimeRange0
      Number of queries that take shorter than 5 ms to execute
      Instance-level metric, which represents the number of queries that take shorter than 5 ms to execute
      Queries/sec
      InstanceId
      60s, 300s, 3600s, 86400s
      TimeRange1
      Number of queries that take 5-20 ms to execute
      Instance-level metric, which represents the number of queries that take 5-20 ms to execute
      Queries/sec
      InstanceId
      60s, 300s, 3600s, 86400s
      TimeRange2
      Number of queries that take 20-30 ms to execute
      Instance-level metric, which represents the number of queries that take 20-30 ms to execute
      Queries/sec
      InstanceId
      60s, 300s, 3600s, 86400s
      TimeRange3
      Number of queries that take longer than 30 ms to execute
      Instance-level metric, which represents the number of queries that take longer than 30 ms to execute
      Queries/sec
      InstanceId
      60s, 300s, 3600s, 86400s
      MasterSwitchedTotal
      Number of primary node switchovers
      Instance-level metric, which represents the number of times the primary node is switched
      Times
      InstanceId
      60s, 300s, 3600s, 86400s
      IOUsageRate
      IO usage
      Instance-level metric, whose value is the highest IO usage in all the shards’ primary nodes
      %
      InstanceId
      60s, 300s, 3600s, 86400s
      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 ID
      Enter a string-type dimension name: InstanceId
      Instances.N.Dimensions.0.Value
      InstanceId
      Instance ID
      Enter an instance ID, e.g. tdsqlshard-9kjauqq1

      Input Parameters

      To query the instance-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=ID of the instance
      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