tencent cloud

Feedback

Instance

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

    Namespace

    Namespace=QCE/MARIADB

    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 the thread pools of the primary and replica nodes
    Threads
    InstanceId
    60s, 300s, 3600s, 86400s
    BinlogDiskAvailable
    Available binlog disk space
    Instance-level metric, whose value is the smallest available binlog disk space in the instance's primary and replica nodes
    GB
    InstanceId
    60s, 300s, 3600s, 86400s
    BinlogUsedDisk
    Used binlog disk space
    Instance-level metric, whose value is the binlog disk space used in the instance's primary node
    GB
    InstanceId
    60s, 300s, 3600s, 86400s
    ConnUsageRate
    Connection usage
    Instance-level metric, whose value is the highest connection usage among the instance's primary and replica nodes
    %
    InstanceId
    60s, 300s, 3600s, 86400s
    CpuUsageRate
    CPU usage
    Instance-level metric, whose value is the CPU usage of the instance's primary node
    %
    InstanceId
    60s, 300s, 3600s, 86400s
    DataDiskAvailable
    Available data disk space
    Instance-level metric, whose value is the available data disk space in the instance's primary node
    GB
    InstanceId
    60s, 300s, 3600s, 86400s
    DataDiskUsedRate
    Data disk usage
    Instance-level metric, whose value is that of the `DataDiskUsedRateNode` metric of the instance's primary node
    %
    InstanceId
    60s, 300s, 3600s, 86400s
    DeleteTotal
    Number of DELETE queries
    Instance-level metric, whose value is the number of DELETE queries executed in the instance's primary node
    Queries/sec
    InstanceId
    60s, 300s, 3600s, 86400s
    IOUsageRate
    IO usage
    Instance-level metric, whose value is the IO usage of the instance's primary node
    %
    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 the instance's primary and replica nodes
    Times
    InstanceId
    60s, 300s, 3600s, 86400s
    InnodbBufferPoolReadAhead
    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 the instance's primary and replica nodes
    Times
    InstanceId
    60s, 300s, 3600s, 86400s
    InnodbBufferPoolReadRequests
    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, whose value is the number of rows deleted by InnoDB in the instance's primary node
    Row
    InstanceId
    60s, 300s, 3600s, 86400s
    InnodbRowsInserted
    Number of rows inserted by InnoDB
    Instance-level metric, whose value is the number of rows inserted by InnoDB in the instance's primary node
    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 the instance's primary and replica nodes
    Rows
    InstanceId
    60s, 300s, 3600s, 86400s
    InnodbRowsUpdated
    Number of rows updated by InnoDB
    Instance-level metric, whose value is the number of rows updated by InnoDB in the instance's primary node
    Rows
    InstanceId
    60s, 300s, 3600s, 86400s
    InsertTotal
    Number of INSERT queries
    Instance-level metric, whose value is the number of INSERT queries executed in the instance's primary node
    Queries/sec
    InstanceId
    60s, 300s, 3600s, 86400s
    LongQueryCount
    Number of slow queries
    Instance-level metric, whose value is the number of slow queries executed in the instance's primary node
    Queries
    InstanceId
    60s, 300s, 3600s, 86400s
    MemAvailable
    Available memory
    Instance-level metric, whose value is the available memory in the instance's primary node
    GB
    InstanceId
    60s, 300s, 3600s, 86400s
    MemHitRate
    Cache hit ratio
    Instance-level metric, whose value is the cache hit ratio in the instance's primary node
    %
    InstanceId
    60s, 300s, 3600s, 86400s
    ReplaceSelectTotal
    Number of REPLACE_SELECT queries
    Instance-level metric, whose value is the number of REPLACE-SELECT queries executed in the instance's primary node
    Queries/sec
    InstanceId
    60s, 300s, 3600s, 86400s
    ReplaceTotal
    Number of REPLACE queries
    Instance-level metric, whose value is the number of REPLACE queries executed in the instance's primary node
    Queries/sec
    InstanceId
    60s, 300s, 3600s, 86400s
    RequestTotal
    Total queries
    Instance-level metric, whose value 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 the instance's primary and replica nodes
    Queries/sec
    InstanceId
    60s, 300s, 3600s, 86400s
    SlaveDelay
    Primary-replica synchronization delay
    Instance-level metric, whose value is the shortest primary-replica synchronization delay among all the instance’s replica nodes
    Sec
    InstanceId
    60s, 300s, 3600s, 86400s
    UpdateTotal
    Number of UPDATE queries
    Instance-level metric, whose value is the number of UPDATE queries executed in the instance's primary node
    Queries/sec
    InstanceId
    60s, 300s, 3600s, 86400s
    ThreadsConnected
    Number of threads currently connected
    Instance-level metric, whose value is the sum of threads currently connected in the instance’s primary and replica nodes
    Threads
    InstanceId
    60s, 300s, 3600s, 86400s
    ConnMax
    Maximum number of connections
    Instance-level metric, whose value is the sum of the maximum number of connections of the instance’s 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
    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. tdsql-9kjauqq1

    Input Parameters

    To query the instance-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=ID of the instance
    Contact Us

    Contact our sales team or business advisors to help your business.

    Technical Support

    Open a ticket if you're looking for further assistance. Our Ticket is 7x24 avaliable.

    7x24 Phone Support