This topic describes how to view the resource metrics and engine metrics of an ApsaraDB RDS for MariaDB instance in the ApsaraDB RDS console.
Procedure
Log on to the ApsaraDB RDS console.
In the left-side navigation pane, click Instances. In the top navigation bar, select the region of your RDS instance.
Find the RDS instance and click the instance ID.
In the left-side navigation pane, click Monitoring and Alerts.
On the Standard Monitoring tab, click Resource Monitoring or Engine Monitoring and specify a time range to view the monitoring data. The following table describes the metrics.
Section
Metric
Description
Resource Monitoring
IOPS
The numbers of input/output operations per second (IOPS) of the data and log disks.
CPU Utilization and Memory Usage (%)
The CPU utilization and memory usage of the RDS instance.
Disk Space (MB)
The disk usage of the RDS instance. The disk usage provides the following information:
Disk Space Used
Data Space Used
Log Space Used
Temporary File Space Used
System File Space Used
Unit: MB.
Total Connections
The number of active connections to your RDS instance and the total number of connections to your RDS instance.
Network Traffic (KB)
The volumes of inbound and outbound traffic of the RDS instance per second. Unit: KB.
Engine Monitoring
Transactions per Second (TPS)/Queries per Second (QPS)
The average number of transactions per second (TPS) and the average number of SQL statements that are executed per second.
InnoDB Buffer Pool Read Hit Ratio, Usage Ratio, and Dirty Block Ratio (%)
The read hit ratio, usage, and dirty ratio of the InnoDB buffer pool.
InnoDB Read/Write Volume (KB)
The amount of data that InnoDB reads and writes per second. Unit: KB.
InnoDB Buffer Pool Read/Write Frequency
The number of read and write operations that InnoDB performs per second.
InnoDB Log Reads, Writes, and fsync() Operations
The average frequency of physical writes to log files per second by InnoDB, the frequency of log write requests, and the average frequency of fsync writes to log files.
Temporary Tables Automatically Created on Hard Disk when MySQL Statements Are Executed
The number of temporary tables that are automatically created on the hard disk when SQL statements are executed.
MySQL_COMDML
The number of SQL statements that the database executes per second. The following SQL statements are included:
Insert
Delete
Insert_Select
Replace
Replace_Select
Select
Update
MySQL_RowDML
The number of operations that InnoDB performs per second. The following items are included:
The number of physical writes to log files per second.
The number of rows on which InnoDB performs operations per second. This includes the number of rows that are read from InnoDB tables per second, the number of rows that are updated in InnoDB tables per second, the number of rows that are deleted from InnoDB tables per second, and the number of rows that are inserted into InnoDB tables per second.
MyISAM Reads and Writes
The number of reads from the buffer pool by MyISAM per second, the number of writes to the buffer pool by MyISAM per second, the number of reads from the hard disk by MyISAM per second, and the number of writes to the hard disk by MyISAM per second.
MyISAM Key Buffer Read/Write/Usage Ratio (%)
The read hit ratio, write hit ratio, and usage of the MyISAM key buffer per second.