Instance

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

    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