tencent cloud

PrevNext

Feedback

search by keyword

Recent Pages

Documentation
Tencent Cloud Observability Platform
    Documentation
    Download PDF

    TDSQL for MySQL Monitoring Metrics (Legacy)

    Last updated: 2024-01-27 17:44:48
    Download PDF
      Note:
      TCOP will soon stop supporting the old monitoring metrics for TDSQL for MySQL. Please use the new metrics.

      Namespace

      Namespace=QCE/DCDB

      Monitoring Metrics

      Parameter
      Meaning
      Unit
      Dimension
      CpuUsageRate
      CPU usage
      %
      uuid and shardId
      MemHitRate
      Cache hit ratio
      %
      uuid and shardld
      DataDiskUsedRate
      Disk space usage
      %
      uuid and shardId
      MemAvailable
      Available memory
      GB
      uuid and shardId
      DataDiskAvailable
      Available disk space
      GB
      uuid and shardId
      BinlogUsedDisk
      Used binlog disk space
      GB
      uuid and shardId
      DiskIops
      IO usage
      %
      uuid and shardId
      ConnActive
      Total connections
      Connections/sec
      uuid and shardId
      ConnRunning
      Active connections
      Connections/sec
      uuid and shardId
      TotalOrigSql
      Total SQL statement executions
      Executions/sec
      uuid and shardId
      TotalErrorSql
      Failed SQL statement executions
      Executions/sec
      uuid and shardId
      TotalSuccessSql
      Successful SQL statement executions
      Executions/sec
      uuid and shardId
      LongQuery
      Slow queries
      Queries/sec
      uuid and shardId
      TimeRange0
      Queries that take 1-5 ms to execute
      Queries/sec
      uuid and shardId
      TimeRange1
      Queries that take 5-20 ms to execute
      Queries/sec
      uuid and shardId
      TimeRange2
      Queries that take 20-30 ms to execute
      Queries/sec
      uuid and shardId
      TimeRange3
      Queries that take longer than 30 ms to execute
      Queries/sec
      uuid and shardId
      RequestTotal
      Total queries (QPS)
      Queries/sec
      uuid and shardId
      SelectTotal
      SELECT queries
      Queries/sec
      uuid and shardId
      UpdateTotal
      UPDATE queries
      Queries/sec
      uuid and shardId
      InsertTotal
      INSERT queries
      Queries/sec
      uuid and shardId
      ReplaceTotal
      REPLACE queries
      Queries/sec
      uuid and shardId
      DeleteTotal
      DELETE queries
      Queries/sec
      uuid and shardId
      MasterSwitchedTotal
      Master-slave switchovers
      Times/sec
      uuid and shardId
      SlaveDelay
      Master-slave synchronization delay
      ms
      uuid and shardId
      InnodbBufferPoolReads
      InnoDB disk reads
      Times/sec
      uuid and shardId
      InnodbBufferPoolReadRequests
      InnoDB buffer pool reads
      Times/sec
      uuid and shardId
      InnodbBufferPoolReadAhead
      InnoDB buffer pool read-aheads
      Times/sec
      uuid and shardId
      InnodbRowsDeleted
      Rows deleted by InnoDB
      Rows/sec
      uuid and shardId
      InnodbRowsInserted
      Rows inserted by InnoDB
      Rows/sec
      uuid and shardId
      InnodbRowsRead
      Rows read by InnoDB
      Rows/sec
      uuid and shardId
      InnodbRowsUpdated
      Rows updated by InnoDB
      Rows/sec
      uuid and shardId
      Note:
      The statistical period for the metrics of TDSQL for MySQL can be 60s or 300s. The exact statistical periods supported 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
      uuid
      Dimension name for the database instance
      Enter a string-type dimension name: uuid
      Instances.N.Dimensions.0.Value
      uuid
      The instance’s UUID
      Enter an instance UUID, e.g., tdsqlshard-12345678
      Instances.N.Dimensions.1.Name
      shardId
      Dimension name for an instance shard. You can pass in this parameter to query a shard’s monitoring data. If it is not passed in, all monitoring data of the instance is queried.
      Enter a string-type dimension name: shardId.
      Instances.N.Dimensions.1.Value
      shardId
      An instance shard ID
      Enter an instance shard ID, e.g., shard-0mzlzl89.

      Input Parameters

      To query the monitoring data of a TencentDB for TDSQL v3 instance, use the following input parameters: &Namespace=QCE/DCDB &Instances.N.Dimensions.0.Name=uuid &Instances.N.Dimensions.0.Value=Specific instance uuid
      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