Updated on 2023-09-26 GMT+08:00

Configuring Displayed Metrics

Notes

  • The RDS Agent monitors RDS DB instances and collects monitoring metrics only.
  • The monitoring interval is 1 minute.

Namespace

SYS.RDS

DB Instance Monitoring Metrics

The following table lists the performance metrics of RDS for MariaDB instances.
Table 1 Performance metrics

No.

Metric ID

Name

Description

Value Range

Monitored Object

Monitoring Interval (Raw Data)

1

rds001_cpu_util

CPU Usage

CPU usage of the monitored object

0-100%

RDS for MariaDB instance

1 minute

2

rds002_mem_util

Memory Usage

Memory usage of the monitored object

0-100%

RDS for MariaDB instance

1 minute

3

rds003_iops

IOPS

Average number of I/O requests processed by the system in a specified period

≥ 0 counts/s

RDS for MariaDB instance

1 minute

4

rds004_bytes_in

Network Input Throughput

Incoming traffic in bytes per second

≥ 0 bytes/s

RDS for MariaDB instance

1 minute

5

rds005_bytes_out

Network Output Throughput

Outgoing traffic in bytes per second

≥ 0 bytes/s

RDS for MariaDB instance

1 minute

6

rds006_conn_count

Total Connections

Total number of connections that attempt to connect to the MariaDB server

≥ 0 counts

RDS for MariaDB instance

1 minute

7

rds007_conn_active_count

Current Active Connections

Number of current active connections

≥ 0 counts

RDS for MariaDB instance

1 minute

8

rds008_qps

QPS

Query times of SQL statements (including stored procedures) per second

≥ 0 queries/s

RDS for MariaDB instance

1 minute

9

rds009_tps

TPS

Execution times of submitted and rollback transactions per second

≥ 0 transactions/s

RDS for MariaDB instance

1 minute

10

rds010_innodb_buf_usage

Buffer Pool Usage

Ratio of idle pages to the total number of buffer pool pages in the InnoDB buffer

0–1

RDS for MariaDB instance

1 minute

11

rds011_innodb_buf_hit

Buffer Pool Hit Ratio

Ratio of read hits to read requests in the InnoDB buffer

0–1

RDS for MariaDB instance

1 minute

12

rds012_innodb_buf_dirty

Buffer Pool Dirty Block Ratio

Ratio of dirty data to used pages in the InnoDB buffer

0–1

RDS for MariaDB instance

1 minute

13

rds013_innodb_reads

InnoDB Read Throughput

Number of read bytes per second in the InnoDB buffer

≥ 0 bytes/s

RDS for MariaDB instance

1 minute

14

rds014_innodb_writes

InnoDB Write Throughput

Number of write bytes per second in the InnoDB buffer

≥ 0 bytes/s

RDS for MariaDB instance

1 minute

15

rds015_innodb_read_count

InnoDB File Read Frequency

Number of times that InnoDB reads data from files per second

≥ 0 counts/s

RDS for MariaDB instance

1 minute

16

rds016_innodb_write_count

InnoDB File Write Frequency

Number of times that InnoDB writes data to files per second

≥ 0 counts/s

RDS for MariaDB instance

1 minute

17

rds017_innodb_log_write_req_count

InnoDB Log Write Requests per Second

Number of InnoDB log write requests per second

≥ 0 counts/s

RDS for MariaDB instance

1 minute

18

rds018_innodb_log_write_count

InnoDB Log Physical Write Frequency

Number of InnoDB physical write times to log files per second

≥ 0 counts/s

RDS for MariaDB instance

1 minute

19

rds019_innodb_log_fsync_count

InnoDB Log fsync() Write Frequency

Number of completed fsync() write times to InnoDB log files per second

≥ 0 counts/s

RDS for MariaDB instance

1 minute

20

rds020_temp_tbl_rate

Temporary Tables Created per Second

Number of temporary tables created on hard disks per second

≥ 0 counts/s

RDS for MariaDB instance

1 minute

21

rds021_myisam_buf_usage

Key Buffer Usage

MyISAM key buffer usage

0–1

RDS for MariaDB instance

1 minute

22

rds022_myisam_buf_write_hit

Key Buffer Write Hit Ratio

MyISAM key buffer write hit ratio

0–1

RDS for MariaDB instance

1 minute

23

rds023_myisam_buf_read_hit

Key Buffer Read Hit Ratio

MyISAM key buffer read hit ratio

0–1

RDS for MariaDB instance

1 minute

24

rds024_myisam_disk_write_count

MyISAM Disk Write Frequency

Number of times that indexes are written to disks per second

≥ 0 counts/s

RDS for MariaDB instance

1 minute

25

rds025_myisam_disk_read_count

MyISAM Disk Read Frequency

Number of times that indexes are read from disks per second

≥ 0 counts/s

RDS for MariaDB instance

1 minute

26

rds026_myisam_buf_write_count

MyISAM Buffer Pool Write Requests per Second

Number of requests for writing indexes into the MyISAM buffer pool per second

≥ 0 counts/s

RDS for MariaDB instance

1 minute

27

rds027_myisam_buf_read_count

MyISAM Buffer Pool Read Requests per Second

Number of requests for reading indexes from the MyISAM buffer pool per second

≥ 0 counts/s

RDS for MariaDB instance

1 minute

28

rds028_comdml_del_count

DELETE Statements per Second

Number of DELETE statements executed per second

≥ 0 queries/s

RDS for MariaDB instance

1 minute

29

rds029_comdml_ins_count

INSERT Statements per Second

Number of INSERT statements executed per second

≥ 0 queries/s

RDS for MariaDB instance

1 minute

30

rds030_comdml_ins_sel_count

INSERT_SELECT Statements per Second

Number of INSERT_SELECT statements executed per second

≥ 0 queries/s

RDS for MariaDB instance

1 minute

31

rds031_comdml_rep_count

REPLACE Statements per Second

Number of REPLACE statements executed per second

≥ 0 queries/s

RDS for MariaDB instance

1 minute

32

rds032_comdml_rep_sel_count

REPLACE_SELECTION Statements per Second

Number of REPLACE_SELECTION statements executed per second

≥ 0 queries/s

RDS for MariaDB instance

1 minute

33

rds033_comdml_sel_count

SELECT Statements per Second

Number of SELECT statements executed per second

≥ 0 queries/s

RDS for MariaDB instance

1 minute

34

rds034_comdml_upd_count

UPDATE Statements per Second

Number of UPDATE statements executed per second

≥ 0 queries/s

RDS for MariaDB instance

1 minute

35

rds035_innodb_del_row_count

Row Delete Frequency

Number of rows deleted from the InnoDB table per second

≥ 0 rows/s

RDS for MariaDB instance

1 minute

36

rds036_innodb_ins_row_count

Row Insert Frequency

Number of rows inserted into the InnoDB table per second

≥ 0 rows/s

RDS for MariaDB instance

1 minute

37

rds037_innodb_read_row_count

Row Read Frequency

Number of rows read from the InnoDB table per second

≥ 0 rows/s

RDS for MariaDB instance

1 minute

38

rds038_innodb_upd_row_count

Row Update Frequency

Number of rows updated into the InnoDB table per second

≥ 0 rows/s

RDS for MariaDB instance

1 minute

39

rds039_disk_util

Storage Space Usage

Storage space usage of the monitored object

0-100%

RDS for MariaDB instance

1 minute

40

rds047_disk_total_size

Total Storage Space

Total storage space of the monitored object

40–4,000 GB

RDS for MariaDB instance

1 minute

41

rds048_disk_used_size

Used Storage Space

Used storage space of the monitored object

0–4,000 GB

RDS for MariaDB instance

1 minute

42

rds049_disk_read_throughput

Disk Read Throughput

Number of bytes read from the disk per second

≥ 0 bytes/s

RDS for MariaDB instance

1 minute

43

rds050_disk_write_throughput

Disk Write Throughput

Number of bytes written into the disk per second

≥ 0 bytes/s

RDS for MariaDB instance

1 minute

44

rds072_conn_usage

Connection Usage

Percent of used MariaDB connections to the total number of connections

0-100%

RDS for MariaDB instance

1 minute

45

rds073_replication_delay

Real-Time Replication Delay

Real-time replication delay between standby DB instances or read replicas and primary DB instances, corresponding to seconds_behind_master.

≥ 0s

RDS for MariaDB instance

1 minute

5 seconds

46

rds074_slow_queries

Slow Query Logs

Number of slow query logs generated per minute by MariaDB

≥ 0

RDS for MariaDB instance

1 minute

47

rds075_avg_disk_ms_per_read

Disk Read Time

Average time required for each disk read in a specified period

≥ 0 ms

RDS for MariaDB instance

1 minute

48

rds076_avg_disk_ms_per_write

Disk Write Time

Average time required for each disk write in a specified period

≥ 0 ms

RDS for MariaDB instance

1 minute

49

rds077_vma

VMA

Virtual memory area size of an RDS process

≥ 0 counts

RDS for MariaDB instance

1 minute

50

rds078_threads

Threads

Number of threads in a process

≥ 0 counts

RDS for MariaDB instance

1 minute

51

rds079_vm_hwm

Peak Resident Set Size

Peak physical memory usage of an RDS process

≥ 0 KB

RDS for MariaDB instance

1 minute

52

rds080_vm_peak

Peak Virtual Memory Size

Peak virtual memory usage of an RDS process

≥ 0 KB

RDS for MariaDB instance

1 minute

53

rds082_semi_sync_tx_avg_wait_time

Transaction Wait Time

Average wait time of transactions in semi-synchronous mode

≥ 0 μs

RDS for MariaDB instance

1 minute

54

rds173_replication_delay_avg

Average Replication Delay

Average replication delay within 60s between standby DB instances or read replicas and primary DB instances, corresponding to seconds_behind_master

≥ 0s

RDS for MariaDB instance

1 minute

55

rds_buffer_pool_wait_free

Dirty Pages to Be Flushed to Disks

When InnoDB needs to read or create a page and no clean pages are available, InnoDB flushes some dirty pages first and waits for that operation

≥ 0 counts

RDS for MariaDB instance

1 minute

56

rds_bytes_recv_rate

Received Bytes per Second

Number of bytes received by the database per second

≥ 0 bytes/s

RDS for MariaDB instance

1 minute

57

rds_bytes_sent_rate

Sent Bytes per Second

Number of bytes sent from the database per second

≥ 0 bytes/s

RDS for MariaDB instance

1 minute

58

rds_conn_active_usage

Active Connection Usage

Usage of active connections

0-100%

RDS for MariaDB instance

1 minute

59

rds_created_tmp_tables_rate

Temporary Tables Created per Second

Number of temporary tables created per second

≥ 0 counts/s

RDS for MariaDB instance

1 minute

60

rds_innodb_buffer_pool_pages_flushed_rate

Innodb_buffer_pool Page Flushes per Second

Number of innodb_buffer_pool page flushes per second

≥ 0 counts/s

RDS for MariaDB instance

1 minute

61

rds_innodb_buffer_pool_read_requests_rate

Innodb_buffer_pool Read Requests per Second

Number of innodb_buffer_pool read requests per second

≥ 0 counts/s

RDS for MariaDB instance

1 minute

62

rds_innodb_buffer_pool_write_requests_rate

Innodb_buffer_pool Write Requests per Second

Number of innodb_buffer_pool write requests per second

≥ 0 counts/s

RDS for MariaDB instance

1 minute

63

rds_innodb_lock_waits

Row Locks Waits

Number of InnoDB row lock waits

≥ 0 counts

RDS for MariaDB instance

1 minute

64

rds_innodb_log_waits_count

Log Buffer Status

Number of times that the log buffer was too small and a wait was required for it to be flushed before continuing

≥ 0 counts

RDS for MariaDB instance

1 minute

65

rds_innodb_log_waits_rate

Flush Times to Disks Due to Insufficient Log Buffer

Times of transaction logs flushed to disks due to insufficient log buffer

≥ 0 counts/s

RDS for MariaDB instance

1 minute

66

rds_innodb_os_log_written_rate

Redo Log Size Written per Second

Size of redo logs written per second

≥ 0 bytes/s

RDS for MariaDB instance

1 minute

67

rds_innodb_pages_read_rate

Data Volume Read By InnoDB per Second

Data volume read by InnoDB per second

≥ 0 Pages/s

RDS for MariaDB instance

1 minute

68

rds_innodb_pages_written_rate

Data Volume Written by InnoDB per Second

Data volume written by InnoDB per second

≥ 0 Pages/s

RDS for MariaDB instance

1 minute

69

rds_innodb_row_lock_current_waits

Current Row Lock Waits

Number of current InnoDB row lock waits

≥ 0 counts

RDS for MariaDB instance

1 minute

70

rds_innodb_row_lock_time_avg

Row Lock Wait Time

Average wait time of InnoDB row locks

≥ 0 ms

RDS for MariaDB instance

1 minute

71

rds_wait_thread_count

Waiting Threads

Number of waiting threads

≥ 0 counts

RDS for MariaDB instance

1 minute

Dimension

Key

Value

mariadb_cluster_id

RDS for MariaDB instance ID