Updated on 2024-11-06 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 metric trends of the DB instance in a time range on different dates. You can move the cursor to a point in time of a chart to view metric values at the point in time on different dates.
      Figure 1 Viewing a performance metric at a point in time on different dates
    • 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 metric value 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 alarm rules for your DB instance. This will allow you to stay informed about the status of your DB instance and receive timely warnings.
    • The system monitors performance data every minute by default. You can click Enable Monitoring by Seconds on the Performance tab 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