tencent cloud

All product documents
Tencent Cloud Observability Platform
DocumentationTencent Cloud Observability PlatformCloud Product MonitoringTencent Cloud Service Metrics TencentDBTDSQL for MySQL Monitoring MetricsNode
Node
Download PDF
Last updated: 2024-01-27 17:44:48
Node
Last updated: 2024-01-27 17:44:48
Download PDF

Namespace

Namespace=QCE/TDMYSQL

Monitoring Metrics

Metric
Meaning
Description
Unit
Dimension
Statistical Periods
ActiveThreadCountNode
Number of active threads
Number of active threads in the thread pool of the node
Threads
InstanceId,NodeId
60s, 300s, 3600s, 86400s
BinlogDiskAvailableNode
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
DataDiskAvailableNode
Available data disk space
Available data disk space in the node
GB
InstanceId,NodeId
60s, 300s, 3600s, 86400s
DataDiskUsedRateNode
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
InnodbBufferPoolReadsNode
Number of InnoDB disk page reads
Number of InnoDB disk page reads in the node
Times
InstanceId,NodeId
60s, 300s, 3600s, 86400s
InnodbBufferPoolReadAheadNode
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
InnodbBufferPoolReadRequestsNode
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
InnodbRowsDeletedNode
Number of rows deleted by InnoDB
Number of rows deleted by InnoDB in the node
Rows
InstanceId,NodeId
60s, 300s, 3600s, 86400s
InnodbRowsInsertedNode
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
InnodbRowsUpdatedNode
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
ReplaceSelectTotalNode
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
ThreadsConnectedNode
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.

Dimensions and Parameters

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.

Input Parameters

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?
You can also Contact Sales or Submit a Ticket for help.
Yes
No

Feedback

Contact Us

Contact our sales team or business advisors to help your business.

Contact Us
Technical Support

Open a ticket if you're looking for further assistance. Our Ticket is 7x24 available.

Submit a Ticket
7x24 Phone Support
Hong Kong, China
+852 800 906 020 (Toll Free)
United States
+1 844 606 0804 (Toll Free)
United Kingdom
+44 808 196 4551 (Toll Free)
Canada
+1 888 605 7930 (Toll Free)
Australia
+61 1300 986 386 (Toll Free)
EdgeOne hotline
+852 300 80699
More local hotlines coming soon