Using oozie.service.PurgeService.* settings, oozie should clean out old data. This will help prune the WF_JOBS table which is now almost 40GB.
We should set oozie.service.PurgeService.purge.old.coord.action to true, and audit the other setting's default values (we probably want to keep completed workflow jobs around for more than 30 days).
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Resolved | Ottomata | T127991 Create regular backups of Analytics MySQL Meta instance | |||
| Resolved | Ottomata | T127988 Enable purging of old jobs and coordinators in oozie |
Change 274827 had a related patch set uploaded (by Ottomata):
Set oozie.service.PurgeService.purge.old.coord.action to true
Change 274827 merged by Ottomata:
Set oozie.service.PurgeService.purge.old.coord.action to true and parameterize purge_jobs_older_than_days
Change 274829 had a related patch set uploaded (by Ottomata):
Update cdh submodule with oozie purge change