Help Center/ GaussDB(for MySQL)/ User Guide/ Metrics and Alarms/ Configuring Monitoring by Seconds
Updated on 2023-10-18 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.

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 Database > 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 Advanced O&M.
  6. On the displayed page, click the Real-Time Monitoring tab and click next to Monitoring by Seconds.
  7. In the displayed dialog box, select a collection period and click OK.

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

    Figure 1 Enabling monitoring by seconds

  8. View monitoring metrics. 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.

    To change the collection period, click Modify Collection Period next to Monitoring by Seconds.

    Figure 2 Viewing monitoring metrics

Disabling 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 Database > 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 Advanced O&M.
  6. On the displayed page, click the Real-Time Monitoring tab and click next to Monitoring by Seconds.
  7. In the displayed dialog box, click Yes.

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

    Figure 3 Disabling monitoring by seconds

Modifying Collection Period

  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 Database > 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 Advanced O&M.
  6. On the displayed page, click the Real-Time Monitoring tab and click Modify Collection Period next to Monitoring by Seconds.
  7. In the displayed dialog box, select a collection period and click Yes.

    Figure 4 Modifying the collection period