During system operation, to fine-tune the execution plans of SQL, one can actively bind execution plans or indexes to guide the SQL engine to follow a better execution plan. Additionally, to address emergencies, some temporary optimization measures might be adopted, such as binding execution plans, binding indexes, and implementing throttling. This topic explains how to view active outlines within an OceanBase cluster, how to unbind execution plans and indexes, and how to cancel throttling.
View active outlines
Log in to the OceanBase Cloud console.
In the left-side navigation pane, click Instances.
In the instance list, find the target instance, click the instance name, and go to the Overview page of the instance.
Click Diagnostics in the left-side navigation pane, and then select the Real-Time Diagnostics tab on the Diagnostics page.
On the SQL tab, click View Optimization Records. The system displays the Active Outlines tab by default.
On the Active Outlines tab, view the currently active outlines.
Note
The SQL statements bound by the Aggregation In Query feature will be aggregated and displayed as one entry.
Unbind execution plans
On the Active Outlines tab, view the outlines that have bound execution plans.
Proceed to unbind the execution plans.
For individual operations: Find the target outline, and click Unbind Outline in the Actions column.
For batch operations: Find the outlines marked with Aggregated, and click Unbind Outline in the Actions column.
In the pop-up confirmation box, click OK.
Unbind indexes
On the Active Outlines tab, view the outlines that have bound indexes.
Proceed to unbind the indexes.
For individual operations: Find the target outline, and click Unbind Outline in the Actions column.
For batch operations: Find the outlines marked with Aggregated, and click Unbind Outline in the Actions column.
In the pop-up confirmation box, click OK.
Cancel throttling
On the Active Outlines tab, view the outlines that have been throttled.
Proceed to cancel throttling.
For individual operations: Find the target outline, and click Cancel Throttling in the Actions column.
For batch operations: Find the outlines marked with Aggregated, and click Cancel Throttling in the Actions column.
In the pop-up confirmation box, click OK.