tencent cloud

Tencent Cloud Observability Platform

Release Notes and Announcements
Release Notes
Product Introduction
Overview
Strengths
Basic Features
Basic Concepts
Use Cases
Use Limits
Purchase Guide
Tencent Cloud Product Monitoring
Application Performance Management
Mobile App Performance Monitoring
Real User Monitoring
Cloud Automated Testing
Prometheus Monitoring
Grafana
EventBridge
PTS
Quick Start
Monitoring Overview
Instance Group
Tencent Cloud Product Monitoring
Application Performance Management
Real User Monitoring
Cloud Automated Testing
Performance Testing Service
Prometheus Getting Started
Grafana
Dashboard Creation
EventBridge
Alarm Service
Cloud Product Monitoring
Tencent Cloud Service Metrics
Operation Guide
CVM Agents
Cloud Product Monitoring Integration with Grafana
Troubleshooting
Practical Tutorial
Application Performance Management
Product Introduction
Access Guide
Operation Guide
Practical Tutorial
Parameter Information
FAQs
Mobile App Performance Monitoring
Overview
Operation Guide
Access Guide
Practical Tutorial
Tencent Cloud Real User Monitoring
Product Introduction
Operation Guide
Connection Guide
FAQs
Cloud Automated Testing
Product Introduction
Operation Guide
FAQs
Performance Testing Service
Overview
Operation Guide
Practice Tutorial
JavaScript API List
FAQs
Prometheus Monitoring
Product Introduction
Access Guide
Operation Guide
Practical Tutorial
Terraform
FAQs
Grafana
Product Introduction
Operation Guide
Guide on Grafana Common Features
FAQs
Dashboard
Overview
Operation Guide
Alarm Management
Console Operation Guide
Troubleshooting
FAQs
EventBridge
Product Introduction
Operation Guide
Practical Tutorial
FAQs
Report Management
FAQs
General
Alarm Service
Concepts
Monitoring Charts
CVM Agents
Dynamic Alarm Threshold
CM Connection to Grafana
Documentation Guide
Related Agreements
Application Performance Management Service Level Agreement
APM Privacy Policy
APM Data Processing And Security Agreement
RUM Service Level Agreement
Mobile Performance Monitoring Service Level Agreement
Cloud Automated Testing Service Level Agreement
Prometheus Service Level Agreement
TCMG Service Level Agreements
PTS Service Level Agreement
PTS Use Limits
Cloud Monitor Service Level Agreement
API Documentation
History
Introduction
API Category
Making API Requests
Monitoring Data Query APIs
Alarm APIs
Legacy Alert APIs
Notification Template APIs
TMP APIs
Grafana Service APIs
Event Center APIs
TencentCloud Managed Service for Prometheus APIs
Monitoring APIs
Data Types
Error Codes
Glossary

Instance

PDF
Mode fokus
Ukuran font
Terakhir diperbarui: 2024-01-27 17:44:47

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

Bantuan dan Dukungan

Apakah halaman ini membantu?

masukan