Monitor database instance performance-Database Autonomy Service(DAS)-阿里云帮助中心

The DAS monitoring dashboard lets you select database instances and metrics, compare metrics across database instances, and correlate metrics.

Prerequisites

The database instance must be one of the following types:
- ApsaraDB RDS for MySQL, self-managed MySQL, or PolarDB for MySQL
- ApsaraDB for Tair (Redis-compatible) or self-managed Redis
- ApsaraDB for MongoDB or self-managed MongoDB
- ApsaraDB RDS for PostgreSQL
- ApsaraDB RDS for SQL Server
Connect the database instance to DAS and make sure it is in the Normal Connection state. For connection instructions, see:

Add a monitoring dashboard

Log on to the DAS console.
In the left-side navigation pane, click Intelligent O&M Center > Monitoring Dashboard.
On the Custom Dashboard page, select a database engine.
On the target engine page, click Add Monitoring Dashboard.
In the Create Monitoring Dashboard dialog box, enter a name for the dashboard and click OK.
Click Select Instances and Metrics, select the target instance and the required metrics, and click .
Note
- You can select up to 32 instances at a time.
- For more information about metrics, see Metrics.
In the Select Metrics and Instances dialog box, select the desired instances from the upper list and the MySQL metrics, such as mysql.active_session, from the lower list. Then, click Confirm.
Click Confirm.

Note
To modify the instances or metrics on the dashboard, click Add Instances and Metrics.

View monitoring metric trends

Log on to the DAS console.
In the left-side navigation pane, click Intelligent O&M Center > Monitoring Dashboard.
On the Custom Dashboard page, select the target database engine.
On the tab for the target database engine, select a Monitoring Dashboard and set a time range. The dashboard then displays the trend charts for the monitoring metrics.
When you select a time range, the end time must be later than the start time, and the time range cannot exceed 7 days.

Note
For Redis instances, the time range cannot exceed 3 hours.
- Use the Filter by Instance to compare monitoring metrics across multiple instances.
- Enable Auto-refresh to refresh the charts every 5 seconds.
- Enable Linkage Chart to correlate metrics and view their values at the same point in time.
- Use Chart Layout to set the number of charts displayed per row.
- Click Add Instances and Metrics to change the instances or monitoring metrics on the dashboard.
- Click Details on a trend chart to enlarge it. You can also change the time range to view the metric's trend over different periods.
- Click Delete on a trend chart to remove the metric from the Monitoring Dashboard.

Metrics

Monitoring metrics for ApsaraDB RDS for MySQL and self-hosted MySQL
Monitoring metrics for ApsaraDB for Redis and self-hosted Redis
Monitoring metrics for ApsaraDB for MongoDB and self-hosted MongoDB
Monitoring metrics for ApsaraDB RDS for PostgreSQL
Monitoring metrics for ApsaraDB RDS for SQL Server
Monitoring metrics for PolarDB for MySQL

Table 1. Monitoring metrics for ApsaraDB RDS for MySQL and self-managed MySQL

Parameter type	Parameter	Description
MySQL Server	tps	Transactions per second (TPS).
	qps	Queries per second (QPS).
	active_session	Number of active sessions.
	total_session	Total number of sessions.
	delete_ps	Number of DELETE statements per second.
	insert_ps	Number of INSERT statements per second.
	replace_ps	Number of REPLACE statements per second.
	update_ps	Number of UPDATE statements per second.
	select_ps	Number of SELECT statements per second.
	bytes_received	Bytes received per second from all clients.
	bytes_sent	Bytes sent per second to all clients.
	iops_usage	IOPS utilization of the instance.
InnoDB storage engine	innodb_bp_hit	Cache hit rate of the InnoDB buffer pool.
	innodb_bp_dirty_pct	Percentage of dirty pages in the InnoDB buffer pool.
	innodb_bp_usage_pct	Utilization of the InnoDB buffer pool.
	innodb_data_written	Bytes written per second by InnoDB.
	innodb_data_read	Bytes read per second by InnoDB.
	innodb_rows_deleted	Rows deleted per second by InnoDB.
	innodb_rows_read	Rows read per second by InnoDB.
	innodb_rows_inserted	Rows inserted per second by InnoDB.
	innodb_rows_updated	Rows updated per second by InnoDB.
MySQL service process	cpu_usage	CPU utilization of the MySQL service process. The maximum is 100% for ApsaraDB instances.
	mem_usage	The percentage of total system memory used by the MySQL instance.
	iops	Number of I/O operations per second (IOPS) for the MySQL instance.
	disk_usage	Disk space utilization.

Table 2. Monitoring metrics for ApsaraDB for Tair (Redis-compatible) and self-managed Redis

Parameter type	Parameter	Description
Basic database metrics	instantaneous_ops_per_sec	Number of commands processed per second.
	get_qps	Number of read command requests per second.
	put_qps	Number of write command requests per second.
	connection_usage	Connection utilization.
	inflow	Inbound network traffic per second.
	outflow	Outbound network traffic per second.
	used_memory	Total number of bytes allocated by the Redis allocator.
	mem_usage	Memory utilization.
Basic Redis metrics	avg_rt	Average response time.
	max_rt	Maximum response time.
	proxy.avg_rt	Average response time of the proxy node.
	proxy.max_rt	Maximum response time of the proxy node.
	proxy.connection_usage	Connection utilization of the proxy node.
	cpu_usage	CPU utilization of the Redis process.
Metrics for keys	evicted_keys	Number of keys evicted due to the maxmemory limit.
	total_keys	Total number of keys across all databases.
	expired_keys	Total number of key expiration events.
Redis keys	hit	Number of successful key lookups (hits).
Redis keys	miss	Number of unsuccessful key lookups (misses).

Table 3. Monitoring metrics for ApsaraDB and self-managed MongoDB

Type	Parameter	Description
MongoDB basic metrics	opcounters.insert	Insert operations per second.
	opcounters.query	Query operations per second.
	opcounters.update	Update operations per second.
	opcounters.delete	Delete operations per second.
	opcounters.command	Command operations per second.
	opcounters.getmore	GetMore operations per second.
	connections.current	Current connections.
	metrics.cursor.open.total	Total open cursors.
	metrics.cursor.timedOut	Total timed-out cursors.
	network.bytesIn	Network input in bytes per second.
	network.bytesOut	Network output in bytes per second.
	network.numRequests	Number of network requests per second.
MongoDB process metrics	cpu_usage	CPU utilization.
	mem_usage	Memory utilization.
	disk_usage	Disk utilization.

Table 4. Monitoring metrics for ApsaraDB RDS for PostgreSQL

Type	Parameter	Description
Host metrics	cpu_sys_ratio	Kernel-mode CPU utilization.
	cpu_user_ratio	User-mode CPU utilization.
	cpu_usage	CPU utilization.
	mem_usage	Memory usage.
	data.r_s	Read IOPS on the data disk.
	data.iops	IOPS on the data disk.
	data.w_s	Write IOPS on the data disk.
	local_fs_size_total	Total disk space.
	data.fs.used	Total used space on the data disk.
	data.fs.usage	Usage percentage of the data disk.
	network_out_io	Outbound network traffic.
	network_io	Total network traffic.
	network_in_io	Inbound network traffic.
PostgreSQL basic monitoring	waiting_connection	Number of waiting connections.
	idle_in_transaction	Number of sessions idle in a transaction.
	active_session	Number of active connections.
	total_session	Total number of connections.
	tup_inserted	Number of rows inserted per second.
	tup_deleted	Number of rows deleted per second.
	tup_updated	Number of rows updated per second.
	tup_returned	Number of rows returned by sequential scans per second.
	tup_fetched	Number of rows fetched by index scans per second.
	tps	Number of transactions per second (TPS).
	xact_rollback	Number of transactions rolled back per second.
	xact_commit	Number of transactions committed per second.
	deadlocks	Number of deadlocks per second.
	oldest_snapshot	The age of the oldest transaction snapshot. This determines the point from which old row versions can be cleaned up.
	max_sent_delay	Maximum send delay on the standby instance.
	max_replay_delay	Maximum replay delay on the standby instance.
	long_query_5s	Number of SQL statements running for 5 seconds or longer.
	long_query_1s	Number of SQL statements running for 1 second or longer.
	long_query_3s	Number of SQL statements running for 3 seconds or longer.
	long_idle_in_transaction_3s	Number of transactions idle for 3 seconds or longer.
	long_idle_in_transaction_5s	Number of transactions idle for 5 seconds or longer.
	long_idle_in_transaction_1s	Number of transactions idle for 1 second or longer.
	long_2pc_1s	Number of 2PC transactions running for 1 second or longer.
	long_2pc_5s	Number of 2PC transactions running for 5 seconds or longer.
	long_2pc_3s	Number of 2PC transactions running for 3 seconds or longer.

Table 5. ApsaraDB RDS for SQL Server monitoring metrics

Type	Parameter	Description
SQL Server service process	cpu_usage	The CPU utilization of the instance, as a percentage of the total OS CPU.
	db_io	The number of I/O operations per second (IOPS).
	db_io_read	The number of read I/O operations per second.
	db_io_write	The number of write I/O operations per second.
	other_size	The amount of space used by the system.
	log_size	The amount of space used by logs.
	tmp_size	The amount of temporary space used.
	ins_size	The total amount of space used by the instance.
	data_size	The amount of space used by data.
Database metrics	qps	The average number of SQL statements executed per second.
	connection_reset	The number of logins per second that reuse connections from the connection pool.
	active_temp_tables	The number of active temporary tables.
	active_session	The number of active user connections.
	active_cursors	The number of active cursors.
	sessions	The total number of connections.
	active_transactions	The number of active transactions.
	transactions	The average number of transactions per second.
	write_transactions	The average number of write transactions per second.
	read_kb	The average outbound network traffic of the instance, in KB per second.
	write_kb	The average inbound network traffic of the instance, in KB per second.
Basic metrics	cache_hit_ratio	The percentage of lookups that successfully find data in the cache.
	bufferpool	The percentage of data pages found in the buffer pool that did not require a disk read.
	fullscans	The average number of full table scans per second.
	autoparam_attempts_per_sec	The number of auto-parameterization attempts per second.
	forced_parameterizations_per_sec	The number of successful forced parameterizations per second.
	sql_compilations	The number of SQL compilations per second.
	unsafe_autoparams_per_sec	The number of unsafe auto-parameterization attempts per second.
	failed_autoparams_per_sec	The number of failed auto-parameterization attempts per second.
	safe_autoparams_per_sec	The number of safe auto-parameterization attempts per second.
	resqlcompilations	The number of statement recompilations per second.
	lazy_writes	The number of pages written to disk per second by the lazy writer process.
	checkpoint	The number of pages written to disk per second by checkpoints.
	logout	The number of user logouts per second.
	logins	The number of user logins per second.
	locktimeout	The number of lock requests per second that timed out, including requests for NOWAIT locks.
	deadlock	The number of deadlocks detected per second.
	lock_requests_per_sec	The number of new lock requests and lock conversions per second.
	lockwaits	The number of lock requests per second that required a wait.
	lock_waits	The number of threads currently waiting for a lock.
	latchwaits	The number of latch requests per second that required a wait.
	lock_wait_time_ms	The average wait time for lock requests, in milliseconds.
	average_latch_wait_time	The average wait time for latch requests, in milliseconds.
	table_lock_escalations_per_sec	The number of times per second that locks on a table were escalated to the TABLE or HoBT granularity.
	average_lock_wait_time	The average wait time for lock requests, in milliseconds.
	total_latch_wait_time	The total wait time for latches in the last second, in milliseconds.

Table 6. PolarDB for MySQL monitoring metrics

Parameter type	Parameter	Description
Database metrics	com_delete	The average number of DELETE statements executed per second.
	com_insert	The average number of INSERT statements executed per second.
	com_replace	The average number of REPLACE statements executed per second.
	com_select	The average number of SELECT statements executed per second.
	com_update	The average number of UPDATE statements executed per second.
	QPS	Queries per second (QPS).
	TPS	Transactions per second (TPS).
PolarDB service process	cpu_usage	The percentage of CPU used by the service process. A value of 200% indicates that two CPU cores are fully utilized.
PolarDB service process	mem_usage	The percentage of total OS memory used by the instance.
PolarDB server	active_session	The number of active sessions.
	total_session	The total number of sessions.
	output_traffic	The amount of data sent to all clients, in bytes per second.
	input_traffic	The amount of data received from all clients, in bytes per second.
InnoDB storage engine	innodb_data_read	The average number of bytes InnoDB reads per second.
	innodb_data_written	The average number of bytes InnoDB writes per second.
	innodb_buffer_dirty_ratio	The ratio of dirty pages to total pages in the InnoDB Buffer Pool.
	innodb_buffer_read_hit	The cache hit rate for reads in the InnoDB Buffer Pool.
	innodb_buffer_use_ratio	The percentage of the InnoDB Buffer Pool in use.
	innodb_rows_deleted	The average number of rows InnoDB deletes per second.
	innodb_rows_inserted	The average number of rows InnoDB inserts per second.
	innodb_rows_read	The average number of rows InnoDB reads per second.
	innodb_rows_updated	The average number of rows InnoDB updates per second.

Note

Alternatively, click the icon next to a metric on the monitoring dashboard to view its definition.