Namespace=QCE/TDMYSQL
Metric | Meaning | Description | Unit | Dimension | Statistical Periods |
---|---|---|---|---|---|
ActiveThread CountNode |
Number of active threads | Number of active threads in the thread pool of the node | Threads | InstanceId, NodeId |
60s, 300s, 3600s, 86400s |
BinlogDisk AvailableNode |
Available binlog disk space | Available binlog disk space in the node |
GB | InstanceId, NodeId |
60s, 300s, 3600s, 86400s |
BinlogUsedDiskNode | Used binlog disk space | Used binlog disk space in the node |
GB | InstanceId, NodeId |
60s, 300s, 3600s, 86400s |
ConnUsageRateNode | Connection usage | Connection usage in the node, whose value is ThreadsConnected/ConnMax. | % | InstanceId, NodeId |
60s, 300s, 3600s, 86400s |
CpuUsageRateNode | CPU usage | CPU usage of the node | % | InstanceId, NodeId |
60s, 300s, 3600s, 86400s |
DataDisk AvailableNode |
Available data disk space | Available data disk space in the node | GB | InstanceId, NodeId |
60s, 300s, 3600s, 86400s |
DataDisk UsedRateNode |
Data disk usage | Data disk usage in the node | % | InstanceId, NodeId |
60s, 300s, 3600s, 86400s |
DeleteTotalNode | Number of DELETE queries | Number of DELETE queries executed in the node | Queries/sec | InstanceId, NodeId |
60s, 300s, 3600s, 86400s |
IOUsageRateNode | IO usage | IO usage of the node | % | InstanceId, NodeId |
60s, 300s, 3600s, 86400s |
InnodbBuffer PoolReadsNode |
Number of InnoDB disk page reads | Number of InnoDB disk page reads in the node |
Times | InstanceId, NodeId |
60s, 300s, 3600s, 86400s |
InnodbBufferPool ReadAheadNode |
Page read-ahead count of the InnoDB buffer pool | Number of read-aheads in the InnoDB buffer pool of the node | Times | InstanceId, NodeId |
60s, 300s, 3600s, 86400s |
InnodbBufferPool ReadRequestsNode |
Page read count of the InnoDB buffer pool | Number of page reads in the InnoDB buffer pool of the node |
Times | InstanceId, NodeId |
60s, 300s, 3600s, 86400s |
InnodbRows DeletedNode |
Number of rows deleted by InnoDB | Number of rows deleted by InnoDB in the node |
Rows | InstanceId, NodeId |
60s, 300s, 3600s, 86400s |
InnodbRows InsertedNode |
Number of rows inserted by InnoDB | Number of rows inserted by InnoDB in the node | Rows | InstanceId, NodeId |
60s, 300s, 3600s, 86400s |
InnodbRowsReadNode | Number of rows read by InnoDB | Number of rows read by InnoDB in the node |
Rows | InstanceId, NodeId |
60s, 300s, 3600s, 86400s |
InnodbRows UpdatedNode |
Number of rows updated by InnoDB | Number of rows updated by InnoDB in the node |
Rows | InstanceId, NodeId |
60s, 300s, 3600s, 86400s |
InsertTotalNode | Number of INSERT queries | Number of INSERT queries executed in the node | Queries/sec | InstanceId, NodeId |
60s, 300s, 3600s, 86400s |
LongQueryCountNode | Slow queries | Number of slow queries in the node | Queries | InstanceId, NodeId |
60s, 300s, 3600s, 86400s |
MemAvailableNode | Available memory | Available memory in the node | GB | InstanceId, NodeId |
60s, 300s, 3600s, 86400s |
MemHitRateNode | Cache hit ratio | Cache hit ratio in the node | % | InstanceId, NodeId |
60s, 300s, 3600s, 86400s |
ReplaceSelect TotalNode |
Number of REPLACE_SELECT queries | Number of REPLACE_SELECT queries executed in the node | Queries/sec | InstanceId, NodeId |
60s, 300s, 3600s, 86400s |
ReplaceTotalNode | Number of REPLACE queries | Number of REPLACE queries executed in the node | Queries/sec | InstanceId, NodeId |
60s, 300s, 3600s, 86400s |
RequestTotalNode | Total number of requests | Total number of requests executed in the node | Queries/sec | InstanceId, NodeId |
60s, 300s, 3600s, 86400s |
SelectTotalNode | Number of SELECT queries | Number of SELECT queries executed in the node | Queries/sec | InstanceId, NodeId |
60s, 300s, 3600s, 86400s |
SlaveDelayNode | Primary-replica synchronization delay | Primary-replica synchronization delay of the node | Sec | InstanceId, NodeId |
60s, 300s, 3600s, 86400s |
UpdateTotalNode | Number of UPDATE queries | Number of UPDATE queries executed in the node | Queries/sec | InstanceId, NodeId |
60s, 300s, 3600s, 86400s |
Threads ConnectedNode |
Number of threads currently connected | Number of threads currently connected, which is the number of sessions obtained using the SHOW PROCESSLIST statement | Threads | InstanceId, NodeId |
60s, 300s, 3600s, 86400s |
ConnMaxNode | Maximum number of connections | Maximum number of connections allowed by the node | Connections | InstanceId, NodeId |
60s, 300s, 3600s, 86400s |
IsMaster | Whether the node is a primary database | Whether the node is a primary database | - | InstanceId, NodeId |
60s |
Note:Statistical periods (Period) may vary from metric to metric. You can get the periods different metrics support by calling the
DescribeBaseMetrics
API.
Parameter | Dimension Name | Dimension Description | Format |
---|---|---|---|
Instances.N.Dimensions.0.Name | InstanceId | Dimension name of the instance | Enter a string-type dimension name: InstanceId |
Instances.N.Dimensions.0.Value | InstanceId | Instance ID | Enter an instance ID, e.g. tdsqlshard-9kjauqq1 |
Instances.N.Dimensions.1.Name | NodeId | Dimension name of the node | Enter a string-type dimension name, e.g., NodeId . |
Instances.N.Dimensions.1.Value | NodeId | Node ID | Enter a node ID, e.g., 877adc0ada3e . |
To query the node-level monitoring metrics of TDSQL for MySQL, use the following input parameters:
&Namespace=QCE/TDMYSQL
&Instances.N.Dimensions.0.Name=InstanceId
&Instances.N.Dimensions.0.Value=Instance ID
&Instances.N.Dimensions.1.Name=NodeId
&Instances.N.Dimensions.1.Value=Node ID
Was this page helpful?