Database Autonomy Service (DAS) provides the monitoring dashboard feature. DAS allows you to specify database instances and metrics to monitor and compare the metrics of the database instances. You can also configure metric linkage. This helps you understand the status of database instances.

Prerequisites

Add a monitoring dashboard

  1. Log on to the DAS console.
  2. In the left-side navigation pane, click Monitoring Dashboard.
  3. On the Custom Dashboard page, click a tab to select a database engine.
  4. On the tab for the specified database engine, click Add Monitoring Dashboard.
  5. In the Create Monitoring Dashboard dialog box, configure Dashboard Name and click OK.
  6. Click Select Instances and Metrics. In the Select Metrics and Instances dialog box, select the instances that you want to monitor and the metrics that you want to view. Then, click .
    Note
    • You can select up to 32 instances at a time.
    • For more information about monitoring metrics, see Metrics.
  7. Click Confirm.
    Note To modify the instances or metrics in the monitoring dashboard, click Add Instances and Metrics.

View the metric trends of a database instance in the monitoring dashboard

  1. Log on to the DAS console.
  2. In the left-side navigation pane, click Monitoring Dashboard.
  3. On the Custom Dashboard page, click a tab to select a database engine.
  4. On the tab for the specified database engine, select the monitoring dashboard that you want to view and then specify a time range over which you want to view the metric trend charts.
    When you select a time range, the end time must be later than the start time, and the interval between the start time and the end time cannot exceed seven days.
    Note If your database instance is an ApsaraDB for Redis instance, the interval between the start time and the end time cannot exceed 3 hours.
    • You can configure Filter by Instance to select multiple instances and compare their metrics.
    • If you turn on Auto Refresh (Every 5Seconds), DAS refreshes metric trend charts every five seconds.
    • If you turn on Linkage Chart, the multi-metric linkage feature is enabled. You can view the values of different metrics at the same time point.
    • You can configure Chart Layout to specify the number of metric trend charts that can be displayed in each row.
    • You can click Add Instances and Metrics to modify the database instances or metrics in the monitoring dashboard.
    • You can click Details in the trend chart of a metric to zoom in the trend chart. In this case, you can change the time range to view the trends of the metric over the specified time range.
    • You can click Delete in the trend chart of a metric to delete the metric from the dashboard.

Metrics

Table 1. Metrics of ApsaraDB RDS for MySQL instances and self-managed MySQL databases
CategoryMetricDescription
MySQL ServertpsThe transactions per second (TPS) of the MySQL database.
qpsThe queries per second (QPS) of the MySQL database.
active_sessionThe number of active sessions.
total_sessionThe total number of sessions.
delete_psThe average number of DELETE statements that are executed per second.
insert_psThe average number of INSERT statements that are executed per second.
replace_psThe average number of REPLACE statements that are executed per second.
update_psThe average number of UPDATE statements that are executed per second.
select_psThe average number of SELECT statements that are executed per second.
bytes_receivedThe average number of bytes that are received from all clients per second
bytes_sentThe average number of bytes that are sent to all clients per second
iops_usageThe IOPS usage.
InnoDB storage engineinnodb_bp_hitThe read cache hit ratio of the InnoDB buffer pool.
innodb_bp_dirty_pctThe ratio of dirty pages in the InnoDB buffer pool.
innodb_bp_usage_pctThe utilization of the InnoDB buffer pool.
innodb_data_writtenThe average number of bytes that are written to the InnoDB table per second.
innodb_data_readThe average number of bytes that are read from the InnoDB table per second.
innodb_rows_deletedThe average number of rows that are deleted from the InnoDB table per second.
innodb_rows_readThe average number of rows that are read from the InnoDB table per second.
innodb_rows_insertedThe average number of rows that are inserted into the InnoDB table per second.
innodb_rows_updatedThe average number of rows that are updated in the InnoDB table per second.
MySQL processcpu_usageThe CPU utilization of the MySQL process. The maximum value of this metric is 100% for Alibaba Cloud database instances.
mem_usageThe memory usage of the MySQL database within the operating system.
iopsThe IOPS of the MySQL database.
disk_usageThe disk usage.
Table 2. Metrics of ApsaraDB for Redis instances and self-managed Redis databases
CategoryMetricDescription
Databaseinstantaneous_ops_per_secThe number of commands that are processed per second.
get_qpsThe number of read requests per second.
put_qpsThe number of write requests per second.
connection_usageThe connection usage.
inflowThe data read from the database over the network per second.
outflowThe data written to the database over the network per second.
used_memoryThe total number of bytes that Redis uses its allocator to allocate.
mem_usageThe memory usage.
Redisavg_rtThe average response time of Redis.
max_rtThe maximum response time of Redis.
proxy.avg_rtThe average response time of the Redis proxy node.
proxy.max_rtThe maximum response time of the Redis proxy node.
proxy.connection_usageThe connection usage of the Redis proxy.
cpu_usageThe CPU utilization of the Redis process.
Keysevicted_keysThe number of keys that are evicted due to the maximum memory limit.
total_keysThe total number of keys in the database.
expired_keysThe total number of key expiration events.
Redis KeyshitThe number of hit keys.
missThe number of missed keys.
Table 3. Metrics of ApsaraDB for MongoDB instances and self-managed MongoDB databases
CategoryMetricDescription
MongoDBopcounters.insertThe number of INSERT statements that are executed per second in MongoDB.
opcounters.queryThe number of QUERY statements that are executed per second in MongoDB.
opcounters.updateThe number of UPDATE statements that are executed per second in MongoDB.
opcounters.deleteThe number of DELETE statements that are executed per second in MongoDB.
opcounters.commandThe number of COMMAND statements that are executed per second in MongoDB.
opcounters.getmoreThe number of GETMORE statements that are executed per second in MongoDB.
connections.currentThe number of active sessions in MongoDB.
metrics.cursor.open.totalThe number of open cursors in MongoDB.
metrics.cursor.timedOutThe number of timeout cursors in MongoDB.
network.bytesInThe number of bytes written to MongoDB per second.
network.bytesOutThe number of bytes read from MongoDB per second.
network.numRequestsThe number of requests sent to MongoDB per second.
MongoDB processcpu_usageThe CPU utilization of the MongoDB process.
mem_usageThe memory usage of the MongoDB process.
disk_usageThe disk usage of the MongoDB process.
Table 4. Metrics of ApsaraDB RDS for PostgreSQL instances
CategoryMetricDescription
Hostcpu_sys_ratioThe CPU utilization of the PostgreSQL process in the kernel state.
cpu_user_ratioThe CPU utilization of the PostgreSQL process in the user state.
cpu_usageThe CPU utilization of the PostgreSQL process.
mem_usageThe memory usage of the PostgreSQL process.
data.r_sThe read IOPS of the disk on which the data directory resides.
data.iopsThe IOPS of the disk on which the data directory resides.
data.w_sThe write IOPS of the disk on which the data directory resides.
local_fs_size_totalThe total amount of disk space of the host.
data.fs.usedThe amount of used space of the disk on which the data directory resides.
data.fs.usageThe space usage of the disk on which the data directory resides.
network_out_ioThe outbound network traffic of the PostgreSQL process.
network_ioThe network traffic of the PostgreSQL process.
network_in_ioThe inbound network traffic of the PostgreSQL process.
PostgreSQL basic monitoringwaiting_connectionThe number of pending connections.
idle_in_transactionThe number of idle sessions.
active_sessionThe number of active connections.
total_sessionThe total number of current connections.
tup_insertedThe number of records that are inserted per second.
tup_deletedThe number of records that are deleted per second.
tup_updatedThe number of records that are updated per second.
tup_returnedThe number of records that are returned per second for full table scans.
tup_fetchedThe number of records that are returned per second for index scans.
tpsThe TPS in PostgreSQL.
xact_rollbackThe number of transactions that are rolled back per second.
xact_commitThe number of transactions that are committed per second.
deadlocksThe number of deadlocks per second.
oldest_snapshotThe point in time before which the generated dead tuples can be recycled by the ApsaraDB RDS for PostgreSQL instance.
max_sent_delayThe latency of data replication from the secondary ApsaraDB RDS for PostgreSQL instance.
max_replay_delayThe latency at which the secondary ApsaraDB RDS for PostgreSQL instance replays transaction commits.
long_query_5sThe number of SQL statements whose execution duration is greater than or equal to five seconds.
long_query_1sThe number of SQL statements whose execution duration is greater than or equal to one second.
long_query_3sThe number of SQL statements whose execution duration is greater than or equal to three seconds.
long_idle_in_transaction_3sThe number of transactions that are idle for three seconds or longer.
long_idle_in_transaction_5sThe number of transactions that are idle for five seconds or longer.
long_idle_in_transaction_1sThe number of transactions that are idle for one second or longer.
long_2pc_1sThe number of 2PC transactions that last for one second or longer.
long_2pc_5sThe number of 2PC transactions that last for five seconds or longer.
long_2pc_3sThe number of 2PC transactions that last for three seconds or longer.
Table 5. Metrics of ApsaraDB RDS for SQL Server instances
CategoryMetricDescription
SQL Server processcpu_usageThe CPU utilization of the ApsaraDB RDS for SQL Server instance within the operating system.
db_ioThe number of I/O requests per second.
db_io_readThe number of read I/O requests per second.
db_io_writeThe number of write I/O requests per second.
other_sizeThe amount of disk space occupied by system files.
log_sizeThe amount of disk space occupied by log files.
tmp_sizeThe amount of disk space occupied by temporary files.
ins_sizeThe total amount of disk space occupied by the ApsaraDB RDS for SQL Server instance.
data_sizeThe amount of disk space occupied by data files.
DatabaseqpsThe average number of SQL statements that are executed per second.
connection_resetThe total number of logon attempts from the connection pool per second.
active_temp_tablesThe number of active temporary tables.
active_sessionThe number of active threads.
active_cursorsThe number of active cursors.
sessionsThe total number of connections.
active_transactionsThe number of active transactions.
transactionsThe average number of transactions per second.
write_transactionsThe average number of write transactions per second.
read_kbThe average volume of outbound traffic from the ApsaraDB RDS for SQL Server instance per second.
write_kbThe average volume of inbound traffic to the ApsaraDB RDS for SQL Server instance per second.
Basic monitoringcache_hit_ratioThe hit ratio of the high-speed cache.
bufferpoolThe percentage of pages that are found in the high-speed cache to all pages that are read from disks.
fullscansThe average number of full table scans per second.
autoparam_attempts_per_secThe number of auto parameterization attempts per second.
forced_parameterizations_per_secThe number of successful forced parameterizations per second.
sql_compilationsThe number of SQL compilations per second.
unsafe_autoparams_per_secThe number of unsafe auto parameterization attempts per second.
failed_autoparams_per_secThe number of auto parameterization failures per second.
safe_autoparams_per_secThe number of safe auto parameterization attempts per second.
resqlcompilationsThe number of SQL statement recompilations per second.
lazy_writesThe number of times that dirty pages are written to disks per second.
checkpointThe number of dirty pages that the checkpoint operation must write per second.
logoutThe number of logouts per second.
loginsThe number of logons per second.
locktimeoutThe number of lock requests that time out per second, including requests for NOWAIT locks.
deadlockThe number of lock requests that result in a deadlock per second.
lock_requests_per_secThe number of new locks and lock conversions per second.
lockwaitsThe number of lock requests that the client waits for per second.
lock_waitsThe statistics of processes waiting for locks.
latchwaitsThe number of latch requests that are not immediately granted per second.
lock_wait_time_msThe average amount of wait time for each lock request that results in a wait.
average_latch_wait_timeThe average wait time required to request a latch resource.
table_lock_escalations_per_secThe number of times that a lock on a table is escalated to the HoBT level or the table level.
average_lock_wait_timeThe average wait time of the requested lock resource.
total_latch_wait_timeThe total wait time for locks in the last second.
Table 6. Metrics of PolarDB for MySQL clusters
CategoryMetricDescription
Databasecom_deleteThe average number of DELETE statements that are executed per second.
com_insertThe average number of INSERT statements that are executed per second.
com_replaceThe average number of REPLACE statements that are executed per second.
com_selectThe average number of SELECT statements that are executed per second.
com_updateThe average number of UPDATE statements that are executed per second.
qpsThe QPS of the PolarDB for MySQL cluster.
tpsThe TPS of the PolarDB for MySQL cluster.
PolarDB processcpu_usageThe CPU utilization of the PolarDB process. The value 200% indicates that two CPU cores are used.
mem_usageThe memory usage of the PolarDB for MySQL cluster within the operating system.
PolarDB Serveractive_sessionThe number of active sessions.
total_sessionThe total number of sessions.
output_trafficThe average number of bytes that are sent to all clients per second
input_trafficThe average number of bytes that are received from all clients per second
InnoDB storage engineinnodb_data_readThe average number of bytes that are read from the InnoDB table per second.
innodb_data_writtenThe average number of bytes that are written to the InnoDB table per second.
innodb_buffer_dirty_ratioThe ratio of dirty pages in the InnoDB buffer pool.
innodb_buffer_read_hitThe read cache hit ratio of the InnoDB buffer pool.
innodb_buffer_use_ratioThe utilization of the InnoDB buffer pool.
innodb_rows_deletedThe average number of rows that are deleted from the InnoDB table per second.
innodb_rows_insertedThe average number of rows that are inserted into the InnoDB table per second.
innodb_rows_readThe average number of rows that are read from the InnoDB table per second.
innodb_rows_updatedThe average number of rows that are updated in the InnoDB table per second.
Note You can click the Question mark icon icon on the right of a metric in a dashboard to view the description of the metric.