Good Day Everyone,
We have a large Matomo presence and are having issues with the delete-logs-data never completing when it is scheduled to run via Crontab.
Database size is currently over 400GB. We are trying to run the following to delete 30 days of old log data and it will run for an entire week and never finish.
example: “console core:delete-logs-data --no-interaction --dates=2021-01-01,2021-02-01”
We average around 6 million page views a day hitting this system. We are currently running version 4.2.1 and we see a ticket that may help this with 4.3.1 and plan to update sometime this week.
Wondering if anyone else has been having similar issues or have an idea of a work around to help get the old data cleaned up? We have about 18 months of data today and are thinking the delete maybe has never worked properly? So may have 18 months of log data?