...
When actively manipulating the data in the database the "Changes Log" in particular can be very large (one record created for every user action).
Solution
- add "SessionLogRotationInterval" system setting (label: "Keep "Session Log" for" system setting ) to the "Logs Settings" sub-section in the "Configuration > Website > Advanced" section with following options: "1 day", "1 week", "2 weeks", "1 month", "3 months", "1 year", "2 years", "3 years", "5 years", "Forever (never deleted automatically)"
- create "session-log:OnRotate" scheduled task (see "email-log:OnRotate" for example) to cleanup logs
- don't session logs of active sessions
- before deleting "session log" delete all "changes log" records associated with that "session log"
- add protection against removing more than 100 records per run (to avoid "out of memory" error)
- run event once per day
Related Tasks
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|