Overview¶
Intelligent O&M helps GaussDB(DWS) users with O&M tasks. With this feature, you can specify the proper time window and number of tasks to execute based on the cluster workload. Besides, Intelligent O&M can adjust task execution policies according to service changes in a timely manner to reduce the impact on services. Periodic tasks and one-off tasks are supported, and you can configure the time window as required.
Intelligent O&M ensures high availability. When the cluster is abnormal, failed O&M tasks will be retried. If some steps of an O&M task cannot be completed due to an abnormal cluster, the failed steps will be skipped for cost saving.
As shown in the figure below, the Intelligent O&M page consists of the following parts:
Common configuration of O&M tasks: Currently, you can only configure Maximum number of concurrent O&M tasks in the VacuumFull user table. This configuration takes effect on all the VACUUM FULL tasks of user tables.
Information about ongoing O&M tasks. (Currently, only VACUUM tasks are displayed. If disk space is insufficient because of table bloating, you can vacuum tables.).
Frequent table creation and deletion can lead to table bloating. To free up space, you can run the VACUUM command on system catalogs.
Frequently update and delete operations can lead to table bloating. To free up space, you can run the VACUUM or VACUUM FULL command on system catalogs.
O&M details: O&M Plan and O&M Status. O&M Plan displays the basic information about all O&M tasks, and O&M Status displays the running status.
Note
This feature is supported only in 8.1.3 or later.
The intelligent O&M function is not supported in hybrid data warehouses (standalone mode).
Only clusters of version 8.1.3 and later allow common settings for O&M tasks. Ensure that the agent has been upgraded to version 8.2.0 or later.