• Relational Database Service

rds
  1. Help Center
  2. Relational Database Service
  3. User Guide
  4. Monitoring DB Instances
  5. Monitoring DB Instances Using Cloud Eye
  6. Configuring Displayed Metrics

Configuring Displayed Metrics

Scenarios

This section describes how to use Cloud Eye to monitor the operating status of the system.

By monitoring system resource usage when the database is running, you can identify periods of high resource usage. To optimize database performance, you can analyze which SQL statements may have had performance issues by checking the following logs:

  • MySQL database slow query logs
  • PostgreSQL database error logs
  • Microsoft SQL Server database logs
NOTE:

You can configure resource alarm rules on the Cloud Eye console. For details, see the "Alarm Rule Management" section in the Cloud Eye User Guide.

Procedure

  1. On the Instance Management page, locate the target DB instance or read replica, and choose More > View Metric in the Operation column.
  2. On the Cloud Eye console, view monitoring information of the DB instance. On the Cloud Eye console, click the target RDS DB instance name and click Select Metric in the upper right corner. In the displayed dialog box, you can select the metrics to be displayed and sort them by dragging them at desired locations.

    Cloud Eye can monitor performance metrics from the last 1 hour, last 3 hours, last 12 hours, last 24 hours, last 7 days, and last 30 days.

    DB instance monitoring includes ECS and database performance metrics.

    • Table 1 lists details about ECS monitoring metrics.
      Table 1 ECS monitoring metrics

      Metric

      Description

      Value Range

      CPU Usage

      Measures the CPU usage (%) of the monitored object.

      0% to 100%

      IOPS

      Measures the average rate at which I/O requests are processed during a specified period.

      ≥ 0 counts/s

      Storage Space Usage

      Measures the storage space usage (%) of the monitored object.

      0% to 100%

      Memory Usage

      Measures the memory usage (%) of the monitored object.

      0% to 100%

      Network Input Throughput

      Measures the rate at which all incoming traffic passes through the network adapter.

      ≥ 0 bytes/s

      Network Output Throughput

      Measures the rate at which all outgoing traffic passes through the network adapter.

      ≥ 0 bytes/s

      Disk Read Throughput

      Measures the rate at which data is read from a disk.

      ≥ 0 bytes/s

      Disk Write Throughput

      Measures the rate at which data is written to a disk.

      ≥ 0 bytes/s

      Average Time per Disk Read

      Measures the time required for reading 1 KB disk data.

      > 0s

      Average Time per Disk Write

      Measures the time required for writing 1 KB data to a disk.

      > 0s

      Total Disk Size

      Measures the total disk size of the monitored object.

      40–4,000 GB

      Storage Space Used

      Measures the amount of used storage space size of the monitored object.

      0–4,000 GB

      Average Disk Queue Length

      Measures the number of processes waiting to be written to the monitored object.

      ≥ 0

    • Database metrics:

      For details on MySQL metrics, see section Viewing Monitoring Metrics.

      For details on PostgreSQL metrics, see section Viewing Monitoring Metrics.

      For details on Microsoft SQL Server metrics, see section Viewing Monitoring Metrics.