Cluster CPU utilization exceeds the threshold

Check whether the load is normal for the application.

1. Log on to the ApsaraDB for OceanBase console. Click the target cluster name on the Clusters list to go to the Cluster Workspace page.

2. Click Tenant Management, and then click the target tenant to go to the Tenant Workspace page.

3. On the Performance Monitoring page of the tenant workspace, view the CPU Utilization curve and check whether the CPU utilization at the alert time was an abrupt increase compared with the CPU utilization in the past one to seven days.

   • If yes, the CPU load was abnormal.

   • Otherwise, the high CPU load was caused by normal access traffic. In this case, consider scaling out the tenant.

     

If the high CPU utilization was caused by querying a large amount of data or hotspot traffic, perform the following steps based on the actual scenarios.

• Large SQL queries were executed. In this case, click the TopSQL tab on the Diagnosis page, and then check whether SQL queries with high CPU utilization exist.

  • If yes, optimize the SQL queries that caused high CPU utilization.

  • Otherwise, high CPU utilization was not caused by large SQL queries.

    

• The high CPU utilization was caused by slow SQL queries. In this case, click the SlowSQL tab on the Diagnosis page, and then check the diagnosis result for slow SQL queries. Optimize the slow SQL queries that you found.

• Enable throttling on the Diagnosis page for problematic SQL statements.