Overview

OceanBase Database provides the plan management feature for you to prepare and implement a series of plans for possible database emergencies and crises. This feature enhances your response to emergencies and crises, reduces losses, and ensures database operation stability, thereby mitigating the impact of potential risks on your business and improving the overall response performance of OceanBase Database.

The plan management feature consists of the Plan and Plans tabs.

Prerequisites

To view plans and plan execution information, make sure that you have the following permissions:

• Resource Permissions : Cluster Read-only or Tenant Read-only permission
• Menu Permissions : Permission on the Plan Management menu of O&M Management

The Plan tab

OCP provides more than 10 types of plans for different scenarios, such as automatically reloading the observer process, increasing the CPU and memory resources of a tenant, and flushing the plan cache for an SQL statement. You can create a custom plan based on the business scenario and resource usage. For example, you can create a custom resource increasing plan and specify whether to enable the plan.

On the Plan tab, you can view the details about a plan in the following columns: Plan Name , Plan Type , Object Type , Object , Automatic Execution , Type , Created At , Changed At , Created By , and Status .

• You can also unfold a plan to view its trigger rules. If you unfold a plan about increasing the CPU or memory resources of a tenant or increasing the maximum number of connections to an OBProxy, you can view the increment factor and maximum server memory usage.
• You can enter a plan name in the search box to perform a fuzzy search.
• You can filter plans by Object Type , Automatic Execution , Type , or Status .
• You can sort plans by Created At or Changed At .
• You can perform routine management operations on plans. For example, you can create, enable, disable, edit, and delete a plan. For more information, see Manage plans.

The Plans tab

This tab provides plan execution information and corresponding SQL details, and allows you to manually execute a plan whose automatic execution is disabled. This way, you can establish an emergency management mechanism and O&M specifications for OceanBase Database, ensuring business continuity and stability in an intelligent manner.

On the Plans tab, you can view detailed execution information about plans in the following columns: Plan Type , Object , Event Type , Event Name , Execution Period , and Status .

• You can unfold a row to view information such as the plan name, increment factor, and maximum server memory usage.
• You can enter the object name in the search box to perform a precise search.
• You can sort plans by Execution Period .
• You can perform different O&M operations on emergency plans based on the plan status. For more information, see View plan execution details.

Plan types

The following table describes plan types and their corresponding trigger rules and object types.