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

    Namespace

    Namespace=QCE/MARIADB

    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
    BinlogDiskAvailableNode 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 utilization 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
    InnodbRows
    ReadNode
    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
    LongQuery
    CountNode
    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 Name 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., tdsql-9kjauqq1.
    Instances.N.Dimensions.0.Name NodeId Dimension name of the node Enter a string-type dimension name: NodeId.
    Instances.N.Dimensions.0.Value NodeId Node ID Enter a node ID, e.g., 877adc0ada3e.

    Input Parameters

    To query the node-level monitoring metrics of TencentDB for MariaDB, use the following input parameters:

    &Namespace=QCE/MARIADB
    &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