TencentDB for MySQL

Last updated: 2021-03-12 14:31:23

    Namespace

    Namespace=QCE/CDB

    Monitored Metrics

    Resources

    Metric Description Note Unit Dimension Monitoring Periods
    BytesReceived Private network inbound traffic Number of bytes received per second B/sec InstanceId, InstanceType 5s, 60s, 300s, 3,600s, 86,400s
    BytesSent Private network outbound traffic Number of bytes sent per second B/sec InstanceId, InstanceType 5s, 60s, 300s, 3,600s, 86,400s
    Capacity Disk usage Including the space taken up by the MySQL data directory and logs (binlog, relaylog, undolog, errorlog, and slowlog) MB InstanceId, InstanceType 5s, 60s, 300s, 3,600s, 86,400s
    CPUUseRate CPU usage May be greater than 100% as you are allowed to use idle CPU resources that you have not purchased % InstanceId, InstanceType 5s, 60s, 300s, 3,600s, 86,400s
    IOPS Input/output operations per second Input and output operations (or number of reads/writes) per second Time(s)/sec InstanceId, InstanceType 5s, 60s, 300s, 3,600s, 86,400s
    MemoryUse Memory usage May be greater than the purchased memory as you are allowed to use idle memory you have not purchased MB InstanceId, InstanceType 5s, 60s, 300s, 3,600s, 86,400s
    MemoryUseRate Memory utilization May be greater than 100% as you are allowed to use idle memory you have not purchased % InstanceId, InstanceType 5s, 60s, 300s, 3,600s, 86,400s
    RealCapacity Disk usage The space taken up by the MySQL data directory, not including that by logs (binlog, relaylog, undolog, errorlog, or slowlog) MB InstanceId, InstanceType 5s, 60s, 300s, 3,600s, 86,400s
    VolumeRate Disk utilization Used disk space/purchased instance space % InstanceId, InstanceType 5s, 60s, 300s, 3,600s, 86,400s

    Engine (general) - MyISAM

    Metric Description Note Unit Dimension Monitoring Periods
    KeyCacheHitRate MyISAM cache hit rate Cache hit rate of the MyISAM engine % InstanceId, InstanceType 5s, 60s, 300s, 3,600s, 86,400s
    KeyCacheUseRate MyISAM cache utilization Cache utilization of the MyISAM engine % InstanceId, InstanceType 5s, 60s, 300s, 3,600s, 86,400s

    Engine (general) - InnoDB

    Metric Description Note Unit Dimension Monitoring Periods
    InnodbCacheHitRate InnoDB cache hit rate Cache hit ratio of the InnoDB engine % InstanceId, InstanceType 5s, 60s, 300s, 3,600s, 86,400s
    InnodbCacheUseRate InnoDB cache utilization Cache utilization of the InnoDB engine % InstanceId, InstanceType 5s, 60s, 300s, 3,600s, 86,400s
    InnodbNumOpenFiles Total number of tables currently opened in the InnoDB engine Number of tables currently opened in the InnoDB engine Table(s) InstanceId, InstanceType 5s, 60s, 300s, 3,600s
    InnodbOsFileReads Number of InnoDB disk reads Number of times disk files are read per second by the InnoDB engine Time(s)/sec InstanceId, InstanceType 5s, 60s, 300s, 3,600s, 86,400s
    InnodbOsFileWrites Number of InnoDB disk writes Number of times disk files are written per second by the InnoDB engine Time(s)/sec InstanceId, InstanceType 5s, 60s, 300s, 3,600s, 86,400s
    InnodbOsFsyncs Number of fsync calls by Innodb Number of times the fsync function is called per second by the InnoDB engine Time(s)/sec InstanceId, InstanceType 5s, 60s, 300s, 3,600s, 86,400s

    Engine (general) - connection

    Metric Description Note Unit Dimension Monitoring Periods
    ConnectionUseRate Connection utilization Number of current connections/maximum number of connections allowed % InstanceId, InstanceType 5s, 60s, 300s, 3,600s
    MaxConnections Maximum number of connections Maximum number of connections allowed Connection(s) InstanceId, InstanceType 5s, 60s, 300s, 3,600s, 86,400s
    QPS Number of queries processed per second Number of SQL queries processed (including the execution of the INSERT, SELECT, UPDATE, DELETE, and REPLACE statements) in the database per second. It is a metric of the actual processing capability of TencentDB for Redis instances. Time(s)/sec InstanceId, InstanceType 5s, 60s, 300s, 3,600s, 86,400s
    ThreadsConnected Current connections Number of current connections Connection(s) InstanceId, InstanceType 5s, 60s, 300s, 3,600s, 86,400s
    Tps Transactions per second Number of transactions performed in the database per second Transaction(s)/sec InstanceId, InstanceType 5s, 60s, 300s, 3,600s, 86,400s

    Engine (general) - access

    Metric Description Note Unit Dimension Monitoring Periods
    ComDelete Number of deletions Number of deletions per second Deletion(s)/sec InstanceId, InstanceType 5s, 60s, 300s, 3,600s, 86,400s
    ComInsert Number of insertions Number of insertions per second Insertion(s)/sec InstanceId, InstanceType 5s, 60s, 300s, 3,600s, 86,400s
    ComReplace Number of replacements Number of replacements per second Replacement(s)/sec InstanceId, InstanceType 5s, 60s, 300s, 3,600s, 86,400s
    ComUpdate Number of updates Number of updates per second Update(s)/sec InstanceId, InstanceType 5s, 60s, 300s, 3,600s, 86,400s
    Queries Total query number All SQL statements executed, including SET, SHOW, etc. Time(s)/sec InstanceId, InstanceType 5s, 60s, 300s, 3,600s, 86,400s
    QueryRate Query ratio Actual number of queries processed per second (QPS)/Recommended QPS % InstanceId, InstanceType 5s, 60s, 300s, 3,600s, 86,400s
    SelectCount Number of times the SELECT statement is executed Number of times the SELECT statement is executed per second Time(s)/sec InstanceId, InstanceType 5s, 60s, 300s, 3,600s, 86,400s
    SelectScan Number of full-table scans Number of full-table scans performed Time(s)/sec InstanceId, InstanceType 5s, 60s, 300s, 3,600s, 86,400s
    SlowQueries Number of slow queries Number of queries that take more than long_query_time seconds to execute Query(ies) InstanceId, InstanceType 5s, 60s, 300s, 3,600s, 86,400s

    Engine (general) - table

    Metric Description Note Unit Dimension Monitoring Periods
    CreatedTmpTables Number of temporary tables Number of temporary tables created Table(s)/sec InstanceId, InstanceType 5s, 60s, 300s, 3,600s, 86,400s
    TableLocksWaited Number of table lock waits Number of table locks that cannot be obtained immediately Time(s)/sec InstanceId, InstanceType 5s, 60s, 300s, 3,600s, 86,400s

    Engine (extended) - Tmp

    Metric Description Note Unit Dimension Monitoring Periods
    CreatedTmpDiskTables Number of temporary disk tables Number of temporary disk tables created per second Time(s)/sec InstanceId, InstanceType 5s, 60s, 300s, 3,600s, 86,400s
    CreatedTmpFiles Number of temporary files Number of temporary files created per second Time(s)/sec InstanceId, InstanceType 5s, 60s, 300s, 3,600s, 86,400s

    Engine (extended) - key

    Metric Description Note Unit Dimension Monitoring Periods
    KeyBlocksUnused Number of unused blocks in the key cache Number of unused blocks in the MyISAM key cache Block(s) InstanceId, InstanceType 5s, 60s, 300s, 3,600s, 86,400s
    KeyBlocksUsed Number of used blocks in the key cache Number of used blocks in the MyISAM key cache Block(s) InstanceId, InstanceType 5s, 60s, 300s, 3,600s, 86,400s
    KeyReadRequests Number of data block reads from the key cache Number of times the MyISAM engine reads data blocks from the key cache Time(s)/sec InstanceId, InstanceType 5s, 60s, 300s, 3,600s, 86,400s
    KeyReads Number of data block reads from the hard disk Number of times the MyISAM engine reads data blocks from the hard disk per second Time(s)/sec InstanceId, InstanceType 5s, 60s, 300s, 3,600s, 86,400s
    KeyWriteRequests Number of data block writes into the key cache Number of times the MyISAM engine writes data blocks into the key cache Time(s)/sec InstanceId, InstanceType 5s, 60s, 300s, 3,600s, 86,400s
    KeyWrites Number of data block writes into the hard disk Number of times the MyISAM engine writes data blocks into the hard disk per second Time(s)/sec InstanceId, InstanceType 5s, 60s, 300s, 3,600s, 86,400s

    Engine (extended) - InnoDB row

    Metric Description Note Unit Dimension Monitoring Periods
    InnodbRowLockTimeAvg Average time of locking a InnoDB row Average time the InnoDB engine spends locking a row ms InstanceId, InstanceType 5s, 60s, 300s, 3,600s, 86,400s
    InnodbRowLockWaits Number of InnoDB row lock waits Number of times the InnoDB engine waits to lock a row per second Time(s)/sec InstanceId, InstanceType 5s, 60s, 300s, 3,600s, 86,400s
    InnodbRowsDeleted Number of deleted InnoDB rows Number of rows deleted by the InnoDB engine per second Row(s)/sec InstanceId, InstanceType 5s, 60s, 300s, 3,600s, 86,400s
    InnodbRowsInserted Number of inserted InnoDB rows Number of rows inserted per second by the InnoDB engine Row(s)/sec InstanceId, InstanceType 5s, 60s, 300s, 3,600s, 86,400s
    InnodbRowsRead Number of read InnoDB rows Number of rows read per second by the InnoDB engine Row(s)/sec InstanceId, InstanceType 5s, 60s, 300s, 3,600s, 86,400s
    InnodbRowsUpdated Number of updated InnoDB rows Number of rows updated per second by the InnoDB engine Row(s)/sec InstanceId, InstanceType 5s, 60s, 300s, 3,600s, 86,400s

    Engine (extended) - InnoDB data

    Metric Description Note Unit Dimension Monitoring Periods
    InnodbDataReads Volume of InnoDB data read Number of bytes read per second by the InnoDB engine B/sec InstanceId, InstanceType 5s, 60s, 300s, 3,600s, 86,400s
    InnodbDataReads Number of InnoDB data reads Number of data reads handled by the InnoDB engine Time(s)/sec InstanceId, InstanceType 5s, 60s, 300s, 3,600s, 86,400s
    InnodbDataWrites Total number of InnoDB data writes Number of data writes processed per second by the InnoDB engine Time(s)/sec InstanceId, InstanceType 5s, 60s, 300s, 3,600s, 86,400s
    InnodbDataWritten Volume of written InnoDB data Number of data bytes written per second by the InnoDB engine B/sec InstanceId, InstanceType 5s, 60s, 300s, 3,600s, 86,400s

    Engine monitoring (extended) - handler

    Metric Description Note Unit Dimension Monitoring Periods
    HandlerCommit Number of internal commits Number of transaction commits per second Time(s)/sec InstanceId, InstanceType 5s, 60s, 300s, 3,600s, 86,400s
    HandlerReadRndNext Number of read-next-row requests Number of requests to read the next row per second Time(s)/sec InstanceId, InstanceType 5s, 60s, 300s, 3,600s, 86,400s
    HandlerRollback Number of internal rollbacks Number of transaction rollbacks per second Time(s)/sec InstanceId, InstanceType 5s, 60s, 300s, 3,600s, 86,400s

    Engine (extended) - buffer

    Metric Description Note Unit Dimension Monitoring Periods
    InnodbBufferPoolPagesFree Number of InnoDB blank pages Number of blank pages in the InnoDB buffer pool Page(s) InstanceId, InstanceType 5s, 60s, 300s, 3,600s
    InnodbBufferPoolPagesTotal Total number of InnoDB pages Total number of memory pages taken up by the InnoDB engine Page(s) InstanceId, InstanceType 5s, 60s, 300s, 3,600s, 86,400s
    InnodbBufferPoolReadRequests Number of times pages are pre-fetched into the InnoDB buffer pool Number of logic read requests processed per second by the InnoDB engine Time(s)/sec InstanceId, InstanceType 5s, 60s, 300s, 3,600s, 86,400s
    InnodbBufferPoolReads Number of InnoDB physical reads Number of physical read requests processed per second by the InnoDB engine Time(s)/sec InstanceId, InstanceType 5s, 60s, 300s, 3,600s, 86,400s

    Engine (extended) - others

    Metric Description Note Unit Dimension Monitoring Periods
    LogCapacity Log usage Current log usage by the engine MB InstanceId, InstanceType 5s, 60s, 300s, 3,600s
    OpenFiles Number of opened files Number of files opened by the engine File(s)/sec InstanceId, InstanceType 5s, 60s, 300s, 3,600s, 86,400s

    Engine (extended) - connection

    Metric Description Note Unit Dimension Monitoring Periods
    ThreadsCreated Number of created threads Number of threads created to process connections Thread(s) InstanceId, InstanceType 5s, 60s, 300s, 3,600s, 86,400s
    ThreadsRunning Number of running threads Number of running (non-idle) threads InstanceId, InstanceType 5s, 60s, 300s, 3,600s, 86,400s

    Engine (extended) - access

    Metric Description Note Unit Dimension Monitoring Periods
    ComCommit Number of commits Number of commits per second Time(s)/sec InstanceId, InstanceType 5s, 60s, 300s, 3,600s, 86,400s
    ComRollback Number of rollbacks Number of rollbacks per second Time(s)/sec InstanceId, InstanceType 5s, 60s, 300s, 3,600s, 86,400s

    Engine monitoring (extended) - table

    Metric Description Note Unit Dimension Monitoring Periods
    OpenedTables Number of opened tables Number of tables opened by the engine Table(s) InstanceId, InstanceType 5s, 60s, 300s, 3,600s, 86,400s
    TableLocksImmediate Number of table locks released immediately Number of table locks released immediately by the engine Lock(s) InstanceId, InstanceType 5s, 60s, 300s, 3,600s, 86,400s

    Deployment (slave)

    Metric Description Note Unit Dimension Monitoring Periods
    MasterSlaveSyncDistance Synchronization delay in data size between the master and slave Binlog difference between the master and slave MB InstanceId, InstanceType 5s, 60s, 300s, 3,600s, 86,400s
    SecondsBehindMaster Synchronization delay in time between the master and slave Synchronization delay in time between the master and slave MB InstanceId, InstanceType 5s, 60s, 300s, 3,600s, 86,400s
    SlaveIoRunning IO thread status IO thread status Values: 0: Yes; 1: No; 2: Connecting InstanceId, InstanceType 5s, 60s, 300s, 3,600s, 86,400s
    SlaveSqlRunning SQL thread status SQL thread status Values: 0: Yes; 1: No; 2: Connecting InstanceId, InstanceTyp 5s, 60s, 300s, 3,600s, 86,400s

    Note:

    Monitoring periods (period) may vary from metric to metric. You can get the periods different metrics support by calling the DescribeBaseMetrics API.

    Dimension Parameters

    Parameter Dimension Description Format
    Instances.N.Dimensions.0.Name InstanceId Database instance name Enter a string-type dimension name, e.g. topicId
    Instances.N.Dimensions.0.Value InstanceId Database ID Enter an instance ID, e.g. topic-i4p4k0u0
    Instances.N.Dimensions.1.Name InstanceType Database instance type Enter a string-type dimension name, e.g. InstanceType
    Instances.N.Dimensions.1.Value InstanceType Database instance type. Valid values:
  • 1 (default): pulls monitored data from the instance's master node
  • 2: pulls monitored data from the instance's slave node
  • 3: pulls monitored data from the read-only instance
  • 4: pulls monitored data from the instance's second slave node (applicable only to Finance Edition instances)
  • Enter an instance type. Default value: 1

    Input Parameters

    To query the monitored data of TencentDB for MySQL, use the following input parameters:
    Namespace=QCE/CDB
    &Instances.N.Dimensions.0.Name=InstanceId
    &Instances.N.Dimensions.0.Value=
    &Instances.N.Dimensions.1.Name=InstanceType
    &Instances.N.Dimensions.1.Value=Database instance type