Help Center/ GaussDB(for MySQL)/ User Guide/ Monitoring and Alarms/ Configuring Monitoring by Seconds
Updated on 2024-11-06 GMT+08:00
View PDF
Share

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

GaussDB(for MySQL) provides monitoring every 60 seconds for free, but you are billed for Monitoring by Seconds. Its pricing is listed on a per-hour basis, but bills are calculated based on the actual usage duration.
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 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 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, click Advanced O&M > Real-Time Monitoring to view 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 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.
  2. In the navigation pane, choose DBA Assistant > Real-Time Diagnosis.
  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.
  2. In the navigation pane, choose DBA Assistant > Real-Time Diagnosis.
  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

APIs

Parent Topic: Monitoring and Alarms