tencent cloud

PrevNext

Feedback

search by keyword

Recent Pages

Documentation
Tencent Cloud Observability Platform
    Documentation
    Download PDF

    Shard

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

      Namespace

      Namespace=QCE/TDMYSQL

      Monitoring Metrics

      Metric
      Meaning
      Description
      Unit
      Dimension
      Statistical Periods
      CpuUsageRateShard
      CPU usage
      Shard-level metric, whose value is the CPU usage of the shard’s primary node
      %
      InstanceId,ShardId
      60s, 300s, 3600s, 86400s
      DataDiskAvailableShard
      Available data disk space
      Shard-level metric, whose value is the available data disk space in the shard’s primary node
      GB
      InstanceId,ShardId
      60s, 300s, 3600s, 86400s
      DataDiskUsedRateShard
      Data disk usage
      Shard-level metric, whose value is the data disk space usage in the shard’s primary node
      %
      InstanceId,ShardId
      60s, 300s, 3600s, 86400s
      DeleteTotalShard
      Number of DELETE queries
      Shard-level metric, whose value is the number of DELETE queries in the shard’s primary node
      Queries/sec
      InstanceId,ShardId
      60s, 300s, 3600s, 86400s
      IOUsageRateShard
      IO usage
      Shard-level metric, whose value is the IO usage of the shard’s primary node
      %
      InstanceId,ShardId
      60s, 300s, 3600s, 86400s
      InnodbBufferPoolReadsShard
      Number of InnoDB disk page reads
      Shard-level metric, which is the sum of InnoDB disk page reads in the shard’s primary and replica nodes
      Times
      InstanceId,ShardId
      60s, 300s, 3600s, 86400s
      InnodbBufferPoolReadAheadShard
      Page read-ahead count of the InnoDB buffer pool
      Shard-level metric, which is the sum of page read-aheads in the InnoDB buffer pool in the shard’s primary and replica nodes
      Times
      InstanceId,ShardId
      60s, 300s, 3600s, 86400s
      InnodbBufferPoolReadRequestsShard
      Page read count of the InnoDB buffer pool
      Shard-level metric, which is the sum of page reads in the InnoDB buffer pool in the shard’s primary and replica nodes
      Times
      InstanceId,ShardId
      60s, 300s, 3600s, 86400s
      InnodbRowsDeletedShard
      Number of rows deleted by InnoDB
      Shard-level metric, whose value is the number of rows deleted by InnoDB in the shard’s primary node
      Rows
      InstanceId,ShardId
      60s, 300s, 3600s, 86400s
      InnodbRowsInsertedShard
      Number of rows inserted by InnoDB
      Shard-level metric, whose value is the number of rows inserted by InnoDB in the shard’s primary node
      Rows
      InstanceId,ShardId
      60s, 300s, 3600s, 86400s
      InnodbRowsReadShard
      Number of rows read by InnoDB
      Shard-level metric, which is the sum of rows read by InnoDB in the shard’s primary and replica nodes
      Rows
      InstanceId,ShardId
      60s, 300s, 3600s, 86400s
      InnodbRowsUpdatedShard
      Number of rows updated by InnoDB
      Shard-level metric, whose value is the number of rows updated by InnoDB in the shard’s primary node
      Rows
      InstanceId,ShardId
      60s, 300s, 3600s, 86400s
      InsertTotalShard
      Number of INSERT queries
      Shard-level metric, whose value is the number of INSERT queries executed in the shard’s primary node
      Queries/sec
      InstanceId,ShardId
      60s, 300s, 3600s, 86400s
      LongQueryCountShard
      Slow queries
      Shard-level metric, whose value is the number of slow queries in the shard’s primary node
      Queries
      InstanceId,ShardId
      60s, 300s, 3600s, 86400s
      MasterSwitchedTotalShard
      Number of primary node switchovers
      Shard-level metric, which represents the number of times the primary node is switched in the shard
      Times
      InstanceId,ShardId
      60s, 300s, 3600s, 86400s
      MemAvailableShard
      Available memory
      Shard-level metric, whose value is the available memory in the shard’s primary node
      GB
      InstanceId,ShardId
      60s, 300s, 3600s, 86400s
      MemHitRateShard
      Cache hit ratio
      Shard-level metric, whose value is the cache hit ratio of the shard’s primary node
      %
      InstanceId,ShardId
      60s, 300s, 3600s, 86400s
      ReplaceSelectTotalShard
      Number of REPLACE_SELECT queries
      Shard-level metric, whose value is the number of REPLACE_SELECT queries executed in the shard’s primary node
      Queries/sec
      InstanceId,ShardId
      60s, 300s, 3600s, 86400s
      ReplaceTotalShard
      Number of REPLACE queries
      Shard-level metric, whose value is the number of REPLACE queries executed in the shard’s primary node
      Queries/sec
      InstanceId,ShardId
      60s, 300s, 3600s, 86400s
      RequestTotalShard
      Total number of queries
      Shard-level metric, which is the total number of queries executed in the shard’s primary node plus the number of SELECT queries executed in the replica nodes
      Queries/sec
      InstanceId,ShardId
      60s, 300s, 3600s, 86400s
      SelectTotalShard
      Number of SELECT queries
      Shard-level metric, which is the sum of SELECT queries executed in the shard’s primary and replica nodes
      Queries/sec
      InstanceId,ShardId
      60s, 300s, 3600s, 86400s
      SlaveDelayShard
      Primary-replica synchronization delay
      Shard-level metric, whose value is the shortest primary-replica synchronization delay among the shard’s replica nodes
      Sec
      InstanceId,ShardId
      60s, 300s, 3600s, 86400s
      ThreadsConnectedShard
      Number of threads currently connected
      Shard-level metric, which is the sum of threads connected in the shard’s primary and replica nodes
      Threads
      InstanceId,ShardId
      60s, 300s, 3600s, 86400s
      UpdateTotalShard
      Number of UPDATE queries
      Shard-level metric, whose value is the number of UPDATE queries executed in the shard’s primary node
      Queries/sec
      InstanceId,ShardId
      60s, 300s, 3600s, 86400s
      ActiveThreadCountShard
      Number of active threads
      Shard-level metric, which is the sum of active threads in the shard’s primary and replica nodes
      Threads
      InstanceId,ShardId
      60s, 300s, 3600s, 86400s
      BinlogDiskAvailableShard
      Available binlog disk space
      Shard-level metric, whose value is the smallest available binlog disk space among the shard’s primary and replica nodes
      GB
      InstanceId,ShardId
      60s, 300s, 3600s, 86400s
      BinlogUsedDiskShard
      Used binlog disk space
      Shard-level metric, whose value is the binlog disk space used in the shard’s primary node
      GB
      InstanceId,ShardId
      60s, 300s, 3600s, 86400s
      ConnMaxShard
      Maximum number of connections
      Shard-level metric, whose value is the sum of the maximum number of connections of the shard’s primary and replica nodes
      Connections
      InstanceId,ShardId
      60s, 300s, 3600s, 86400s
      ConnUsageRateShard
      Connection usage
      Shard-level metric, whose value is the highest connection usage among the shard’s primary and replica nodes
      %
      InstanceId,ShardId
      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.

      Dimension 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
      ShardId
      Dimension name of the shard
      Enter a string-type dimension name: ShardId
      Instances.N.Dimensions.1.Value
      ShardId
      Shard ID
      Enter a shard ID, e.g., shard-i6f4sf12.

      Input Parameters

      To query the shard-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=ShardId &Instances.N.Dimensions.1.Value=Shard 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