Updated on 2024-09-24 GMT+08:00

Viewing Real-Time Performance Metrics

GaussDB(for MySQL) allows you to view performance metrics and trends of DB instances in real time, helping you detect and handle potential performance problems in a timely manner.

Procedure

  1. Log in to the management console.
  2. Click in the upper left corner and select a region and project.
  3. Click in the upper left corner of the page and choose Databases > GaussDB(for MySQL).
  4. On the Instances page, click the instance name.
  5. In the navigation pane, choose DBA Assistant > Real-Time Diagnosis.
  6. Click the Performance tab to view the performance metrics of your DB instance.

    • If you select Comparison by Date, you can view performance metric trends of the DB instance in a time range on different days by specifying dates and a time range. You can move the cursor to a point in time of a chart to view the performance metric at the point in time on different days.
      Figure 1 Viewing a performance metric at a point in time on different days
    • If you deselect Comparison by Date, you can view performance metric trends in the last 30 minutes, last hour, last 6 hours, or a custom time range. You can move the cursor to a point in time of a chart to view the performance metric at the point in time.
      Figure 2 Viewing a performance metric trend in the last 30 minutes
    • You can also click Create Alarm Rule to set GaussDB(for MySQL) alarm rules. This will allow you to stay informed about the status of your GaussDB(for MySQL) instance and receive timely warnings.
    • By default, the Performance page monitors performance data every minute. You can click Enable Monitoring by Seconds to configure linked charts and enable monitoring by seconds.

      Linked Charts: Enabling it means that you can view all metrics at the same time.

      Monitoring by Seconds: Enabling it means that the system reports monitoring data precise to the second or to 5 second intervals. This function is billed and the pricing is listed on a per-hour basis.

      Figure 3 Enabling monitoring by seconds