Actions
Feature #10786
closedCavalcade job and log cleanup
Status:
Resolved
Priority name:
Normal
Assignee:
Category name:
Cavalcade
Target version:
Start date:
2018-12-05
Due date:
% Done:
0%
Estimated time:
Deployment actions:
Description
The cavalcade MySQL tables get very large over time, which I think contributes somewhat to performance issues. They can use periodic cleanup.
1. wp_cavalcade_logs should be purged occasionally. There's no reason to have hot storage of more than a few weeks' worth of logs. I'm currently doing it manually every couple weeks (export table, then delete everything except the last few weeks).
2. wp_cavalcade_jobs collects many jobs in the 'completed' or 'failed' status. There's generally no reason to keep these (except for debugging) and we should delete them on at least a weekly basis. https://github.com/humanmade/Cavalcade/issues/72
These tasks are easily performed via wp cli, which we could then rig up to a cron job.
Files
Actions