Function Overview

Procedure

1. On the DAS console, click Intelligent O&M to go to the instance overview page of Intelligent O&M.
2. In the Instance Overview area, click Set Displayed Metrics to specify the performance metrics to display.
   Figure 1 Set Displayed Metrics
   

   Table 1 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	Number of SELECT statement executions per second
   com_update_count	Number of UPDATE statement executions per second
   com_insert_count	Number of INSERT statement executions per second
   com_delete_count	Number of DELETE statement executions per second
   com_replace_count	Number of REPLACE statement executions per second
   innodb_rows_deleted	Number of rows deleted from an InnoDB table per second
   innodb_rows_read	Number of rows read from an InnoDB table per second
   innodb_rows_inserted	Number of rows inserted into an InnoDB table per second
   innodb_rows_updated	Number of rows updated in an InnoDB table per second
   bytes_received	Number of bytes received from all clients per second
   bytes_sent	Number of bytes sent to all clients per second
   innodb_data_read	Number of read bytes per second in an InnoDB buffer
   innodb_data_written	Number of write bytes per second in an InnoDB buffer
   innodb_buffer_pool_read_requests	Number of times that InnoDB reads pages (logical read) from a buffer pool per second
   innodb_buffer_pool_write_requests	Number of 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	Number of temporary tables automatically created on hard disks when SQL statements are 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	Number of disk read bytes per second
   disk_write_throughput	Number of disk write bytes per second
   disk_size	disk_total_size: Total disk space disk_used_size: Used disk space
   innodb_log_writes_requests	Number of writes to the redo log file per second
   innodb_log_writes	Number of physical writes to the redo log file per second
   innodb_os_log_fsyncs	Number of fsync() writes on InnoDB log files per second
   IOPS	Number of I/O requests processed per second

3. After specifying the metrics, click OK.
4. Click Details of an instance to go to the Intelligent O&M details page.