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

    Namespace

    Namespace=QCE/TDMYSQL

    Monitoring Metrics

    Metric Meaning Description Unit Dimension Statistical Periods
    ActiveThread
    CountNode
    Number of active threads Number of active threads in the thread pool of the node Threads InstanceId,
    NodeId
    60s, 300s, 3600s, 86400s
    BinlogDisk
    AvailableNode
    Available binlog disk space Available binlog disk space
    in the node
    GB InstanceId,
    NodeId
    60s, 300s, 3600s, 86400s
    BinlogUsedDiskNode Used binlog disk space Used binlog disk space
    in the node
    GB InstanceId,
    NodeId
    60s, 300s, 3600s, 86400s
    ConnUsageRateNode Connection usage Connection usage in the node, whose value is ThreadsConnected/ConnMax. % InstanceId,
    NodeId
    60s, 300s, 3600s, 86400s
    CpuUsageRateNode CPU usage CPU usage of the node % InstanceId,
    NodeId
    60s, 300s, 3600s, 86400s
    DataDisk
    AvailableNode
    Available data disk space Available data disk space in the node GB InstanceId,
    NodeId
    60s, 300s, 3600s, 86400s
    DataDisk
    UsedRateNode
    Data disk usage Data disk usage in the node % InstanceId,
    NodeId
    60s, 300s, 3600s, 86400s
    DeleteTotalNode Number of DELETE queries Number of DELETE queries executed in the node Queries/sec InstanceId,
    NodeId
    60s, 300s, 3600s, 86400s
    IOUsageRateNode IO usage IO usage of the node % InstanceId,
    NodeId
    60s, 300s, 3600s, 86400s
    InnodbBuffer
    PoolReadsNode
    Number of InnoDB disk page reads Number of InnoDB disk page reads
    in the node
    Times InstanceId,
    NodeId
    60s, 300s, 3600s, 86400s
    InnodbBufferPool
    ReadAheadNode
    Page read-ahead count of the InnoDB buffer pool Number of read-aheads in the InnoDB buffer pool of the node Times InstanceId,
    NodeId
    60s, 300s, 3600s, 86400s
    InnodbBufferPool
    ReadRequestsNode
    Page read count of the InnoDB buffer pool Number of page reads
    in the InnoDB buffer pool of the node
    Times InstanceId,
    NodeId
    60s, 300s, 3600s, 86400s
    InnodbRows
    DeletedNode
    Number of rows deleted by InnoDB Number of rows deleted by InnoDB
    in the node
    Rows InstanceId,
    NodeId
    60s, 300s, 3600s, 86400s
    InnodbRows
    InsertedNode
    Number of rows inserted by InnoDB Number of rows inserted by InnoDB in the node Rows InstanceId,
    NodeId
    60s, 300s, 3600s, 86400s
    InnodbRowsReadNode Number of rows read by InnoDB Number of rows read by InnoDB
    in the node
    Rows InstanceId,
    NodeId
    60s, 300s, 3600s, 86400s
    InnodbRows
    UpdatedNode
    Number of rows updated by InnoDB Number of rows updated by InnoDB
    in the node
    Rows InstanceId,
    NodeId
    60s, 300s, 3600s, 86400s
    InsertTotalNode Number of INSERT queries Number of INSERT queries executed in the node Queries/sec InstanceId,
    NodeId
    60s, 300s, 3600s, 86400s
    LongQueryCountNode Slow queries Number of slow queries in the node Queries InstanceId,
    NodeId
    60s, 300s, 3600s, 86400s
    MemAvailableNode Available memory Available memory in the node GB InstanceId,
    NodeId
    60s, 300s, 3600s, 86400s
    MemHitRateNode Cache hit ratio Cache hit ratio in the node % InstanceId,
    NodeId
    60s, 300s, 3600s, 86400s
    ReplaceSelect
    TotalNode
    Number of REPLACE_SELECT queries Number of REPLACE_SELECT queries executed in the node Queries/sec InstanceId,
    NodeId
    60s, 300s, 3600s, 86400s
    ReplaceTotalNode Number of REPLACE queries Number of REPLACE queries executed in the node Queries/sec InstanceId,
    NodeId
    60s, 300s, 3600s, 86400s
    RequestTotalNode Total number of requests Total number of requests executed in the node Queries/sec InstanceId,
    NodeId
    60s, 300s, 3600s, 86400s
    SelectTotalNode Number of SELECT queries Number of SELECT queries executed in the node Queries/sec InstanceId,
    NodeId
    60s, 300s, 3600s, 86400s
    SlaveDelayNode Primary-replica synchronization delay Primary-replica synchronization delay of the node Sec InstanceId,
    NodeId
    60s, 300s, 3600s, 86400s
    UpdateTotalNode Number of UPDATE queries Number of UPDATE queries executed in the node Queries/sec InstanceId,
    NodeId
    60s, 300s, 3600s, 86400s
    Threads
    ConnectedNode
    Number of threads currently connected Number of threads currently connected, which is the number of sessions obtained using the SHOW PROCESSLIST statement Threads InstanceId,
    NodeId
    60s, 300s, 3600s, 86400s
    ConnMaxNode Maximum number of connections Maximum number of connections allowed by the node Connections InstanceId,
    NodeId
    60s, 300s, 3600s, 86400s
    IsMaster Whether the node is a primary database Whether the node is a primary database - InstanceId,
    NodeId
    60s

    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 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 NodeId Dimension name of the node Enter a string-type dimension name, e.g., NodeId.
    Instances.N.Dimensions.1.Value NodeId Node ID Enter a node ID, e.g., 877adc0ada3e.

    Input Parameters

    To query the node-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=NodeId
    &Instances.N.Dimensions.1.Value=Node ID