Help Center > > User Guide> Intelligent O&M> Intelligent O&M for RDS for MySQL and GaussDB(for MySQL) DB Instances> Function Overview

Function Overview

Updated at: Jun 09, 2021 GMT+08:00

Procedure

  1. On the DAS console, choose Intelligent O&M to go to the instance overview page of Intelligent O&M.

    Figure 1 Instance overview page of Intelligent O&M
    Table 1 Functions

    No.

    Function

    Description

    1

    Intelligent O&M

    Allows you to monitor, diagnose, and tune databases.

    2

    Instance Overview

    Displays the real-time metrics of DB instances. You can specify which metrics to display.

    3

    Fuzzy Search

    Allows you to view the performance of DB instances by DB engine, instance name, or IP address.

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

    Figure 2 Set Displayed Metrics
    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 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.

    Figure 3 Instance Overview

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel