Overview of Scheduled Tasks

Background information

In an increasingly complex database operating environment, OceanBase Database ensures system stability by periodically initiating major compactions and collecting statistics within specific time windows. However, the database is constantly evolving—for example, continuous minor compactions by tenants or frequent DML operations on tables continuously update statistics. In some extreme scenarios, due to the characteristics of the LSM tree architecture, if data updates are not promptly detected, significant "read amplification" effects may occur. Outdated statistics can severely impair the query optimizer's ability to accurately evaluate execution plans, ultimately leading to increased overall database response latency. All these behaviors pose threats to business continuity. Additionally, routine business operations such as downtime and restarts can also impact business operations.

To address this challenge, OCP introduces the scheduled task management feature. This feature leverages an intelligent scheduling engine to enhance the automation level of O&M operations. You can flexibly configure execution strategies for various critical tasks based on business operation patterns, including tenant major compaction, post-major-compaction statistics collection, and table-level statistics collection. You can also set scheduling strategies and expiration strategies based on business patterns, aligning O&M timing more closely with business rhythms. Furthermore, OCP provides comprehensive full-lifecycle task management capabilities, allowing you to easily enable or disable scheduled tasks, support forced execution, parameter editing, task copying, and deletion, and view detailed task execution records at any time. Through automated scheduling and intelligent optimization, OCP scheduled tasks ensure stable and efficient system operation, helping users build a smarter, more adaptive new O&M paradigm.

Features

The scheduled tasks module in OCP provides automated scheduling capabilities for O&M operations, supporting:

• Task execution: Automatically execute critical O&M tasks such as tenant major compaction and table-level statistics collection according to a specified schedule.
• Configuration management: Supports full-lifecycle management operations for tasks, including viewing, editing, copying, deleting, enabling/disabling, etc.
• Event response: Flexibly adjust task execution strategies based on business needs to ensure O&M operations do not affect business peak periods.

Procedure

1. Create a scheduled task, and the system will automatically execute the task according to your defined scheduling strategy.
2. Manage scheduled tasks, supporting daily management operations for tasks such as forced execution, disabling/enabling, editing, copying, and deleting.
3. View task details, to view information about created scheduled tasks and their execution records.