I keep having archive processes that run for a long time (sometimes hundreds of hours) before I finally have to kill them or restart the server.
At the moment, I have three archive processes running:
siteid 2, yearly for 2021-01-01, running for 15 hours
siteid 1, yearly for 2020-01-01, running for 13 hours
siteid 2, monthly for 2020-12-01, running for 5 minutes
What should I do to diagnose this issue?
- Never deleting old raw data
- Never deleting old aggregated report data
- Cron archive once per hour
- cli memory_limit => -1
FWIW site 1 gets 500k pageviews / year, and site 2 gets 2.5 million pageviews / year.