Viewing Metrics

Viewing Real-Time 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. In the navigation pane, choose Metrics.
5. View the real-time performance metrics of a created GaussDB(for MySQL) instance under the current account.
   Figure 1 Viewing real-time metrics
   

   Table 1 Parameter description

   Parameter	Description
   Node Name/ID	Only monitoring data for the nodes of a created GaussDB(for MySQL) instance is displayed.
   Status	The value can be: Normal: Real-time monitoring data is displayed. NOTE: The monitoring data and charts are available for a new instance after the instance runs for about 10 minutes. Abnormal: There is no monitoring data. The default values for all metrics are 0. The monitoring data is available only after the instance becomes normal. Stopped: There is no monitoring data. The default values for all metrics are 0. The monitoring data is available only after the instance is started.
   Node Type	The value can be: Primary Replica
   Availability Zone	AZ where a node is located
   Private IP Address	Private IP address of a node
   Failover Priority	Failover priority of a node
   Metrics	For details about metric description and handling suggestions for abnormal metrics, see Table 2. The following metrics are available: CPU Usage Memory Usage TPS QPS

   Table 2 Monitoring items

   Item	Description	Handling Suggestion	Reference
   CPU Usage	CPU usage of the monitored object	Evaluate the SQL execution plan and add indexes to avoid full table scanning. Upgrade vCPUs for compute-intensive workloads.	What Should I Do If the CPU Usage of My GaussDB(for MySQL) Instance Is High?
   Memory Usage	Memory usage of the monitored object	Upgrade instance specifications. Optimize SQL statements to reduce the use of temporary tables. Reconnect sessions at a specific interval to release memory of the sessions.	How Do I Handle a Large Number of Temporary Tables Being Generated for Long Transactions and High Memory Usage?
   TPS	Execution times of submitted and rollback transactions per second	Evaluate the SQL execution plan and add indexes to avoid full table scanning. Upgrade vCPUs for compute-intensive workloads.	What Should I Do If the CPU Usage of My GaussDB(for MySQL) Instance Is High?
   QPS	Query times of SQL statements (including stored procedures) per second

Viewing Historical Metrics

Select one or more nodes in the real-time metric list and then view their historical metrics in the Historical Metrics area.

Figure 2 Viewing historical metrics