Viewing TaurusDB Metrics

Scenarios

Cloud Eye monitors TaurusDB running statuses. You can view TaurusDB metrics 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 for problematic SQL statements to optimize them.

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.
To view metrics of a proxy instance, ensure that read/write splitting has been enabled for the DB instance. For details, see Creating a Proxy Instance for Read/Write Splitting.

Viewing Metrics

Log in to the TaurusDB console.
Click in the upper left corner and select a region and project.
On the Instances page, locate a 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.
On the displayed page, view the DB instance metrics.
- Click Select Metric in the upper right corner. In the displayed dialog box, select the metrics you want to display.
- You can sort graphs by dragging them.
- Cloud Eye can monitor performance metrics in the last 15 minutes, 30 minutes, 1 hour, 3 hours, 12 hours, 24 hours, 7 days, 30 days, or 6 months (155 days).

Log in to the TaurusDB console.
Click in the upper left corner and select a region and project.
On the Instances page, click the instance name.
Choose Database Proxy in the navigation pane, locate a proxy instance, and click View Metrics in the Operation column.
On the displayed page, view the proxy instance metrics.
- Click Select Metric in the upper right corner. In the displayed dialog box, select the metrics you want to display.
- You can sort graphs by dragging them.
- Cloud Eye can monitor performance metrics in the last 15 minutes, 30 minutes, 1 hour, 3 hours, 12 hours, 24 hours, 7 days, 30 days, or 6 months (155 days).

Viewing Real-Time Metrics

Log in to the TaurusDB console.
Click in the upper left corner and select a region and project.
On the Instances page, click the instance name.
In the navigation pane, choose Advanced O&M.
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.