Instance

Namespace
Namespace=QCE/TDMYSQL
Monitoring Metrics
Metric
Meaning
Description
Unit
Dimension
Statistical Periods
ActiveThreadCount
Number of active threads
Instance-level metric, which is the sum of active threads in all the shards’ primary and replica nodes
Threads
InstanceId
60s, 300s, 3600s, 86400s
BinlogDiskAvailable
Available binlog disk space
Instance-level metric, which is the sum of the value of `BinlogDiskAvailableShard` in all the shards
GB
InstanceId
60s, 300s, 3600s, 86400s
BinlogUsedDisk
Used binlog disk space
Instance-level metric, whose value is the sum of binlog disk space used in all the shards’ primary nodes
GB
InstanceId
60s, 300s, 3600s, 86400s
ConnUsageRate
Connection usage
Instance-level metric, whose value is the highest connection usage among all the shards’ primary and replica nodes
%
InstanceId
60s, 300s, 3600s, 86400s
CpuUsageRate
CPU usage
Instance-level metric, whose value is the highest CPU usage in all the shards’ primary nodes
%
InstanceId
60s, 300s, 3600s, 86400s
DataDiskAvailable
Available data disk space
Instance-level metric, which is the sum of the available data disk space in all the shards’ primary nodes
GB
InstanceId
60s, 300s, 3600s, 86400s
DataDiskUsedRate
Data disk usage
Instance-level metric, whose value is the highest data disk usage in all the shards’ primary nodes
%
InstanceId
60s, 300s, 3600s, 86400s
DeleteTotal
Number of DELETE queries
Instance-level metric, which is the sum of DELETE queries executed in all the shards’ primary nodes
Queries/sec
InstanceId
60s, 300s, 3600s, 86400s
InnodbBufferPoolReads
Number of InnoDB disk page reads
Instance-level metric, which is the sum of InnoDB disk page reads in all the shards’ primary and replica nodes
Times
InstanceId
60s, 300s, 3600s, 86400s
InnodbBufferPoolReadAhead
Page read-ahead count of the InnoDB buffer pool
Instance-level metric, which is the sum of page read-aheads in the InnoDB buffer pool in all the shards’ primary and replica nodes
Times
InstanceId
60s, 300s, 3600s, 86400s
InnodbBufferPoolReadRequests
Page read count of the InnoDB buffer pool 
Instance-level metric, which is the sum of page reads in the InnoDB buffer pool in the instance's primary and replica nodes
Times
InstanceId
60s, 300s, 3600s, 86400s
InnodbRowsDeleted
Number of rows deleted by InnoDB
Instance-level metric, which is the sum of rows deleted by InnoDB in all the shards’ primary nodes
Rows
InstanceId
60s, 300s, 3600s, 86400s
InnodbRowsInserted
Number of rows inserted by InnoDB
Instance-level metric, which is the sum of rows inserted by InnoDB in all the shards’ primary nodes
Rows
InstanceId
60s, 300s, 3600s, 86400s
InnodbRowsRead
Number of rows read by InnoDB
Instance-level metric, which is the sum of rows read by InnoDB in all the shards’ primary and replica nodes
Rows
InstanceId
60s, 300s, 3600s, 86400s
InnodbRowsUpdated
Number of rows updated by InnoDB
Instance-level metric, which is the sum of rows updated by InnoDB in all the shards’ primary nodes
Rows
InstanceId
60s, 300s, 3600s, 86400s
InsertTotal
Number of INSERT queries
Instance-level metric, which is the sum of INSERT queries executed in all the shards’ primary nodes
Queries/sec
InstanceId
60s, 300s, 3600s, 86400s
LongQueryCount
Slow queries
Instance-level metric, which is the sum of slow queries executed in all the shards’ primary nodes
Queries
InstanceId
60s, 300s, 3600s, 86400s
MemAvailable
Available memory
Instance-level metric, which is the sum of available memory in all the shards’ primary nodes
GB
InstanceId
60s, 300s, 3600s, 86400s
MemHitRate
Cache hit ratio
Instance-level metric, whose value is the lowest cache hit ratio in all the shards’ primary nodes
%
InstanceId
60s, 300s, 3600s, 86400s
ReplaceSelectTotal
Number of REPLACE_SELECT queries
Instance-level metric, which is the sum of REPLACE-SELECT queries executed in all the shards’ primary nodes
Queries/sec
InstanceId
60s, 300s, 3600s, 86400s
ReplaceTotal
Number of REPLACE queries
Instance-level metric, which is the sum of REPLACE queries executed in all the shards’ primary nodes
Queries/sec
InstanceId
60s, 300s, 3600s, 86400s
RequestTotal
Total requests
Instance-level metric, which is the total number of queries executed in the instance's primary node plus the number of SELECT queries executed in the replica nodes
Queries/sec
InstanceId
60s, 300s, 3600s, 86400s
SelectTotal
Number of SELECT queries
Instance-level metric, which is the sum of SELECT queries executed in all the shards’ primary and replica nodes
Queries/sec
InstanceId
60s, 300s, 3600s, 86400s
SlaveDelay
Primary-replica synchronization delay
Instance-level metric. Instance-level synchronization delay is the delay of whichever shard has the longest delay, and shard-level synchronization delay is the shortest delay among the shard’s all replica nodes.
Sec
InstanceId
60s, 300s, 3600s, 86400s
UpdateTotal
Number of UPDATE queries
Instance-level metric, which is the sum of UPDATE queries executed in all the shards’ primary nodes
Queries/sec
InstanceId
60s, 300s, 3600s, 86400s
ThreadsConnected
Number of threads currently connected
Instance-level metric, which is the sum of threads currently connected in all the shards’ primary and replica nodes
Threads
InstanceId
60s, 300s, 3600s, 86400s
ConnMax
Maximum connections
Instance-level metric, which is the sum of the maximum number of connections of all the shards’ primary and replica nodes
Connections
InstanceId
60s, 300s, 3600s, 86400s
ClientConnTotal
Number of client connections
Instance-level metric, which is the sum of connections in the instance’s proxy. This metric represents the actual number of clients connected to the database instance.
Connections
InstanceId
60s, 300s, 3600s, 86400s
SQLTotal
Total number of SQL queries
Instance-level metric, which represents the number of SQL queries sent to the instance
Queries
InstanceId
60s, 300s, 3600s, 86400s
ErrorSQLTotal
SQL error count
Instance-level metric, which represents the number of queries with execution errors
Queries
InstanceId
60s, 300s, 3600s, 86400s
SuccessSQLTotal
Number of successful SQL queries
Instance-level metric, which represents the number of SQL queries executed successfully
Queries
InstanceId
60s, 300s, 3600s, 86400s
TimeRange0
Number of queries that take shorter than 5 ms to execute
Instance-level metric, which represents the number of queries that take shorter than 5 ms to execute
Queries/sec
InstanceId
60s, 300s, 3600s, 86400s
TimeRange1
Number of queries that take 5-20 ms to execute
Instance-level metric, which represents the number of queries that take 5-20 ms to execute
Queries/sec
InstanceId
60s, 300s, 3600s, 86400s
TimeRange2
Number of queries that take 20-30 ms to execute
Instance-level metric, which represents the number of queries that take 20-30 ms to execute
Queries/sec
InstanceId
60s, 300s, 3600s, 86400s
TimeRange3
Number of queries that take longer than 30 ms to execute
Instance-level metric, which represents the number of queries that take longer than 30 ms to execute
Queries/sec
InstanceId
60s, 300s, 3600s, 86400s
MasterSwitchedTotal
Number of primary node switchovers
Instance-level metric, which represents the number of times the primary node is switched
Times
InstanceId
60s, 300s, 3600s, 86400s
IOUsageRate
IO usage
Instance-level metric, whose value is the highest IO usage in all the shards’ primary nodes
%
InstanceId
60s, 300s, 3600s, 86400s
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 ID
Enter a string-type dimension name: InstanceId
Instances.N.Dimensions.0.Value
InstanceId
Instance ID
Enter an instance ID, e.g. tdsqlshard-9kjauqq1
Input Parameters
To query the instance-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=ID of the instance

Was this page helpful?

You can also Contact Sales or Submit a Ticket for help.

Yes

Metric	Meaning	Description	Unit	Dimension	Statistical Periods
ActiveThreadCount	Number of active threads	Instance-level metric, which is the sum of active threads in all the shards’ primary and replica nodes	Threads	InstanceId	60s, 300s, 3600s, 86400s
BinlogDiskAvailable	Available binlog disk space	Instance-level metric, which is the sum of the value of `BinlogDiskAvailableShard` in all the shards	GB	InstanceId	60s, 300s, 3600s, 86400s
BinlogUsedDisk	Used binlog disk space	Instance-level metric, whose value is the sum of binlog disk space used in all the shards’ primary nodes	GB	InstanceId	60s, 300s, 3600s, 86400s
ConnUsageRate	Connection usage	Instance-level metric, whose value is the highest connection usage among all the shards’ primary and replica nodes	%	InstanceId	60s, 300s, 3600s, 86400s
CpuUsageRate	CPU usage	Instance-level metric, whose value is the highest CPU usage in all the shards’ primary nodes	%	InstanceId	60s, 300s, 3600s, 86400s
DataDiskAvailable	Available data disk space	Instance-level metric, which is the sum of the available data disk space in all the shards’ primary nodes	GB	InstanceId	60s, 300s, 3600s, 86400s
DataDiskUsedRate	Data disk usage	Instance-level metric, whose value is the highest data disk usage in all the shards’ primary nodes	%	InstanceId	60s, 300s, 3600s, 86400s
DeleteTotal	Number of DELETE queries	Instance-level metric, which is the sum of DELETE queries executed in all the shards’ primary nodes	Queries/sec	InstanceId	60s, 300s, 3600s, 86400s
InnodbBufferPoolReads	Number of InnoDB disk page reads	Instance-level metric, which is the sum of InnoDB disk page reads in all the shards’ primary and replica nodes	Times	InstanceId	60s, 300s, 3600s, 86400s
InnodbBufferPoolReadAhead	Page read-ahead count of the InnoDB buffer pool	Instance-level metric, which is the sum of page read-aheads in the InnoDB buffer pool in all the shards’ primary and replica nodes	Times	InstanceId	60s, 300s, 3600s, 86400s
InnodbBufferPoolReadRequests	Page read count of the InnoDB buffer pool	Instance-level metric, which is the sum of page reads in the InnoDB buffer pool in the instance's primary and replica nodes	Times	InstanceId	60s, 300s, 3600s, 86400s
InnodbRowsDeleted	Number of rows deleted by InnoDB	Instance-level metric, which is the sum of rows deleted by InnoDB in all the shards’ primary nodes	Rows	InstanceId	60s, 300s, 3600s, 86400s
InnodbRowsInserted	Number of rows inserted by InnoDB	Instance-level metric, which is the sum of rows inserted by InnoDB in all the shards’ primary nodes	Rows	InstanceId	60s, 300s, 3600s, 86400s
InnodbRowsRead	Number of rows read by InnoDB	Instance-level metric, which is the sum of rows read by InnoDB in all the shards’ primary and replica nodes	Rows	InstanceId	60s, 300s, 3600s, 86400s
InnodbRowsUpdated	Number of rows updated by InnoDB	Instance-level metric, which is the sum of rows updated by InnoDB in all the shards’ primary nodes	Rows	InstanceId	60s, 300s, 3600s, 86400s
InsertTotal	Number of INSERT queries	Instance-level metric, which is the sum of INSERT queries executed in all the shards’ primary nodes	Queries/sec	InstanceId	60s, 300s, 3600s, 86400s
LongQueryCount	Slow queries	Instance-level metric, which is the sum of slow queries executed in all the shards’ primary nodes	Queries	InstanceId	60s, 300s, 3600s, 86400s
MemAvailable	Available memory	Instance-level metric, which is the sum of available memory in all the shards’ primary nodes	GB	InstanceId	60s, 300s, 3600s, 86400s
MemHitRate	Cache hit ratio	Instance-level metric, whose value is the lowest cache hit ratio in all the shards’ primary nodes	%	InstanceId	60s, 300s, 3600s, 86400s
ReplaceSelectTotal	Number of REPLACE_SELECT queries	Instance-level metric, which is the sum of REPLACE-SELECT queries executed in all the shards’ primary nodes	Queries/sec	InstanceId	60s, 300s, 3600s, 86400s
ReplaceTotal	Number of REPLACE queries	Instance-level metric, which is the sum of REPLACE queries executed in all the shards’ primary nodes	Queries/sec	InstanceId	60s, 300s, 3600s, 86400s
RequestTotal	Total requests	Instance-level metric, which is the total number of queries executed in the instance's primary node plus the number of SELECT queries executed in the replica nodes	Queries/sec	InstanceId	60s, 300s, 3600s, 86400s
SelectTotal	Number of SELECT queries	Instance-level metric, which is the sum of SELECT queries executed in all the shards’ primary and replica nodes	Queries/sec	InstanceId	60s, 300s, 3600s, 86400s
SlaveDelay	Primary-replica synchronization delay	Instance-level metric. Instance-level synchronization delay is the delay of whichever shard has the longest delay, and shard-level synchronization delay is the shortest delay among the shard’s all replica nodes.	Sec	InstanceId	60s, 300s, 3600s, 86400s
UpdateTotal	Number of UPDATE queries	Instance-level metric, which is the sum of UPDATE queries executed in all the shards’ primary nodes	Queries/sec	InstanceId	60s, 300s, 3600s, 86400s
ThreadsConnected	Number of threads currently connected	Instance-level metric, which is the sum of threads currently connected in all the shards’ primary and replica nodes	Threads	InstanceId	60s, 300s, 3600s, 86400s
ConnMax	Maximum connections	Instance-level metric, which is the sum of the maximum number of connections of all the shards’ primary and replica nodes	Connections	InstanceId	60s, 300s, 3600s, 86400s
ClientConnTotal	Number of client connections	Instance-level metric, which is the sum of connections in the instance’s proxy. This metric represents the actual number of clients connected to the database instance.	Connections	InstanceId	60s, 300s, 3600s, 86400s
SQLTotal	Total number of SQL queries	Instance-level metric, which represents the number of SQL queries sent to the instance	Queries	InstanceId	60s, 300s, 3600s, 86400s
ErrorSQLTotal	SQL error count	Instance-level metric, which represents the number of queries with execution errors	Queries	InstanceId	60s, 300s, 3600s, 86400s
SuccessSQLTotal	Number of successful SQL queries	Instance-level metric, which represents the number of SQL queries executed successfully	Queries	InstanceId	60s, 300s, 3600s, 86400s
TimeRange0	Number of queries that take shorter than 5 ms to execute	Instance-level metric, which represents the number of queries that take shorter than 5 ms to execute	Queries/sec	InstanceId	60s, 300s, 3600s, 86400s
TimeRange1	Number of queries that take 5-20 ms to execute	Instance-level metric, which represents the number of queries that take 5-20 ms to execute	Queries/sec	InstanceId	60s, 300s, 3600s, 86400s
TimeRange2	Number of queries that take 20-30 ms to execute	Instance-level metric, which represents the number of queries that take 20-30 ms to execute	Queries/sec	InstanceId	60s, 300s, 3600s, 86400s
TimeRange3	Number of queries that take longer than 30 ms to execute	Instance-level metric, which represents the number of queries that take longer than 30 ms to execute	Queries/sec	InstanceId	60s, 300s, 3600s, 86400s
MasterSwitchedTotal	Number of primary node switchovers	Instance-level metric, which represents the number of times the primary node is switched	Times	InstanceId	60s, 300s, 3600s, 86400s
IOUsageRate	IO usage	Instance-level metric, whose value is the highest IO usage in all the shards’ primary nodes	%	InstanceId	60s, 300s, 3600s, 86400s

Parameter	Dimension Name	Dimension Description	Format
Instances.N.Dimensions.0.Name	instanceId	Dimension name of the instance ID	Enter a string-type dimension name: `InstanceId`
Instances.N.Dimensions.0.Value	InstanceId	Instance ID	Enter an instance ID, e.g. `tdsqlshard-9kjauqq1`

tencent cloud

New User Offers

Next-Generation CDN：EdgeOne

Elasticsearch Service free trial

Free Tier

Tencent Cloud Startup Program

Special Offers

Lighthouse Special Offers

Cloud Object Storage Special Offers

Featured Products

New Products

Education

Tencent Cloud Online Education Solutions

Gaming

Gaming Solution

Game Media Solutions

E-commerce

E-commerce retail solutions

Audio & Video

Audio/Video Solution

LVB Recording Solution

Interactive Classroom Solution

Interactive Live Streaming Solution

Audio Chat Social Networking Solution

Financial Services

Financial Services Solution

Compute

Cloud Virtual Machine

Auto Scaling

Batch Compute

CVM Dedicated Host

Database

TencentDB for MySQL

TencentDB for Redis®

TencentDB for CTSDB

TDSQL for MySQL

Data Transfer Service

TencentDB for MongoDB

TencentDB for PostgreSQL

TencentDB for SQL Server

Video Service

Cloud Streaming Services

Video on Demand

Media Processing Service

Cloud Application Rendering

Cloud Contact Center

Game Multimedia Engine

Chat

Real-time Communication

Tencent Effect SDK

AI and Machine Learning

Image Creation Large Model

Face Fusion

eKYC

Optical Character Recognition

Video Creation Large Model

Industry Applications

Tencent HealthCare Omics Platform

Container and Middleware

TDMQ for CKafka

Serverless Cloud Function

Tencent Kubernetes Engine

Tencent Kubernetes Engine for Serverless

Networking

Cloud Load Balancer

Virtual Private Cloud

Direct Connect

Cloud Connect Network

NAT Gateway

VPN Connection

Bandwidth Package

Anycast Internet Acceleration

Elastic Network Interface

Flow Logs

Global Application Acceleration Platform

Security

Captcha

Cloud Workload Protection Platform

Data Security Governance Center

Key Management Service