As Apache DolphinScheduler runs for an extended period, the number of tasks continues to increase, leading to system page lag due to growing data in the t_ds_task_instance and t_ds_process_instance tables.
To address system performance issues, it is crucial to regularly clean up data older than one month from the t_ds_process_instance and t_ds_task_instance tables.
Before performing data cleanup, backing up the original tables is essential to ensure data safety, allowing for recovery if needed after cleanup.
After confirming a successful backup with matching row counts, the cleanup process involves deleting outdated data from the processed and task instance tables.
Collection
[
|
...
]