Viewing DB Instance Metrics

Scenarios

Cloud Eye monitors status of your DB instances. You can view the metrics of DB instances on the management console. With these metrics, you can identify periods of high resource usage. You can also check error logs or slow query logs to optimize database performance.

Prerequisites

• DB instances are running properly.

  Metrics of the DB instances that are faulty or have been deleted cannot be displayed on the Cloud Eye console, but you can view them after the DB instances are rebooted or become available.

If a DB instance has been faulty for 24 hours, Cloud Eye assumes that the instance no longer exists and deletes it from the monitoring object list. You need to manually clear the alarm rules created for the instance.

• DB instances have kept running properly for about 10 minutes.

  For a newly created DB instance, you need to wait for a while before viewing its metrics.

Viewing DB Instance Metrics

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, locate the DB instance and click View Metrics in the Operation column.

   Alternatively, click the instance name to go to the Basic Information page. In the upper right corner of the page, click and choose View Metric.

   Figure 1 Viewing metrics on the Basic Information page
   

   To view metrics of a node, locate the node in the Node List area and click View Metrics in the Operation column.

5. On the displayed Cloud Eye page, view metrics.

   You can view the performance metrics in the last 1 hour, last 3 hours, last 12 hours, last 1 day, or last 7 days.

Viewing Real-Time DB Instance Metrics

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, choose Databases > GaussDB(for MySQL).
4. On the Instances page, click the instance name.
5. In the navigation pane, choose Advanced O&M.
6. Under Real-Time Monitoring, view real-time monitoring data such as CPU usage, memory usage, SELECT statements per second, DELETE statements per second, and INSERT statements per second.

   You can also click View details to view more metrics on the Cloud Eye console.