Help Center> GaussDB(for MySQL)> User Guide> Metrics and Alarms> Configuring Monitoring by Seconds
Updated on 2024-05-21 GMT+08:00

Configuring Monitoring by Seconds

GaussDB(for MySQL) supports Monitoring by Seconds. You can set the monitoring interval to 1 second or 5 seconds to view the metric values.

Billing

Pricing is listed on a per-hour basis, but bills are calculated based on the actual usage duration. GaussDB(for MySQL) provides monitoring every 60 seconds for free.
Table 1 Price details

Region

Monitoring Interval

Pay-per-Use (USD/Hour)

CN East-Shanghai1, CN North-Beijing4, CN South-Guangzhou, CN Southwest-Guiyang1, CN North-Ulanqab1, and CN South-Guangzhou-InvitationOnly

1s

0.024

5s

0.012

AP-Singapore, AP-Jakarta, RU-Moscow2, CN-Hong Kong, AP-Bangkok, and TR-Istanbul

1s

0.032

5s

0.016

LA-Sao Paulo1

1s

0.054

5s

0.027

Enabling Monitoring by Seconds

  1. Log in to the management console.
  2. Click in the upper left corner and select a region and a project.
  3. Click in the upper left corner of the page, choose Databases > GaussDB(for MySQL).
  4. On the Instances page, click the instance name to go to the Basic Information page.
  5. In the navigation pane on the left, choose DBA Assistant > Real-Time Diagnosis. The Dashboard page is displayed.
  6. Click Performance.
  7. In the upper part of the page, click Enable Monitoring by Seconds.
  8. In the displayed dialog box, click next to Monitoring by Seconds, select a collection interval, and click OK.

    After you enable this function, monitoring data will be reported and displayed by the second after about five minutes.

  9. In the navigation pane on the left, click Advanced O&M > Real-Time Monitoring to view the monitoring metric data.

    • View the current data collection period in the upper part of the page.
    • Monitoring by Seconds supports the following metrics: CPU usage, memory usage, SELECT statements per second, DELETE statements per second, and INSERT statements per second. You can click View details to view more metrics. For details about the metrics, see Introducing GaussDB(for MySQL) Metrics.
    • If you need to change the collection period, see Modifying Collection Interval.

Disabling Monitoring by Seconds

  1. On the Instances page, click the instance name to go to the Basic Information page.
  2. In the navigation pane on the left, choose DBA Assistant > Real-Time Diagnosis. The Dashboard page is displayed.
  3. Click Performance.
  4. In the upper part of the page, click Enable Monitoring by Seconds.
  5. In the displayed dialog box, click next to Monitoring by Seconds and click OK.

    After you disable this function, monitoring data will be reported and displayed by the minute after about five minutes.

Modifying Collection Interval

  1. On the Instances page, click the instance name to go to the Basic Information page.
  2. In the navigation pane on the left, choose DBA Assistant > Real-Time Diagnosis. The Dashboard page is displayed.
  3. Click Performance.
  4. In the upper part of the page, click Enable Monitoring by Seconds.
  5. Select the monitoring interval and click OK.

    Monitoring data will be reported based on the new collection interval about 5 minutes later.
    Figure 1 Modifying the collection interval