Shard

Namespace
Namespace=QCE/TDMYSQL
Monitoring Metrics
Metric
Meaning
Description
Unit
Dimension
Statistical Periods
CpuUsageRateShard
CPU usage
Shard-level metric, whose value is the CPU usage of the shard’s primary node
%
InstanceId,ShardId
60s, 300s, 3600s, 86400s
DataDiskAvailableShard
Available data disk space
Shard-level metric, whose value is the available data disk space in the shard’s primary node
GB
InstanceId,ShardId
60s, 300s, 3600s, 86400s
DataDiskUsedRateShard
Data disk usage
Shard-level metric, whose value is the data disk space usage in the shard’s primary node
%
InstanceId,ShardId
60s, 300s, 3600s, 86400s
DeleteTotalShard
Number of DELETE queries
Shard-level metric, whose value is the number of DELETE queries in the shard’s primary node
Queries/sec
InstanceId,ShardId
60s, 300s, 3600s, 86400s
IOUsageRateShard
IO usage
Shard-level metric, whose value is the IO usage of the shard’s primary node
%
InstanceId,ShardId
60s, 300s, 3600s, 86400s
InnodbBufferPoolReadsShard
Number of InnoDB disk page reads
Shard-level metric, which is the sum of InnoDB disk page reads in the shard’s primary and replica nodes
Times
InstanceId,ShardId
60s, 300s, 3600s, 86400s
InnodbBufferPoolReadAheadShard
Page read-ahead count of the InnoDB buffer pool
Shard-level metric, which is the sum of page read-aheads in the InnoDB buffer pool in the shard’s primary and replica nodes
Times
InstanceId,ShardId
60s, 300s, 3600s, 86400s
InnodbBufferPoolReadRequestsShard
Page read count of the InnoDB buffer pool 
Shard-level metric, which is the sum of page reads in the InnoDB buffer pool in the shard’s primary and replica nodes
Times
InstanceId,ShardId
60s, 300s, 3600s, 86400s
InnodbRowsDeletedShard
Number of rows deleted by InnoDB
Shard-level metric, whose value is the number of rows deleted by InnoDB in the shard’s primary node
Rows
InstanceId,ShardId
60s, 300s, 3600s, 86400s
InnodbRowsInsertedShard
Number of rows inserted by InnoDB
Shard-level metric, whose value is the number of rows inserted by InnoDB in the shard’s primary node
Rows
InstanceId,ShardId
60s, 300s, 3600s, 86400s
InnodbRowsReadShard
Number of rows read by InnoDB
Shard-level metric, which is the sum of rows read by InnoDB in the shard’s primary and replica nodes
Rows
InstanceId,ShardId
60s, 300s, 3600s, 86400s
InnodbRowsUpdatedShard
Number of rows updated by InnoDB
Shard-level metric, whose value is the number of rows updated by InnoDB in the shard’s primary node
Rows
InstanceId,ShardId
60s, 300s, 3600s, 86400s
InsertTotalShard
Number of INSERT queries
Shard-level metric, whose value is the number of INSERT queries executed in the shard’s primary node
Queries/sec
InstanceId,ShardId
60s, 300s, 3600s, 86400s
LongQueryCountShard
Slow queries
Shard-level metric, whose value is the number of slow queries in the shard’s primary node
Queries
InstanceId,ShardId
60s, 300s, 3600s, 86400s
MasterSwitchedTotalShard
Number of primary node switchovers
Shard-level metric, which represents the number of times the primary node is switched in the shard
Times
InstanceId,ShardId
60s, 300s, 3600s, 86400s
MemAvailableShard
Available memory
Shard-level metric, whose value is the available memory in the shard’s primary node
GB
InstanceId,ShardId
60s, 300s, 3600s, 86400s
MemHitRateShard
Cache hit ratio
Shard-level metric, whose value is the cache hit ratio of the shard’s primary node
%
InstanceId,ShardId
60s, 300s, 3600s, 86400s
ReplaceSelectTotalShard
Number of REPLACE_SELECT queries
Shard-level metric, whose value is the number of REPLACE_SELECT queries executed in the shard’s primary node
Queries/sec
InstanceId,ShardId
60s, 300s, 3600s, 86400s
ReplaceTotalShard
Number of REPLACE queries
Shard-level metric, whose value is the number of REPLACE queries executed in the shard’s primary node
Queries/sec
InstanceId,ShardId
60s, 300s, 3600s, 86400s
RequestTotalShard
Total number of queries
Shard-level metric, which is the total number of queries executed in the shard’s primary node plus the number of SELECT queries executed in the replica nodes
Queries/sec
InstanceId,ShardId
60s, 300s, 3600s, 86400s
SelectTotalShard
Number of SELECT queries
Shard-level metric, which is the sum of SELECT queries executed in the shard’s primary and replica nodes
Queries/sec
InstanceId,ShardId
60s, 300s, 3600s, 86400s
SlaveDelayShard
Primary-replica synchronization delay
Shard-level metric, whose value is the shortest primary-replica synchronization delay among the shard’s replica nodes
Sec
InstanceId,ShardId
60s, 300s, 3600s, 86400s
ThreadsConnectedShard
Number of threads currently connected
Shard-level metric, which is the sum of threads connected in the shard’s primary and replica nodes
Threads
InstanceId,ShardId
60s, 300s, 3600s, 86400s
UpdateTotalShard
Number of UPDATE queries
Shard-level metric, whose value is the number of UPDATE queries executed in the shard’s primary node
Queries/sec
InstanceId,ShardId
60s, 300s, 3600s, 86400s
ActiveThreadCountShard
Number of active threads
Shard-level metric, which is the sum of active threads in the shard’s primary and replica nodes
Threads
InstanceId,ShardId
60s, 300s, 3600s, 86400s
BinlogDiskAvailableShard
Available binlog disk space
Shard-level metric, whose value is the smallest available binlog disk space among the shard’s primary and replica nodes
GB
InstanceId,ShardId
60s, 300s, 3600s, 86400s
BinlogUsedDiskShard
Used binlog disk space
Shard-level metric, whose value is the binlog disk space used in the shard’s primary node
GB
InstanceId,ShardId
60s, 300s, 3600s, 86400s
ConnMaxShard
Maximum number of connections
Shard-level metric, whose value is the sum of the maximum number of connections of the shard’s primary and replica nodes
Connections
InstanceId,ShardId
60s, 300s, 3600s, 86400s
ConnUsageRateShard
Connection usage
Shard-level metric, whose value is the highest connection usage among the shard’s primary and replica nodes
%
InstanceId,ShardId
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.
Dimension 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
ShardId
Dimension name of the shard
Enter a string-type dimension name: ShardId
Instances.N.Dimensions.1.Value
ShardId
Shard ID
Enter a shard ID, e.g., shard-i6f4sf12.
Input Parameters
To query the shard-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=ShardId
&Instances.N.Dimensions.1.Value=Shard ID

Was this page helpful?

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

Yes

Metric	Meaning	Description	Unit	Dimension	Statistical Periods
CpuUsageRateShard	CPU usage	Shard-level metric, whose value is the CPU usage of the shard’s primary node	%	InstanceId,ShardId	60s, 300s, 3600s, 86400s
DataDiskAvailableShard	Available data disk space	Shard-level metric, whose value is the available data disk space in the shard’s primary node	GB	InstanceId,ShardId	60s, 300s, 3600s, 86400s
DataDiskUsedRateShard	Data disk usage	Shard-level metric, whose value is the data disk space usage in the shard’s primary node	%	InstanceId,ShardId	60s, 300s, 3600s, 86400s
DeleteTotalShard	Number of DELETE queries	Shard-level metric, whose value is the number of DELETE queries in the shard’s primary node	Queries/sec	InstanceId,ShardId	60s, 300s, 3600s, 86400s
IOUsageRateShard	IO usage	Shard-level metric, whose value is the IO usage of the shard’s primary node	%	InstanceId,ShardId	60s, 300s, 3600s, 86400s
InnodbBufferPoolReadsShard	Number of InnoDB disk page reads	Shard-level metric, which is the sum of InnoDB disk page reads in the shard’s primary and replica nodes	Times	InstanceId,ShardId	60s, 300s, 3600s, 86400s
InnodbBufferPoolReadAheadShard	Page read-ahead count of the InnoDB buffer pool	Shard-level metric, which is the sum of page read-aheads in the InnoDB buffer pool in the shard’s primary and replica nodes	Times	InstanceId,ShardId	60s, 300s, 3600s, 86400s
InnodbBufferPoolReadRequestsShard	Page read count of the InnoDB buffer pool	Shard-level metric, which is the sum of page reads in the InnoDB buffer pool in the shard’s primary and replica nodes	Times	InstanceId,ShardId	60s, 300s, 3600s, 86400s
InnodbRowsDeletedShard	Number of rows deleted by InnoDB	Shard-level metric, whose value is the number of rows deleted by InnoDB in the shard’s primary node	Rows	InstanceId,ShardId	60s, 300s, 3600s, 86400s
InnodbRowsInsertedShard	Number of rows inserted by InnoDB	Shard-level metric, whose value is the number of rows inserted by InnoDB in the shard’s primary node	Rows	InstanceId,ShardId	60s, 300s, 3600s, 86400s
InnodbRowsReadShard	Number of rows read by InnoDB	Shard-level metric, which is the sum of rows read by InnoDB in the shard’s primary and replica nodes	Rows	InstanceId,ShardId	60s, 300s, 3600s, 86400s
InnodbRowsUpdatedShard	Number of rows updated by InnoDB	Shard-level metric, whose value is the number of rows updated by InnoDB in the shard’s primary node	Rows	InstanceId,ShardId	60s, 300s, 3600s, 86400s
InsertTotalShard	Number of INSERT queries	Shard-level metric, whose value is the number of INSERT queries executed in the shard’s primary node	Queries/sec	InstanceId,ShardId	60s, 300s, 3600s, 86400s
LongQueryCountShard	Slow queries	Shard-level metric, whose value is the number of slow queries in the shard’s primary node	Queries	InstanceId,ShardId	60s, 300s, 3600s, 86400s
MasterSwitchedTotalShard	Number of primary node switchovers	Shard-level metric, which represents the number of times the primary node is switched in the shard	Times	InstanceId,ShardId	60s, 300s, 3600s, 86400s
MemAvailableShard	Available memory	Shard-level metric, whose value is the available memory in the shard’s primary node	GB	InstanceId,ShardId	60s, 300s, 3600s, 86400s
MemHitRateShard	Cache hit ratio	Shard-level metric, whose value is the cache hit ratio of the shard’s primary node	%	InstanceId,ShardId	60s, 300s, 3600s, 86400s
ReplaceSelectTotalShard	Number of REPLACE_SELECT queries	Shard-level metric, whose value is the number of REPLACE_SELECT queries executed in the shard’s primary node	Queries/sec	InstanceId,ShardId	60s, 300s, 3600s, 86400s
ReplaceTotalShard	Number of REPLACE queries	Shard-level metric, whose value is the number of REPLACE queries executed in the shard’s primary node	Queries/sec	InstanceId,ShardId	60s, 300s, 3600s, 86400s
RequestTotalShard	Total number of queries	Shard-level metric, which is the total number of queries executed in the shard’s primary node plus the number of SELECT queries executed in the replica nodes	Queries/sec	InstanceId,ShardId	60s, 300s, 3600s, 86400s
SelectTotalShard	Number of SELECT queries	Shard-level metric, which is the sum of SELECT queries executed in the shard’s primary and replica nodes	Queries/sec	InstanceId,ShardId	60s, 300s, 3600s, 86400s
SlaveDelayShard	Primary-replica synchronization delay	Shard-level metric, whose value is the shortest primary-replica synchronization delay among the shard’s replica nodes	Sec	InstanceId,ShardId	60s, 300s, 3600s, 86400s
ThreadsConnectedShard	Number of threads currently connected	Shard-level metric, which is the sum of threads connected in the shard’s primary and replica nodes	Threads	InstanceId,ShardId	60s, 300s, 3600s, 86400s
UpdateTotalShard	Number of UPDATE queries	Shard-level metric, whose value is the number of UPDATE queries executed in the shard’s primary node	Queries/sec	InstanceId,ShardId	60s, 300s, 3600s, 86400s
ActiveThreadCountShard	Number of active threads	Shard-level metric, which is the sum of active threads in the shard’s primary and replica nodes	Threads	InstanceId,ShardId	60s, 300s, 3600s, 86400s
BinlogDiskAvailableShard	Available binlog disk space	Shard-level metric, whose value is the smallest available binlog disk space among the shard’s primary and replica nodes	GB	InstanceId,ShardId	60s, 300s, 3600s, 86400s
BinlogUsedDiskShard	Used binlog disk space	Shard-level metric, whose value is the binlog disk space used in the shard’s primary node	GB	InstanceId,ShardId	60s, 300s, 3600s, 86400s
ConnMaxShard	Maximum number of connections	Shard-level metric, whose value is the sum of the maximum number of connections of the shard’s primary and replica nodes	Connections	InstanceId,ShardId	60s, 300s, 3600s, 86400s
ConnUsageRateShard	Connection usage	Shard-level metric, whose value is the highest connection usage among the shard’s primary and replica nodes	%	InstanceId,ShardId	60s, 300s, 3600s, 86400s

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	ShardId	Dimension name of the shard	Enter a string-type dimension name: `ShardId`
Instances.N.Dimensions.1.Value	ShardId	Shard ID	Enter a shard ID, e.g., `shard-i6f4sf12`.

tencent cloud

Sign Up

Log in

Compute

Microservice

Data Migration

Database SaaS Tool

Data Security

Application Security

Big Data

Image Creation

Internet of Things

Stream Services

Cloud Real-time Rendering

Cloud Resource Management

More

Edge Computing

Serverless

Relational Database

Networking

Business Security

Domains & Websites

Face Recognition

AI Platform Service

Middleware

Media On-Demand

Game Services

Management and Audit Tools

Container

Essential Storage Service

Enterprise Distributed DBMS

CDN and Acceleration

Security Services

Enterprise Applications

Voice Technology

Natural Language Processing

Communication

Media Process Services

Education Sevices

Developer Tools

Distributed cloud

Data Process and Analysis

NoSQL Database

Network Security

Cloud Security

Office Collaboration

Tencent Big Model

Optical Character Recognition

Interactive Video Services

Media SDK

Medical Services

Monitor and Operation

Namespace

Monitoring Metrics

Dimension and Parameters

Input Parameters