Dedicated Database Cluster (DDC)
Last Updated：2025-11-14
Dedicated Cluster (DDC) only includes one type of monitor object: instance monitor (Instance). The list of monitoring metrics for instance monitor is as follows:
Instance Monitor (instance)
| Metric name (English) | Metric name (Chinese) | Unit | Dimension | Remarks |
|---|---|---|---|---|
| BinlogCacheUsePerSecond | Binary logged transactions count | Time/second | InstanceId,InstanceType | |
| BytesReceivedPerSecond | mysql bytes received | kb/second | InstanceId,InstanceType | |
| BytesSentPerSecond | mysql bytes sent | Time/second | InstanceId,InstanceType | |
| ComAlterTablePerSecond | Table operation count | Time/second | InstanceId,InstanceType | |
| ConnectionUsagePercent | Connection utilization | % | InstanceId,InstanceType | |
| CPUUsagePercent | CPU occupation ratio | % | InstanceId,InstanceType | |
| CPUUsagePercentReal | Actual CPU utilization | % | InstanceId,InstanceType | |
| CreatedTmpDiskTablesPerSecond | Temporary tables on disk | Item/second | InstanceId,InstanceType | |
| CreatedTmpFilesCountPerSecond | Temporary files | Item | InstanceId,InstanceType | |
| CreatedTmpTablesPerSecond | Temporary tables | Item/second | InstanceId,InstanceType | |
| Data3DiskIops | Disk 3 read/write times | Time | InstanceId,InstanceType | |
| Data3DiskRead | Disk 3 read bandwidth | KB/s | InstanceId,InstanceType | |
| Data3DiskWrite | Disk 3 write bandwidth | KB/s | InstanceId,InstanceType | |
| DataDiskIOPS | Disk read/write times | Time | InstanceId,InstanceType | |
| DeleteCountPerSecond | Deletions per second | Time/second | InstanceId,InstanceType | |
| Disk3MaxIoUtil | Maximum IO utilization of Disk 3 | % | InstanceId,InstanceType | |
| DiskUsagePercent | Disk utilization | % | InstanceId,InstanceType | |
| HandlerCommitPerSecond | Internal commits | Time/second | InstanceId,InstanceType | |
| HandlerReadRndNextPerSecond | Read next row requests | Time/second | InstanceId,InstanceType | |
| HandlerRollbackPerSecond | Internal rollbacks | Time/second | InstanceId,InstanceType | |
| InnodbBufferPoolPagesFree | InnoDB empty pages | Item | InstanceId,InstanceType | |
| InnodbBufferPoolPagesRequestsPerSecond | InnoDB logical read | Time/second | InstanceId,InstanceType | |
| InnodbBufferPoolPagesTotal | InnoDB total pages | Item | InstanceId,InstanceType | |
| InnodbBufferPoolReadsPerSecond | InnoDB physical read | Time/second | InstanceId,InstanceType | |
| InnodbCacheHitPercent | Innodb cache hit rate | % | InstanceId,InstanceType | |
| InnodbCacheHitPercentPerSecond | InnoDBbuff hit rate | %/second | InstanceId,InstanceType | |
| InnodbCacheUsePercent | Innodb cache utilization | % | InstanceId,InstanceType | |
| InnodbDataFsyncsPerSecond | Innodb fsync calls per second | Time/second | InstanceId,InstanceType | |
| InnodbDataReadPerSecond | InnoDB read throughput | Byte/second | InstanceId,InstanceType | |
| InnodbDataReadsPerSecond | InnoDB total read throughput | Time/second | InstanceId,InstanceType | |
| InnodbDataWritesPerSecond | InnoDB total write throughput | Time/second | InstanceId,InstanceType | |
| InnodbDataWrittenPerSecond | InnoDB write throughput | Byte/second | InstanceId,InstanceType | |
| InnodbLogWaits | InnoDB log buffer fresh waits | Time | InstanceId,InstanceType | |
| InnodbLogWaitsPercent | InnoDB flush wait ratio | % | InstanceId,InstanceType | |
| InnodbLogWriteRequestsPerSecond | InnoDBredolog write requests | Time/second | InstanceId,InstanceType | |
| InnodbLogWritesPerSecond | InnoDBredolog writes | Time/second | InstanceId,InstanceType | |
| InnodbNumOpenFiles | Number of tables currently opened by InnoDB | Item | InstanceId,InstanceType | |
| InnodbRowLockTimeAvg | InnoDB average row lock acquisition time | Millisecond | InstanceId,InstanceType | |
| InnodbRowLockWaitsPerSecond | InnoDB row lock waits | Time/second | InstanceId,InstanceType | |
| InnodbRowsDeletedPerSecond | InnoDB rows deleted | Time/second | InstanceId,InstanceType | |
| InnodbRowsInsertedPerSecond | InnoDB rows inserted | Time/second | InstanceId,InstanceType | |
| InnodbRowsReadPerSecond | InnoDB rows read | Time/second | InstanceId,InstanceType | |
| InnodbRowsUpdatedPerSecond | InnoDB rows updated | Time/second | InstanceId,InstanceType | |
| InsertCountPerSecond | Insertions per second | Time/second | InstanceId,InstanceType | |
| KeyBlocksUnused | Unused cache pages | Item | InstanceId,InstanceType | |
| KeyBlocksUsed | Cache usage | Item | InstanceId,InstanceType | |
| KeyCacheBlockCount | Cache blocks | Item | InstanceId,InstanceType | |
| KeyCacheBlockUsed | Used cache blocks | Item | InstanceId,InstanceType | |
| KeyCacheHitPercent | Cache hit rate | % | InstanceId,InstanceType | |
| KeyCacheUsePercent | Cache utilization | % | InstanceId,InstanceType | |
| KeyReadRequestsPerSecond | Cache read requests | Item/second | InstanceId,InstanceType | |
| KeyReadsPerSecond | Disks read | Item/second | InstanceId,InstanceType | |
| KeyWriteRequestsPerSecond | Cache writing requests | Item/second | InstanceId,InstanceType | |
| KeyWritesPerSecond | Disks written | Item/second | InstanceId,InstanceType | |
| LogCapacity | Log storage usage | MB | InstanceId,InstanceType | |
| MasterSlaveSyncDistance | Primary-backup delay distance | MB | InstanceId,InstanceType | |
| MaxConnectionsCount | Maximum connections | Item | InstanceId,InstanceType | |
| MemUsagePercent | Memory usage | % | InstanceId,InstanceType | |
| MemUsedSize | Memory used space | MB | InstanceId,InstanceType | |
| MysqlDataSize | Disk used space | MB | InstanceId,InstanceType | |
| MysqlDiskUsedSize | Disk storage usage | MB | InstanceId,InstanceType | |
| MysqlSlowQueriesPt | Slow queries | Time/second | InstanceId,InstanceType | |
| OpenedTablesCount | Opened tables | Item | InstanceId,InstanceType | |
| OpenFilesPerSecond | Open files | Time/second | InstanceId,InstanceType | |
| Position | Co-located primary instances | Status value (1-standby pool, 0-host pool) | InstanceId,InstanceType | |
| QcacheFreeBlocks | qcache not used | Item | InstanceId,InstanceType | |
| QcacheFreeMemory | qcache available memory | MB | InstanceId,InstanceType | |
| QcacheHitPercent | Query cache hit rate | % | InstanceId,InstanceType | |
| QcacheHitsPerSecond | qcache hits | Item/second | InstanceId,InstanceType | |
| QcacheInsertsPerSecond | qchche inserts | Item/second | InstanceId,InstanceType | |
| QcacheLowmemPrunesPerSecond | qcache deletions | Item/second | InstanceId,InstanceType | |
| QcacheNotCached | qchche not cached | Ten thousand | InstanceId,InstanceType | |
| QcacheQueriesInCachePerSecond | qcache registrations | Item/second | InstanceId,InstanceType | |
| QcacheTotalBlocks | qchche total blocks | Item | InstanceId,InstanceType | |
| QcacheUsePercent | Query cache utilization | % | InstanceId,InstanceType | |
| QueriesPerSecond | Service execution count -queries | Time/second | InstanceId,InstanceType | |
| QueryCountPerSecond | Operations per second | Time/second | InstanceId,InstanceType | |
| QuestionsPerSecond | Service execution count -questions | Time/second | InstanceId,InstanceType | |
| ReadOpCountPerSecond | Query requests | Time/second | InstanceId,InstanceType | |
| ReplaceCountPerSecond | Overwrites per second | Time/second | InstanceId,InstanceType | |
| SelectCountPerSecond | Queries per second | Time/second | InstanceId,InstanceType | |
| SelectScanCount | Full table scan count | Time | InstanceId,InstanceType | |
| SlaveBehindMaster | Primary-backup delay time | Second | InstanceId,InstanceType | |
| SlaveIORunning | IO thread status | Status value (1-Yes, 0-No) | InstanceId,InstanceType | |
| SlaveSQLRunning | SQL thread status | Status value (1-Yes, 0-No) | InstanceId,InstanceType | |
| TableLocksImmediatePerSecond | Immediate table locks | Item/second | InstanceId,InstanceType | |
| TableLocksWaitedPerSecond | Table lock waits | Time/second | InstanceId,InstanceType | |
| ThreadConnectedCount | Current open connections | Item | InstanceId,InstanceType | |
| ThreadRunningCount | Running threads | Item | InstanceId,InstanceType | |
| ThreadsCacheHitsPercent | Thread cache hit rate | % | InstanceId,InstanceType | |
| ThreadsCacheHitsPercentPerSecond | Thread cache hit rate per second | %/second | InstanceId,InstanceType | |
| ThreadsCreatedCount | Created threads | Item | InstanceId,InstanceType | |
| TPS | Transactions per second | kb/second | InstanceId,InstanceType | |
| TransactionCountPerSecond | Commits per second | Time/second | InstanceId,InstanceType | |
| TransactionMaxActiveSeconds | Maximum transaction duration | Second | InstanceId,InstanceType | |
| TransactionRollbackCountPerSecond | Rollbacks per second | Time/second | InstanceId,InstanceType | |
| UpdateCountPerSecond | Updates per second | Time/second | InstanceId,InstanceType | |
| WriteOpCountPerSecond | Update requests | Time/second | InstanceId,InstanceType |