International
中国站
Console
PrevNext
search by keyword

Recent Pages

Documentation
Basic Cloud Monitor
    Documentation
    Download PDF

    TencentDB for MySQL

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

      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

      tencent
      Copyright © 2013-2021 Tencent Cloud. All Rights Reserved.
      Privacy PolicyTerms of ServiceCookie Policy