Monitoring Metrics for TDSQL for MySQL

Last Updated At: 2025-10-21 09:10:00

Cloud Monitor provides the following monitoring metrics for TDSQL for MySQL cloud database instances:

Monitoring Metrics for Nodes

Metric/Event ID Metric Name Unit Metric Description
DBNosurviveNode Number of inactive DB nodes - Number of inactive DB nodes
ProxyNosurviveNode Number of inactive proxy nodes - Number of inactive proxy nodes

Monitoring Metrics for Instances

Metric/Event ID Metric Name Unit Metric Description
ActiveThreadCount Number of active threads Count A monitoring metric for instances, calculated by summing active threads on the primary and standby nodes of all shards
BinlogMinDiskAvailable Minimum remaining Binlog disk space GB A monitoring metric for instances, calculated by summing the minimum values of the BinlogDiskAvailableShard metric across all shards
BinlogUsedDisk Binlog disk space GB A monitoring metric for instances, calculated by summing the used Binlog disk space on the primary nodes of all shards
ConnUsageRate Maximum DB connection utilization % A monitoring metric for instances, calculated as the maximum value of the DB connection utilization on the primary and standby nodes of all shards in the instance
CpuUsageRate Maximum CPU utilization % A monitoring metric for instances, calculated as the maximum value of the CPU utilization on the primary nodes of all shards in the instance
DataDiskAvailable Available data disk space GB A monitoring metric for instances, calculated by summing the available data disk space on the primary nodes of all shards
DataDiskUsedRate Maximum data disk space utilization % A monitoring metric for instances, calculated as the maximum data disk space utilization on the primary nodes of all shards in the instance
DeleteTotal Number of DELETE requests Times/second A monitoring metric for instances, calculated by summing the number of DELETE requests on the primary nodes of all shards in the instance
IOUsageRate Maximum I/O utilization % A monitoring metric for instances, calculated as the maximum I/O utilization on the primary nodes of all shards in the instance
InnodbBufferPoolReads Number of InnoDB disk page reads Times A monitoring metric for instances, calculated by summing the read page counts in the InnoDB disk on all primary and standby nodes of all shards in the instance
InnodbBufferPoolReadAhead Number of buffer pool page reads ahead in InnoDB Times A monitoring metric for instances, calculated by summing the number of page reads ahead in the InnoDB buffer pool on all primary and standby nodes of all shards in the instance
InnodbBufferPoolReadRequests Number of page reads in the InnoDB buffer pool Times A monitoring metric for instances, calculated by summing the number of page reads in the InnoDB buffer pool on all primary and standby nodes of all shards in the instance
InnodbRowsDeleted Number of deleted rows in InnoDB Rows A monitoring metric for instances, calculated by summing the number of deleted rows in InnoDB on the primary nodes of all shards in the instance
InnodbRowsInserted Number of rows inserted in InnoDB Rows A monitoring metric for instances, calculated by summing the number of inserted rows in InnoDB on the primary nodes of all shards in the instance
InnodbRowsRead Number of rows read in InnoDB Rows A monitoring metric for instances, calculated by summing the number of rows read in InnoDB on all primary and standby nodes of all shards in the instance
InnodbRowsUpdated Number of rows updated in InnoDB Rows A monitoring metric for instances, calculated by summing the number of updated rows in InnoDB on the primary nodes of all shards in the instance
InsertTotal Number of INSERT requests Times/second A monitoring metric for instances, calculated by summing the number of INSERT requests on the primary nodes of all shards in the instance
LongQueryCount Number of slow queries Times A monitoring metric for instances, calculated by summing the number of slow queries on the primary nodes of all shards in the instance
MemAvailable Available cache space GB A monitoring metric for instances, calculated by summing the available cache space on the primary nodes of all shards in the instance
MemHitRate Cache hit rate % A monitoring metric for instances, calculated as the minimum value of the cache hit rate on the primary nodes of all shards in the instance.
ReplaceSelectTotal Number of REPLACE_SELECT requests Times/second A monitoring metric for instances, calculated by summing the number of REPLACE_SELECT requests on the primary nodes of all shards in the instance.
ReplaceTotal Number of REPLACE requests Times/second A monitoring metric for instances, calculated by summing the number of REPLACE requests on the primary nodes of all shards in the instance.
RequestTotal Total number of requests Times/second A monitoring metric for instances, calculated by summing the number of requests on all primary and standby nodes in the instance.
SelectTotal Number of SELECT requests Times/second A monitoring metric for instances, calculated by summing the number of SELECT requests on all primary and standby nodes of all shards in the instance.
SlaveDelay Secondary latency Seconds A monitoring metric for instances. The standby delay of an instance is the maximum standby delay of all shards in the instance, with the standby delay of each shard calculated first. The standby delay of a shard is the minimum standby delay of all the standby nodes of the shard.
UpdateTotal Number of UPDATE requests Times/second A monitoring metric for instances, calculated by summing the number of UPDATE requests on the primary nodes of all shards in the instance.
ThreadsConnected Number of open connections Times A monitoring metric for instances, calculated by summing the number of current open connections on all primary and standby nodes of all shards in the instance.
ConnMax Maximum number of connections Count A monitoring metric for instances, calculated by summing the maximum connections on all primary and standby nodes of all shards in the instance.
ClientConnTotal Total number of client connections Count A monitoring metric for instances, calculated by summing the number of connections on all proxies in the instance. This metric accurately indicates how many of your clients are connected to the database instance.
SQLTotal Number of SQL errors Count A monitoring metric for instances, indicating the number of SQL statements sent to the database instance.
ErrorSQLTotal Total number of SQL queries Count A monitoring metric for instances, indicating the number of SQL statements executed with errors.
SuccessSQLTotal Number of successful SQL queries Count A monitoring metric for instances, indicating the number of successfully executed SQL statements.
TimeRange0 Number of requests with execution time less than 5 ms Times/second A monitoring metric for instances, indicating the number of requests with execution time less than 5ms.
TimeRange1 Number of requests with execution time between 5 ms and 20 ms Times/second A monitoring metric for instances, indicating the number of requests with execution time between 5 ms and 20 ms
TimeRange2 Number of requests with execution time between 20 ms and 30 ms Times/second A monitoring metric for instances, indicating the number of requests with execution time between 20 ms and 30 ms
TimeRange3 Number of requests with execution time more than 30 ms Times/second A monitoring metric for instances, indicating the number of requests with execution time more than 30 ms
MasterSwitchedTotal Number of primary-secondary switches Times A monitoring metric for instances, indicating the number of primary-secondary switchovers that occurred for the instance