tencent cloud

PrevNext

Feedback

search by keyword

Recent Pages

Documentation
Tencent Cloud Observability Platform
    Documentation

    Instance

    Last updated: 2021-11-08 16:29:32

      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
      InnodbBufferPool
      ReadAhead      		 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
      InnodbBufferPool
      ReadRequests      		 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-2023 Tencent Cloud. All Rights Reserved.
      Privacy PolicyLegalCookie Policy