Cloud database RDS includes 4 types of monitor objects: MySQL-Master (MysqlMaster), MySQL-Read Only (MysqlReadOnly), PostgreSQL (PG), and SQL Server (SqlServer). The list of monitoring metrics for each type is as follows:
MySQL-master (MysqlMaster)
Metric name (English)
Metric name (Chinese)
Unit
Dimension
Remarks
BinlogCacheUsePerSecond
Binary logged transactions count
Time/second
InstanceId
BytesReceivedPerSecond
mysql bytes received
Byte/second
InstanceId
BytesSentPerSecond
mysql bytes sent
Byte/second
InstanceId
ComAlterTablePerSecond
Table operation count
Time/second
InstanceId
ConnectionUsagePercent
Connection utilization
%
InstanceId
CPUUsagePercent
CPU usage
%
InstanceId
CreatedTmpDiskTablesPerSecond
Temporary tables on disk
Item/second
InstanceId
CreatedTmpFilesCountPerSecond
Temporary files
Item/second
InstanceId
CreatedTmpTablesPerSecond
Temporary tables
Item/second
InstanceId
DataDiskIops
Access
Time/second
InstanceId
DataDiskRead
Disk read bandwidth
KB/s
InstanceId
DataDiskWrite
Disk write bandwidth
KB/s
InstanceId
DeleteCountPerSecond
Deletions per second
Time/second
InstanceId
DiskUsagePercent
Disk utilization
%
InstanceId
FollowerSecondsBehindLeader
Master-slave delay of hot standby group
Second
InstanceId
HandlerCommitPerSecond
Internal commits
Time/second
InstanceId
HandlerReadRndNextPerSecond
Read next row requests
Time/second
InstanceId
HandlerRollbackPerSecond
Internal rollbacks
Time/second
InstanceId
InnodbBufferPoolPagesFree
InnoDB empty pages
Item
InstanceId
InnodbBufferPoolPagesRequestsPerSecond
InnoDB logical read
Time/second
InstanceId
InnodbBufferPoolPagesTotal
InnoDB total pages
Item
InstanceId
InnodbBufferPoolReadsPerSecond
InnoDB physical read
Time/second
InstanceId
InnodbCacheHitPercent
Innodb cache hit rate
%
InstanceId
InnodbCacheHitPercentPerSecond
InnoDBbuff hit rate
%/second
InstanceId
InnodbCacheUsePercent
Innodb cache utilization
%
InstanceId
InnodbDataFsyncsPerSecond
Innodb fsync calls per second
Time/second
InstanceId
InnodbDataReadPerSecond
InnoDB read throughput
Byte/second
InstanceId
InnodbDataReadsPerSecond
InnoDB total read throughput
Time/second
InstanceId
InnodbDataWritesPerSecond
InnoDB total write throughput
Time/second
InstanceId
InnodbDataWrittenPerSecond
InnoDB write throughput
Byte/second
InstanceId
InnodbLogWaits
InnoDB log buffer fresh waits
Time
InstanceId
InnodbLogWaitsPercent
InnoDB flush wait ratio
%
InstanceId
InnodbLogWriteRequestsPerSecond
InnoDBredolog write requests
Time/second
InstanceId
InnodbLogWritesPerSecond
InnoDBredolog writes
Time/second
InstanceId
InnodbNumOpenFiles
Number of tables currently opened by InnoDB
Item
InstanceId
InnodbRowLockTimeAvg
InnoDB average row lock acquisition time
Millisecond
InstanceId
InnodbRowLockWaitsPerSecond
InnoDB row lock waits
Time/second
InstanceId
InnodbRowsDeletedPerSecond
InnoDB rows deleted
Time/second
InstanceId
InnodbRowsInsertedPerSecond
InnoDB rows inserted
Time/second
InstanceId
InnodbRowsReadPerSecond
InnoDB rows read
Time/second
InstanceId
InnodbRowsUpdatedPerSecond
InnoDB rows updated
Time/second
InstanceId
InsertCountPerSecond
Insertions per second
Time/second
InstanceId
KeyBlocksUnused
Unused cache pages
Item
InstanceId
KeyBlocksUsed
Cache usage
Item
InstanceId
KeyCacheBlockCount
Cache blocks
Item
InstanceId
KeyCacheBlockUsed
Used cache blocks
Item
InstanceId
KeyCacheHitPercent
Cache hit rate
%
InstanceId
KeyCacheUsePercent
Cache utilization
%
InstanceId
KeyReadRequestsPerSecond
Cache read requests
Item/second
InstanceId
KeyReadsPerSecond
Disks read
Item/second
InstanceId
KeyWriteRequestsPerSecond
Cache writing requests
Item/second
InstanceId
KeyWritesPerSecond
Disks written
Item/second
InstanceId
LeaderFollowerSyncStatus
Hot standby group sync status
1: Normal synchronization; 0: Synchronization interrupted
InstanceId
LogCapacity
Log storage usage
MB
InstanceId
MasterSlaveSyncDistance
Primary-backup delay distance
MB
InstanceId
MaxConnectionsCount
Maximum connections
Item
InstanceId
MemUsagePercent
Memory usage
%
InstanceId
MemUsedSize
Memory used space
MB
InstanceId
MysqlDataSize
Disk used space
MB
InstanceId
MysqlDiskUsedSize
Disk storage usage
MB
InstanceId
MysqlIops
Instance read/write times
Time/second
InstanceId
MysqlIsAlived
MySQL survival
Status value
InstanceId
MysqlSlowQueriesPt
Slow queries
Time/second
InstanceId
NetworkInBytes
Network ingress traffic
Byte/second
InstanceId
NetworkOutBytes
Network egress traffic
Byte/second
InstanceId
OpenedTablesCount
Opened tables
Item
InstanceId
OpenFilesPerSecond
Open files
Time/second
InstanceId
QcacheFreeBlocks
qcache not used
Item
InstanceId
QcacheFreeMemory
qcache available memory
KB
InstanceId
QcacheHitPercent
Query cache hit rate
%
InstanceId
QcacheHitsPerSecond
qcache hits
Item/second
InstanceId
QcacheInsertsPerSecond
qchche inserts
Item/second
InstanceId
QcacheLowmemPrunesPerSecond
qcache deletions
Item/second
InstanceId
QcacheNotCached
qchche not cached
Ten thousand
InstanceId
QcacheQueriesInCachePerSecond
qcache registrations
Item/second
InstanceId
QcacheTotalBlocks
qchche total blocks
Item
InstanceId
QcacheUsePercent
Query cache utilization
%
InstanceId
QueryCountPerSecond
Operations per second
Time/second
InstanceId
ReadOpCountPerSecond
Query requests
Time/second
InstanceId
ReplaceCountPerSecond
Overwrites per second
Time/second
InstanceId
SecondsBehindMaster
Master-slave delay
Second
InstanceId
SelectCountPerSecond
Queries per second
Time/second
InstanceId
SelectScanCount
Full table scan count
Time/second
InstanceId
SlaveIORunning
IO thread status
Status value
InstanceId
SlaveSQLRunning
SQL thread status
Status value
InstanceId
TableLocksImmediatePerSecond
Immediate table locks
Item/second
InstanceId
TableLocksWaitedPerSecond
Table lock waits
Time/second
InstanceId
ThreadConnectedCount
Current open connections
Item
InstanceId
ThreadRunningCount
Running threads
Item
InstanceId
ThreadsCacheHitsPercent
Thread cache hit rate
%
InstanceId
ThreadsCacheHitsPercentPerSecond
Thread cache hit rate per second
%/second
InstanceId
ThreadsCreatedCount
Created threads
Item
InstanceId
TPS
Transactions per second
Time/second
InstanceId
TPS_ALL
Transactions per second (including implicit commits)
Time/second
InstanceId
TransactionCountPerSecond
Commits per second
Time/second
InstanceId
TransactionMaxActiveSeconds
Maximum transaction duration
Second
InstanceId
TransactionRollbackCountPerSecond
Rollbacks per second
Time/second
InstanceId
UpdateCountPerSecond
Updates per second
Time/second
InstanceId
VMDiskUsagePercent
System disk utilization
%
InstanceId
WebInBytes
Internet ingress traffic
Byte/second
InstanceId
WebOutBytes
Internet egress traffic
Byte/second
InstanceId
WriteOpCountPerSecond
Update requests
Time/second
InstanceId
MySQL-read only (MysqlReadOnly)
Metric name (English)
Metric name (Chinese)
Unit
Dimension
Remarks
BinlogCacheUsePerSecond
Binary logged transactions count
Time/second
InstanceId
BytesReceivedPerSecond
mysql bytes received
Byte/second
InstanceId
BytesSentPerSecond
mysql bytes sent
Byte/second
InstanceId
ComAlterTablePerSecond
Table operation count
Time/second
InstanceId
ConnectionUsagePercent
Connection utilization
%
InstanceId
CPUUsagePercent
CPU usage
%
InstanceId
CreatedTmpDiskTablesPerSecond
Temporary tables on disk
Item/second
InstanceId
CreatedTmpFilesCountPerSecond
Temporary files
Item/second
InstanceId
CreatedTmpTablesPerSecond
Temporary tables
Item/second
InstanceId
DataDiskIops
Access
Time/second
InstanceId
DataDiskRead
Disk read bandwidth
KB/s
InstanceId
DataDiskWrite
Disk write bandwidth
KB/s
InstanceId
DeleteCountPerSecond
Deletions per second
Time/second
InstanceId
DiskUsagePercent
Disk utilization
%
InstanceId
FollowerSecondsBehindLeader
Master-slave delay of hot standby group
Second
InstanceId
HandlerCommitPerSecond
Internal commits
Time/second
InstanceId
HandlerReadRndNextPerSecond
Read next row requests
Time/second
InstanceId
HandlerRollbackPerSecond
Internal rollbacks
Time/second
InstanceId
InnodbBufferPoolPagesFree
InnoDB empty pages
Item
InstanceId
InnodbBufferPoolPagesRequestsPerSecond
InnoDB logical read
Time/second
InstanceId
InnodbBufferPoolPagesTotal
InnoDB total pages
Item
InstanceId
InnodbBufferPoolReadsPerSecond
InnoDB physical read
Time/second
InstanceId
InnodbCacheHitPercent
Innodb cache hit rate
%
InstanceId
InnodbCacheHitPercentPerSecond
InnoDBbuff hit rate
%/second
InstanceId
InnodbCacheUsePercent
Innodb cache utilization
%
InstanceId
InnodbDataFsyncsPerSecond
Innodb fsync calls per second
Time/second
InstanceId
InnodbDataReadPerSecond
InnoDB read throughput
Byte/second
InstanceId
InnodbDataReadsPerSecond
InnoDB total read throughput
Time/second
InstanceId
InnodbDataWritesPerSecond
InnoDB total write throughput
Time/second
InstanceId
InnodbDataWrittenPerSecond
InnoDB write throughput
Byte/second
InstanceId
InnodbLogWaits
InnoDB log buffer fresh waits
Time
InstanceId
InnodbLogWaitsPercent
InnoDB flush wait ratio
%
InstanceId
InnodbLogWriteRequestsPerSecond
InnoDBredolog write requests
Time/second
InstanceId
InnodbLogWritesPerSecond
InnoDBredolog writes
Time/second
InstanceId
InnodbNumOpenFiles
Number of tables currently opened by InnoDB
Item
InstanceId
InnodbRowLockTimeAvg
InnoDB average row lock acquisition time
Millisecond
InstanceId
InnodbRowLockWaitsPerSecond
InnoDB row lock waits
Time/second
InstanceId
InnodbRowsDeletedPerSecond
InnoDB rows deleted
Time/second
InstanceId
InnodbRowsInsertedPerSecond
InnoDB rows inserted
Time/second
InstanceId
InnodbRowsReadPerSecond
InnoDB rows read
Time/second
InstanceId
InnodbRowsUpdatedPerSecond
InnoDB rows updated
Time/second
InstanceId
InsertCountPerSecond
Insertions per second
Time/second
InstanceId
KeyBlocksUnused
Unused cache pages
Item
InstanceId
KeyBlocksUsed
Cache usage
Item
InstanceId
KeyCacheBlockCount
Cache blocks
Item
InstanceId
KeyCacheBlockUsed
Used cache blocks
Item
InstanceId
KeyCacheHitPercent
Cache hit rate
%
InstanceId
KeyCacheUsePercent
Cache utilization
%
InstanceId
KeyReadRequestsPerSecond
Cache read requests
Item/second
InstanceId
KeyReadsPerSecond
Disks read
Item/second
InstanceId
KeyWriteRequestsPerSecond
Cache writing requests
Item/second
InstanceId
KeyWritesPerSecond
Disks written
Item/second
InstanceId
LeaderFollowerSyncStatus
Hot standby group sync status
1: Normal synchronization; 0: Synchronization interrupted
InstanceId
LogCapacity
Log storage usage
MB
InstanceId
MasterSlaveSyncDistance
Primary-backup delay distance
MB
InstanceId
MaxConnectionsCount
Maximum connections
Item
InstanceId
MemUsagePercent
Memory usage
%
InstanceId
MemUsedSize
Memory used space
MB
InstanceId
MysqlDataSize
Disk used space
MB
InstanceId
MysqlDiskUsedSize
Disk storage usage
MB
InstanceId
MysqlIops
Instance read/write times
Time/second
InstanceId
MysqlIsAlived
MySQL survival
Status value
InstanceId
MysqlSlowQueriesPt
Slow queries
Time/second
InstanceId
NetworkInBytes
Network ingress traffic
Byte/second
InstanceId
NetworkOutBytes
Network egress traffic
Byte/second
InstanceId
OpenedTablesCount
Opened tables
Item
InstanceId
OpenFilesPerSecond
Open files
Time/second
InstanceId
QcacheFreeBlocks
qcache not used
Item
InstanceId
QcacheFreeMemory
qcache available memory
KB
InstanceId
QcacheHitPercent
Query cache hit rate
%
InstanceId
QcacheHitsPerSecond
qcache hits
Item/second
InstanceId
QcacheInsertsPerSecond
qchche inserts
Item/second
InstanceId
QcacheLowmemPrunesPerSecond
qcache deletions
Item/second
InstanceId
QcacheNotCached
qchche not cached
Ten thousand
InstanceId
QcacheQueriesInCachePerSecond
qcache registrations
Item/second
InstanceId
QcacheTotalBlocks
qchche total blocks
Item
InstanceId
QcacheUsePercent
Query cache utilization
%
InstanceId
QueryCountPerSecond
Operations per second
Time/second
InstanceId
ReadOpCountPerSecond
Query requests
Time/second
InstanceId
ReplaceCountPerSecond
Overwrites per second
Time/second
InstanceId
SecondsBehindMaster
Master-slave delay
Second
InstanceId
SelectCountPerSecond
Queries per second
Time/second
InstanceId
SelectScanCount
Full table scan count
Time/second
InstanceId
SlaveIORunning
IO thread status
Status value
InstanceId
SlaveSQLRunning
SQL thread status
Status value
InstanceId
TableLocksImmediatePerSecond
Immediate table locks
Item/second
InstanceId
TableLocksWaitedPerSecond
Table lock waits
Time/second
InstanceId
ThreadConnectedCount
Current open connections
Item
InstanceId
ThreadRunningCount
Running threads
Item
InstanceId
ThreadsCacheHitsPercent
Thread cache hit rate
%
InstanceId
ThreadsCacheHitsPercentPerSecond
Thread cache hit rate per second
%/second
InstanceId
ThreadsCreatedCount
Created threads
Item
InstanceId
TPS
Transactions per second
Time/second
InstanceId
TPS_ALL
Transactions per second (including implicit commits)