tencent cloud

Tencent Cloud Observability Platform

TDSQL-C for MySQL Monitoring Metrics

Download
Focus Mode
Font Size
Last updated: 2026-08-18 17:21:29
AI-Translated

Namespace

Namespace=QCE/CYNOSDB_MYSQL

Monitoring Metrics

Buffer

Metric Name
Description
Unit
Dimension
Statistical Rule
Innodbbufferpoolpagesfree
Number of InnoDB free pages
Count
InstanceId
[ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Innodbbufferpoolpagestotal
Total number of InnoDB pages
Count
InstanceId
[ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
InnodbBufferPoolReadRequests
Number of InnoDB buffer pool write requests
Count
InstanceId
[ 5s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
Innodbbufferpoolreads
InnoDB physical reads
Count
InstanceId
[ 5s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
Innodbbufferpoolwriterequest
Number of InnoDB buffer pool write requests
Count
InstanceId
[ 5s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
InnodbBufferPoolWriteRequests
Number of logical write requests completed per second by the InnoDB engine
Count
InstanceId
[ 5s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]

Handler

Metric Name
Description
Unit
Dimension
Statistical Rule
HandlerCommit
Number of internal submissions
Count
InstanceId
[ 5s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
Handlerreadrndnext
Number of requests for next row reads
Count
InstanceId
[ 5s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
HandlerRollback
Number of internal rollbacks
Count
InstanceId
[ 5s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]

InnoDB

Metric Name
Description
Unit
Dimension
Statistical Rule
Innodbbufferpoolpagesdirty
Number of InnoDB dirty pages
Count
InstanceId
[ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
InnodbCacheHitRate
InnoDB engine cache hit rate
%
InstanceId
[ 5s, min ]
[ 60s, min ]
[ 300s, min ]
[ 3600s, min ]
[ 86400s, min ]
InnodbCacheUseRate
InnoDB engine cache utilization
%
InstanceId
[ 5s, min ]
[ 60s, min ]
[ 300s, min ]
[ 3600s, min ]
[ 86400s, min ]
Innodbdatapendingreads
Number of InnoDB pending reads
Count
InstanceId
[ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Innodbdatapendingwrites
Number of InnoDB pending writes
Count
InstanceId
[ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Innodbdataread
Number of InnoDB data reads
Bytes
InstanceId
[ 5s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
Innodbdatareads
Total number of InnoDB data reads
Count
InstanceId
[ 5s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
Innodbdatawrites
Total number of InnoDB data writes
Count
InstanceId
[ 5s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
Innodbdatawritten
InnoDB data written
Bytes
InstanceId
[ 5s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
Innodblogwaits
Number of InnoDB log write waits
Count
InstanceId
[ 5s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
Innodblogwriterequests
Number of InnoDB log physical write requests
Count
InstanceId
[ 5s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
Innodblogwrites
Number of InnoDB log physical writes
Count
InstanceId
[ 5s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
Innodbnumopenfiles
Current number of open InnoDB tables
Count
InstanceId
[ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Innodbosfilereads
Number of disk reads
Count
InstanceId
[ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Innodbosfilewrites
Number of disk writes
Count
InstanceId
[ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Innodbosfsyncs
Number of InnoDB_fsyncs
Count
InstanceId
[ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Innodbrowlocktimeavg
Average time to acquire row locks in InnoDB
ms
InstanceId
[ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Innodbrowlockwaits
Number of InnoDB row lock waits
Count
InstanceId
[ 5s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
InnodbRowsDeleted
InnoDB rows deleted
Count
InstanceId
[ 5s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
InnodbRowsInserted
InnoDB rows inserted
Count
InstanceId
[ 5s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
InnodbRowsRead
Number of InnoDB Row Reads
Count
InstanceId
[ 5s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
InnodbRowsUpdated
InnoDB rows updated
Count
InstanceId
[ 5s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
Openfiles
Total number of open files
Count
InstanceId
[ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]

Tmp

Metric Name
Description
Unit
Dimension
Statistical Rule
Createdtmpdisktables
Number of temporary tables
Count
InstanceId
[ 5s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
Createdtmpfiles
Number of temporary files
Count
InstanceId
[ 5s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]

Parallel query

Metric Name
Description
Unit
Dimension
Statistical Rule
Txsqlparallelstmterror
Number of statements with errors in parallel queries
Count
InstanceId
[ 5s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
Txsqlparallelstmtexecuted
Number of parallel query statements executed
Count
InstanceId
[ 5s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
Txsqlparallelstmtfallback
Number of statements rolled back from parallel to serial queries
Count
InstanceId
[ 5s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
Txsqlparallelthreadscurrentlyused
Number of threads currently used by parallel queries
Count
InstanceId
[ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]

Table

Metric Name
Description
Unit
Dimension
Statistical Rule
CreatedTmpTables
Number of temporary tables
Count
InstanceId
[ 5s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
Openedtables
Number of tables opened
Count
InstanceId
[ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Tablelocksimmediate
Number of table locks released immediately
Count
InstanceId
[ 5s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
Tablelockswaited
Number of table lock waits
Count
InstanceId
[ 5s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
Tableopencachehits
Number of table open cache hits
Count
InstanceId
[ 5s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
Tableopencachemisses
Number of table open cache misses
Count
InstanceId
[ 5s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]

Access

Metric Name
Description
Unit
Dimension
Statistical Rule
Comcommit
Number of submissions
Count
InstanceId
[ 5s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
ComDelete
Number of deletions
Count
InstanceId
[ 5s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
ComInsert
Number of insertions
Count
InstanceId
[ 5s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
Comreplace
The number of Replaces
Count
InstanceId
[ 5s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
Comrollback
Number of rollbacks
Count
InstanceId
[ 5s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
CountSelect
Number of queries
Count
InstanceId
[ 5s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
ComUpdate
Number of Updates
Count
InstanceId
[ 5s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
Proxyqueries
Number of requests
Count/s
ProxyNodeId
[ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Proxyroutemaster
Number of write requests
Count/s
ProxyNodeId
[ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Proxyrouteslave
Number of read requests
Count/s
ProxyNodeId
[ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Qcachehitrate
Qcache hit rate
%
InstanceId
[ 5s, min ]
[ 60s, min ]
[ 300s, min ]
[ 3600s, min ]
[ 86400s, min ]
Qcacheuserate
Qcache utilization
%
InstanceId
[ 5s, min ]
[ 60s, min ]
[ 300s, min ]
[ 3600s, min ]
[ 86400s, min ]
Queries
Total number of requests
Count
InstanceId
[ 5s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
Selectfulljoin
Number of full-table scan composite queries
Count
InstanceId
[ 5s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
Selectfullrangejoin
Number of range scan composite queries
Count
InstanceId
[ 5s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
Selectscan
Number of full-table scans
Count
InstanceId
[ 5s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
SlowQueries
Number of slow queries
Count
InstanceId
[ 5s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
Sortmergepasses
Number of sort merge passes
Count
InstanceId
[ 5s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
Proxiesqueries
Number of requests
Count/s
OssProxyNodeName
[ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Proxiesroutemaster
Number of write requests
Count/s
OssProxyNodeName
[ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Proxiesrouteslave
Number of read requests
Count/s
OssProxyNodeName
[ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]

Resource

Metric Name
Description
Unit
Dimension
Statistical Rule
Proxycpuuserate
CPU Utilization
%
ProxyNodeId
[ 5s, max ]
[ 10s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Proxymemoryusage
Memory usage
MBytes
ProxyNodeId
[ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Proxymemoryuserate
Memory utilization
%
ProxyNodeId
[ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Proxiesbytesreceived
Client traffic received per second by the database proxy
MBytes/s
OssProxyNodeName
[ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Proxiesbytessent
Client traffic sent per second by the database proxy
MBytes/s
OssProxyNodeName
[ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Proxiescpuuserate
CPU Utilization
%
OssProxyNodeName
[ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Proxiesmemoryusage
Memory usage
MBytes
OssProxyNodeName
[ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Proxiesmemoryuserate
Memory utilization
%
OssProxyNodeName
[ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]

Resource Monitor

Metric Name
Description
Unit
Dimension
Statistical Rule
BytesReceived
Client traffic received per second
MB/s
InstanceId
[ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
BytesSent
Client traffic sent per second
MB/s
InstanceId
[ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Ccu
CCU (only for serverless)
Count
InstanceId
[ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Cpuuserate
CPU Utilization
%
InstanceId
[ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
MemoryUse
Memory usage
MB
InstanceId
[ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Memoryuserate
Memory utilization
%
InstanceId
[ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Readiops
Read IOPS
Count/s
InstanceId
[ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
StorageUsage
Storage usage
GBytes
InstanceId
[ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Storageuserate
Storage Utilization
%
InstanceId
[ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
TmpVolumeUsage
Temporary tablespace usage
GB
InstanceId
[ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
UndoVolumeUsage
Usage of the undo tablespace
GB
InstanceId
[ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Writeiops
Write IOPS
Count/s
InstanceId
[ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]

Connect

Metric Name
Description
Unit
Dimension
Statistical Rule
Connectionuserate
Connection utilization
%
InstanceId
[ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
MaxConnections
Maximum number of connections
count
InstanceId
[ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Proxycurrentconnections
Current number of connections
Count/s
ProxyNodeId
[ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Qps
Queries per second
Count/s
InstanceId
[ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Threadsconnected
Number of open connections
Count
InstanceId
[ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Threadscreated
Number of threads created
Count
InstanceId
[ 5s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
ThreadsRunning
Number of running threads
Count
InstanceId
[ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Tps
Transactions per second
Count/s
InstanceId
[ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Proxiescurrentconnections
Current number of connections
Count/s
OssProxyNodeName
[ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]

Deployment Monitor

Metric Name
Description
Unit
Dimension
Statistical Rule
Clusterslaveiorunning
IO thread status for cross-AZ deployment
None
InstanceId
[ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Clusterslavesqlrunning
SQL thread status for cross-AZ deployment
None
InstanceId
[ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Masterslavesyncdistance
Cross-AZ primary/secondary synchronization gap
MB
InstanceId
[ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Replicationdelay
Replication Delay
ms
InstanceId
[ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Replicationdelaydistance
Replication lag distance in lsn
Bytes
InstanceId
[ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Replicationstatus
Replication status
None
InstanceId
[ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Rplsemisyncmastertxcurwaittime
Transaction wait time for cross-AZ cluster acknowledgment
us
InstanceId
[ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Secondsbehindmaster
Cross-AZ latency
s
InstanceId
[ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]

Others

Metric Name
Description
Unit
Dimension
Statistical Rule
Comaltertable
Number of table modifications
Count
InstanceId
[ 5s, sum ]
[ 10s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
Comanalyze
Number of Analyze commands
Count
InstanceId
[ 5s, sum ]
[ 10s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
Comcreatetable
Number of table creations
Count
InstanceId
[ 5s, sum ]
[ 10s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
Comdropindex
Number of index deletions
Count
InstanceId
[ 5s, sum ]
[ 10s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
Comdroptable
Number of table deletions
Count
InstanceId
[ 5s, sum ]
[ 10s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
Comdropuser
Number of user deletions
Count
InstanceId
[ 5s, sum ]
[ 10s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
Comexecutesql
Cumulative execution frequency of prepared statements
Count/s
InstanceId
[ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Cominsertselect
Number of INSERT_SELECT statements
Count
InstanceId
[ 5s, max ]
[ 10s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Comoptimize
Number of Optimize commands
Count
InstanceId
[ 5s, sum ]
[ 10s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
Compreparesql
Cumulative preparation frequency of prepared statements
Count/s
InstanceId
[ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Comreplaceselect
Number of REPLACE_SELECT statements
Count
InstanceId
[ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Comtruncate
Number of table truncations
Count
InstanceId
[ 5s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
Connections
Cumulative number of connections
Count
InstanceId
[ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Ddltps
DDL throughput
Count
InstanceId
[ 5s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
DataVolumeUsage
Data tablespace usage
GB
InstanceId
[ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Innodbbufferpooldatapages
Number of InnoDB data pages
Count
InstanceId
[ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Innodbbufferpoolwaitfree
Number of InnoDB pages waiting for write
Count
InstanceId
[ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Innodbncdbreadpagenum
Number of InnoDB pages read per second
Count/s
InstanceId
[ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Innodbncdbwritepagenum
Number of InnoDB pages written per second
Count/s
InstanceId
[ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Memoryoom
OOM status
None
InstanceId
[ 5s, max ]
[ 10s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Proxydbrt
Average DB execution time
us
OssProxyNodeName
[ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Proxyinternalrt
Average internal Proxy latency
us
OssProxyNodeName
[ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Proxysqlfullrt
Average SQL end-to-end latency
us
OssProxyNodeName
[ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Questions
Number of client requests
Count
InstanceId
[ 5s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
Replicalagmaxlog
Pending replication log volume_MB
MB
InstanceId
[ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Replicalagmaxlsn
Pending replication log volume_LSN
Count
InstanceId
[ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Sortrows
Total number of sorted rows
Count
InstanceId
[ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Switchtimes
Number of HA failovers
Count
InstanceId
[ 5s, sum ]
[ 10s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
Tableopencacheoverflows
Number of table open cache overflows
Count
InstanceId
[ 5s, sum ]
[ 60s, sum ]
[ 300s, sum ]
[ 3600s, sum ]
[ 86400s, sum ]
Tmptablesrate
Temporary table utilization rate
%
InstanceId
[ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Trxrseghistorylen
Transaction history list length
Count
InstanceId
[ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Uptime
Cumulative uptime
s
InstanceId
[ 5s, max ]
[ 10s, last ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]
Memorystatcache
Memory Cache usage
MBytes
InstanceId
[ 5s, max ]
[ 60s, max ]
[ 300s, max ]
[ 3600s, max ]
[ 86400s, max ]

Overview of the Parameters in Each Dimension

Note:
The proxy view capability has been upgraded. The legacy ProxyNodeId dimension will be deprecated soon. We recommend migrating to the new OssProxyNodeName dimension for use as soon as possible.
{
"Namespace": "QCE/CYNOSDB_MYSQL",
"MetricName": "Proxiescpuuserate",
"Instances": [
{
"Dimensions": [
{
"Name": "OssProxyNodeName",
"Value": "cynosdbmysql-proxyNode-hdu***"
}
]
}
],
"Period": 300,
"StartTime": "2026-08-03 11:00:00",
"EndTime": "2026-08-06 11:00:00",
"SpecifyStatistics": 2
}
Parameter Name
Dimension Name
Dimension Description
Format
Instances.N.Dimensions.0.Name
InstanceId
Dimension name of the database instance ID
Enter a string-type dimension name, such as InstanceId
Instances.N.Dimensions.0.Value
InstanceId
A specific database instance ID
Enter a specific database instance ID, such as cynosdbmysql-ins-12ab34cd
Instances.N.Dimensions.0.Name
ProxyNodeId
Dimension name of the database proxy node ID (legacy)
Enter a string-type dimension name, such as ProxyNodeId.
Instances.N.Dimensions.1.Value
ProxyNodeId
Database proxy node ID (legacy)
Enter a string-type database proxy node name,
For example, cynosdbmysql-proxyNode-hdue****
Instances.N.Dimensions.0.Name
OssProxyNodeName
Dimension name of the database proxy node ID (new)
Enter a string-type dimension name, such as OssProxyNodeName.
Instances.N.Dimensions.1.Value
OssProxyNodeName
Database proxy node ID (new)
Enter a string-type database proxy node name,
For example, cynosdbmysql-proxyNode-hdue****

Description of Input Parameters

To query the monitoring data of the cloud database (TDSQL-C for MySQL) product, the input parameters are set as follows:
&Namespace=QCE/CYNOSDB_MYSQL
&Instances.N.Dimensions.0.Name=InstanceId
&Instances.N.Dimensions.0.Value=The ID of a specific instance in the CynosDB database
&Instances.N.Dimensions.1.Name=ProxyNodeId (This dimension will be deprecated soon. Use OssProxyNodeName instead.).
&Instances.N.Dimensions.1.Value=The name of a proxy node in the CynosDB database
&Instances.N.Dimensions.2.Name=OssProxyNodeName
&Instances.N.Dimensions.2.Value=The name of a proxy node in the CynosDB database

Important Notes

Note:
To call the metric of a read-only analytical engine, prepend "Libra" to the metric name of a regular instance. For example: the metric name for QPS is Qps, and for the read-only analytical engine, it is LibraDBQps.
When obtaining monitoring metric data for the read-only analytical engine via the API, use the following sample call. For the currently supported monitoring metrics of the read-only analytical engine, see Monitoring and Alarm.
{
"Namespace": "QCE/CYNOSDB_MYSQL",
"MetricName": "LibraDBQps",
"Instances": [
{
"Dimensions": [
{
"Name": "InstanceId",
"Value": "libradb-ins-7920****"
}
]
}
],
"Period": 300,
"StartTime": "2026-08-03 11:00:00",
"EndTime": "2026-08-06 11:00:00",
"SpecifyStatistics": 2
}

Help and Support

Was this page helpful?

Help us improve! Rate your documentation experience in 5 mins.

Feedback