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 restored to be 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.

  The monitoring data and graphics are available for a new DB instance after the DB instance runs for a period of time.

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 target DB instance and click View Metric in the Operation column.

   Alternatively, click the DB instance name to go to the Basic Information page. Click View Metric in the upper right corner of the page.

   To view metrics of a node, locate the target node in the Node List area on the Basic Information page and click View Metric in the Operation column.

5. On the dispayed 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 Instance Monitoring 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.