The page has been translated by Gen AI.

ServiceWatch Metrics

MariaDB sends metrics to ServiceWatch. The metrics provided by default monitoring are data collected at a 1‑minute interval.

Reference

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

Basic Metrics

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

The indicators whose names are shown in bold below are the key indicators selected among the basic metrics provided by MariaDB(DBaaS). The key metrics are used to configure the service dashboards that are automatically built for each service in ServiceWatch.

Each metric guides users, through 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 using these primary statistical values.

OS Basic Metrics

Category	Performance items	unit	Detailed description	meaningful statistics
CPU	CPU Usage	Percent	CPU usage	Maximum
Disk	Disk Usage	Percent	Disk usage	Maximum
Disk	Disk Write Bytes	Bytes/Second	Write bandwidth (bytes/second) on block device	average maximum minimum
Disk	Disk Read Bytes	Bytes/Second	Read throughput from block device (bytes/second)	average maximum minimum
Disk	Disk Write Requests	Count/Second	Number of write requests on block device (requests per second)	average maximum minimum
Disk	Disk Read Requests	Count/Second	Number of read requests on block device (requests per second)	average maximum minimum
Disk	Average Disk I/O Queue Size	None	Average queue length of requests issued to the block device	average maximum minimum
Disk	Disk I/O Utilization	Percent	The proportion of time the block device actually spent handling I/O operations	average maximum minimum
Memory	Memory Usage	Percent	Memory usage	Maximum
Network	Network In Bytes	Bytes/Second	Received data rate (bytes/second) on the network interface	average maximum minimum
Network	Network Out Bytes	Bytes/Second	Transmitted capacity (bytes/second) on the network interface	average maximum minimum
Network	TCP Connections	Count/Second	Current total number of successfully established TCP connections	average maximum minimum
Network	Network In Packets	Count	Number of packets received on the network interface	average maximum minimum
Network	Network Out Packets	Count	Number of packets transmitted on the network interface	average maximum minimum
Network	Network In Dropped	Count	Number of packet drops received on the network interface	average maximum minimum
Network	Network Out Dropped	Count	Number of packet drops transmitted from the network interface	average maximum minimum
Network	Network In Errors	Count	Number of packet errors received on the network interface	average maximum minimum
Network	Network Out Errors	Count	Number of packet errors transmitted on the network interface	average maximum minimum

Table. OS basic metrics

MariaDB basic metrics

Category	Performance items	unit	Detailed description	meaningful statistics
Activelock	Active locks	Count	Number of transactions in the InnoDB storage engine that have been in lock wait state for 1 minute (60 seconds) or longer.	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
Activesession	Aborted Connections	Count/Minute	Number of abnormal terminated connections	Total Average Maximum Minimum
Datafile	Current open files	Count	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	DB file maximum count utilization	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 transactions rolled back due to deadlock	Total Average Maximum Minimum
InnoDB	Table lock waits	Count/Minute	Number of waits that occurred to acquire a table lock	Total Average Maximum Minimum
InnoDB	Temp disk tables	Count/Minute	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	Check Scalable DB up/down status 1 - Up 0 - Down	-
State	Slave behind master seconds	Seconds	Replica latency (unit: seconds)	Total Average Maximum Minimum
State	Slave io thread running (Replica Only)	None	I/O Thread status 1 - Running 0 - Down	-
State	Slave SQL thread running (Replica Only)	None	SQL Thread status 1 - Running 0 - Down	-
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 running longer than 10 seconds	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. MariaDB basic metrics

Monitoring Metrics

How-to guides