Last updated: 2021-04-23 10:11:44

    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
    DataDisk
    AvailableShard
    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
    DataDiskUsed
    RateShard
    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
    InnodbBufferPool
    ReadsShard
    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
    InnodbBufferPool
    ReadAheadShard
    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
    InnodbBufferPool
    ReadRequestsShard
    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
    InnodbRows
    DeletedShard
    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
    InnodbRows
    InsertedShard
    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
    InnodbRows
    UpdatedShard
    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
    MasterSwitched
    TotalShard
    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
    ReplaceSelect
    TotalShard
    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
    ThreadsConnected
    Shard
    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
    ActiveThread
    CountShard
    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
    BinlogDisk
    AvailableShard
    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