The page has been translated by Gen AI.

ServiceWatch metrics

MariaDB sends metrics to ServiceWatch. The metrics provided by basic monitoring are collected at a 1-minute interval.

Reference

To view metrics in ServiceWatch, refer to the ServiceWatch guide.

Basic Metrics

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

The metrics whose names are shown in bold below are the key metrics selected from the default metrics provided by MariaDB(DBaaS). Key metrics are used to build service-specific dashboards that are automatically created in ServiceWatch.

Each metric specifies which statistical values are meaningful when querying that metric, as described in the user guide. Among the meaningful statistics, the values displayed in bold are the primary statistics. You can view key metrics through key statistics on the service dashboard.

OS Basic Metrics

Category	Performance Item	Unit	Detailed Description	Meaningful Statistics
CPU	CPU Usage	Percent	CPU Usage	Total Average Max Min
Disk	Disk Usage	Percent	Disk Usage	Total Average Max Min
Disk	Disk Write Bytes	Bytes/Second	Write throughput (bytes/second) for block devices	Total Average Maximum Minimum
Disk	Disk Read Bytes	Bytes/Second	Amount of data read from block devices (bytes/second)	Total Average Maximum Minimum
Disk	Disk Write Requests	Count/Second	Number of write requests per second (requests/second) on a block device	Total Average Maximum Minimum
Disk	Disk Read Requests	Count/Second	Number of read requests per second (requests/second) on a block device	Total Average Maximum Minimum
Disk	Average Disk I/O Queue Size	ERROR	Average queue length of requests issued to a block device	Total Average Maximum Minimum
Disk	Disk I/O Utilization	Percent	The percentage of time the block device actually processed I/O operations	Total Average Maximum Minimum
Memory	Memory Usage	Percent	Memory usage	Total Average Maximum Minimum
Memory	Swap Out Bytes	Bytes/Second	Amount of capacity swapped out from memory to the swap area (bytes/second)	Total Average Maximum Minimum
Memory	Swap Used Bytes	Bytes	The size of the swap space currently in use	Total Average Maximum Minimum
Memory	Swap Cached Usage	Percent	Cached swap usage	Total Average Maximum Minimum
Memory	Swap Total Bytes	Bytes	The total size of the swap space configured on the system	Total Average Maximum Minimum
Memory	Swap In Bytes	Bytes/Second	Amount of data read from the swap area into memory (bytes/second)	Total Average Maximum Minimum
Memory	Swap Usage	Percent	Percentage of current usage relative to total swap space	Total Average Maximum Minimum
Memory	Swap Cached Bytes	Bytes	The size of a page that has been restored to memory but still has a copy remaining in the swap area	Total Average Maximum Minimum
Memory	Swap Free Bytes	Bytes	The size of the remaining unused swap space	Total Average Maximum Minimum
Network	Network In Bytes	Bytes/Second	Received capacity (bytes per second) on the network interface	Total Average Maximum Minimum
Network	Network Out Bytes	Bytes/Second	Transmitted capacity (bytes per second) on the network interface	Total Average Maximum Minimum
Network	TCP Connections	Count/Second	The total number of currently established TCP connections	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 dropped packets received on the network interface	Total Average Maximum Minimum
Network	Network Out Dropped	Count	Number of dropped packets transmitted on 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 transmitted packet errors on the network interface	Total Average Maximum Minimum
OS	OS Uptime	Seconds	The number of seconds elapsed since the system last booted	Total Average Maximum Minimum

Table. OS baseline metrics

MariaDB Basic Metrics

Category	Performance Item	Unit	Detailed Description	Meaningful Statistics
Activelock	Active locks	Count	The number of transactions in a lock wait state for more than 1 minute (60 seconds) in the InnoDB storage engine	Total Average Maximum Minimum
Active session	Active sessions	Count	Number of active sessions	Total Average Maximum Minimum
Active session	Connection usage	Percent	DB Connection Session Usage	Total Average Maximum Minimum
Active session	Connections	Count	DB connection session	Total Average Maximum Minimum
Active session	Aborted Connections	Count/Minute	Number of abnormally terminated connections	Total Average Maximum Minimum
Datafile	Binary log used	Bytes	Total size (in bytes) occupied by the Binary Log file	Total Average Maximum Minimum
Datafile	Relay log used	Bytes	Total size (in 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	The maximum number of file descriptors that the DB can open	Total Average Maximum Minimum
Datafile	Open files usage	Percent	DB file maximum count usage	Total Average Maximum Minimum
InnoDB	InnoDB buffer pool hit ratio	Percent	The percentage of data read directly from memory without accessing the disk	Total Average Maximum Minimum
InnoDB	InnoDB row lock wait transactions	Count	The number of InnoDB transactions currently waiting for a row lock	Total Average Maximum Minimum
InnoDB	InnoDB row lock time	Milliseconds	Total time spent waiting 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	The number of times a wait 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 Redo logs to disk	Total Average Maximum Minimum
State	Instance state	ERROR	Check MariaDB status up/down 1 - Up 0 - Down	Total Average Maximum Minimum
State	Slave behind master seconds	Seconds	Replication lag (unit: seconds)	Total Average Maximum Minimum
State	Slave IO thread running (Replica Only)	ERROR	I/O Thread Status 1: Running 0: Down	Total Average Maximum Minimum
State	Slave SQL thread running (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	The number of queries that take longer than the `long_query_time` configured in the database	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 a lock	Total Average Maximum Minimum
Transactions	SQL Queries/Minute	Count/Minute	Queries per minute	Total Average Maximum Minimum

Table. MariaDB basic metrics

Monitoring Metrics

How-to guides