Function Overview

Procedure

On the Overview page, click Go to Intelligent O&M.

**Table 1** Function description
No.	Function	Description
1	Intelligent O&M	Allows you to monitor, diagnose, and tune databases.
2	Instance Overview	Displays metrics of DB instances in real time. You can specify which metrics to display.
3	Fuzzy Search	Allows you to view DB instances by DB engine, instance name, or IP address.

In the Instance Overview area, click Set Displayed Metrics to specify the performance metrics to display.

**Table 2** Performance metrics
Metric	Description
QPS	Queries per second
TPS	Transactions per second
mem_usage	Instance memory usage (ratio of instance memory to OS memory)
cpu_usage	Service process CPU usage (200% indicates two vCPU cores are occupied)
connection_total_count	Total connections
connection_active_count	Active connections
com_select_count	SELECT statement executions per second
com_update_count	UPDATE statement executions per second
com_insert_count	INSERT statement executions per second
com_delete_count	DELETE statement executions per second
com_replace_count	REPLACE statement executions per second
innodb_rows_deleted	Rows deleted from an InnoDB table per second
innodb_rows_read	Rows read from an InnoDB table per second
innodb_rows_inserted	Rows inserted into an InnoDB table per second
innodb_rows_updated	Rows updated in an InnoDB table per second
bytes_received	Bytes received from all clients per second
bytes_sent	Bytes sent to all clients per second
innodb_data_read	Read bytes per second in an InnoDB buffer
innodb_data_written	Write bytes per second in an InnoDB table
innodb_buffer_pool_read_requests	Times that InnoDB reads pages (logical read) from a buffer pool per second
innodb_buffer_pool_write_requests	Times that InnoDB writes data to a buffer pool per second
innodb_buf_hit	InnoDB read cache hit ratio
innodb_buf_dirty	Dirty page ratio of the InnoDB buffer pool
innodb_buf_usage	Usage of the InnoDB buffer pool
created_tmp_disk_tables	Temporary tables automatically created on hard disks when a SQL statement is executed
avg_disk_ms_per_read	Average time required for each disk read
avg_disk_ms_per_write	Average time required for each disk write
disk_read_throughput	Disk read bytes per second
disk_write_throughput	Disk write bytes per second
disk_size	disk_total_size: Total disk space disk_used_size: Used disk space
innodb_log_writes_requests	Writes to the redo log file per second
innodb_log_writes	Physical writes to the redo log file per second
innodb_os_log_fsyncs	fsync() writes on InnoDB log files per second
IOPS	I/O requests processed per second