The page has been translated by Gen AI.

ServiceWatch metric

MySQL sends metrics to ServiceWatch. The metrics provided by basic monitoring are data collected at 1‑minute intervals.

Reference

For how to view metrics in ServiceWatch, refer to the ServiceWatch guide.

Basic Metrics

The following are the basic metrics for the MySQL(DBaaS) namespace.

The indicators whose names are displayed in bold below are the key indicators selected from the basic metrics provided by MySQL(DBaaS). The key metrics are used to build service dashboards that are automatically created for each service in ServiceWatch.

Each metric provides guidance in the user guide on which statistical values are meaningful when querying that metric, and among the meaningful statistics, the values displayed in bold are the primary statistics. In the service dashboard, you can view key metrics through primary statistical values.

OS Basic Metrics

Classification	Performance items	unit	Detailed description	meaningful statistics
CPU	CPU Usage	Percent	CPU usage	Total Average Maximum Minimum
Disk	Disk Usage	Percent	Disk usage	Total Average Maximum Minimum
Disk	Disk Write Bytes	Bytes/Second	Write throughput on block device (bytes/second)	Total Average Maximum Minimum
Disk	Disk Read Bytes	Bytes/Second	Read throughput from block device (bytes/second)	Total Average Maximum Minimum
Disk	Disk Write Requests	Count/Second	Number of write requests on block device (requests per second)	Total Average Maximum Minimum
Disk	Disk Read Requests	Count/Second	Number of read requests on block device (requests per second)	Total Average Maximum Minimum
Disk	Average Disk I/O Queue Size	None	Average queue length of requests issued to the block device	Total Average Maximum Minimum
Disk	Disk I/O Utilization	Percent	The proportion of time the block device actually performed I/O operations	Total Average Maximum Minimum
Memory	Memory Usage	Percent	Memory usage	Total Average Maximum Minimum
Memory	Swap Out Bytes	Bytes/Second	Amount exported from memory to swap area (bytes/second)	Total Average Maximum Minimum
Memory	Swap Used Bytes	Bytes	Size of the currently used swap space	Total Average Maximum Minimum
Memory	Swap Cached Usage	Percent	Cached swap usage rate	Total Average Maximum Minimum
Memory	Swap Total Bytes	Bytes	Total swap space size configured on the system	Total Average Maximum Minimum
Memory	Swap In Bytes	Bytes/Second	Amount read from swap area to memory (bytes per second)	Total Average Maximum Minimum
Memory	Swap Usage	Percent	Current usage ratio relative to total swap space	Total Average Maximum Minimum
Memory	Swap Cached Bytes	Bytes	Size of pages that have been restored to memory but still have a copy in the swap area	Total Average Maximum Minimum
Memory	Swap Free Bytes	Bytes	Size of unused remaining swap space	Total Average Maximum Minimum
Network	Network In Bytes	Bytes/Second	Received capacity (bytes/second) on the network interface	Total Average Maximum Minimum
Network	Network Out Bytes	Bytes/Second	Transmitted capacity (bytes/second) on the network interface	Total Average Maximum Minimum
Network	TCP Connections	Count/Second	Total number of TCP connections currently properly established	Total Average Maximum Minimum
Network	Network In Packets	Count	Number of packets received on the network interface	Total Average Maximum Minimum
Network	Network Out Packets	Count	Number of packets transmitted on the network interface	Total Average Maximum Minimum
Network	Network In Dropped	Count	Number of packet drops received on the network interface	Total Average Maximum Minimum
Network	Network Out Dropped	Count	Number of packet drops transmitted from the network interface	Total Average Maximum Minimum
Network	Network In Errors	Count	Number of packet errors received on the network interface	Total Average Maximum Minimum
Network	Network Out Errors	Count	Number of packet errors transmitted from the network interface	Total Average Maximum Minimum
OS	OS Uptime	Seconds	Time elapsed (seconds) since the system was last booted	Total Average Maximum Minimum

Table. OS basic metrics

MySQL Basic Metrics

Classification	Performance items	unit	Detailed description	meaningful statistics
Activelock	Active locks	Count	Number of transactions in lock wait (Lock Wait) state for 1 minute (60 seconds) or longer in the InnoDB storage engine	Total Average Maximum Minimum
Activesession	Active sessions	Count	Number of active sessions	Total Average Maximum Minimum
Activesession	Connection usage	Percent	DB connection session usage rate	Total Average Maximum Minimum
Activesession	Connections	Count	DB connection session	Total Average Maximum Minimum
Datafile	Binary log used	Bytes	Total size (Bytes) occupied by the Binary Log file	Total Average Maximum Minimum
Datafile	Relay log used	Bytes	Total size (Bytes) occupied by the Relay Log file	Total Average Maximum Minimum
Datafile	Current open files	Count	The number of file descriptors opened by the DB	Total Average Maximum Minimum
Datafile	Max open files	Count	Maximum number of file descriptors the DB can open	Total Average Maximum Minimum
Datafile	Open files usage	Percent	Maximum utilization rate of DB files	Total Average Maximum Minimum
InnoDB	InnoDB buffer pool hit ratio	Percent	The ratio of data read directly from memory without accessing the disk	Total Average Maximum Minimum
InnoDB	Innodb row lock wait transactions	Count	Current number of InnoDB transactions waiting for a row lock	Total Average Maximum Minimum
InnoDB	InnoDB row lock time	Milliseconds	Total time waited due to InnoDB row locks (in milliseconds)	Total Average Maximum Minimum
InnoDB	InnoDB deadlocks	Count/Minute	Number of deadlock occurrences	Total Average Maximum Minimum
InnoDB	Table lock waits	Count/Minute	Number of times waiting occurred to acquire a table lock	Total Average Maximum Minimum
InnoDB	Temp disk tables	Count	Number of Temp Tables created on disk	Total Average Maximum Minimum
InnoDB	Innodb log waits	Count	Number of times waited to write the redo log to disk	Total Average Maximum Minimum
State	Instance state	None	MySQL DB Process status up/down check 1 - Up 0 - Down	Total Average Maximum Minimum
State	Slave behind master seconds(8.0) (Replica Only)	Seconds	Replica latency (unit: seconds)	Total Average Maximum Minimum
State	Slave io thread running(8.0) (Replica Only)	None	I/O Thread status 1 - Running 0 - Down	Total Average Maximum Minimum
State	Slave SQL thread running(8.0) (Replica Only)	None	SQL Thread status 1 - Running 0 - Down	Total Average Maximum Minimum
State	Replica behind master seconds(8.4+) (Replica Only)	Seconds	Replica latency (unit: seconds)	Total Average Maximum Minimum
State	Replica io thread running(8.4+) (Replica Only)	None	I/O Thread status 1 - Running 0 - Down	Total Average Maximum Minimum
State	Replica SQL thread running(8.4+) (Replica Only)	None	SQL Thread status 1 - Running 0 - Down	Total Average Maximum Minimum
Tablespace	Tablespace used	Megabytes	Tablespace usage	Total Average Maximum Minimum
Tablespace	Tablespace used(TOTAL)	Megabytes	Tablespace usage (total)	Total Average Maximum Minimum
Transactions	Slow queries	Count	Number of queries exceeding the long_query_time configured in the DB	Total Average Maximum Minimum
Transactions	Long transaction time	Seconds	Long Transaction time	Total Average Maximum Minimum
Transactions	Wait locks	Count	Number of sessions waiting for lock	Total Average Maximum Minimum
Transactions	SQL Queries/Minute	Count/Minute	Queries executed per minute	Total Average Maximum Minimum

Table. MySQL basic metrics

Monitoring metrics

How-to guides