25 Nov

How to solve the audit data explosion in the Alfresco database

It’s a long time that I have contacts from the Alfresco community with a similar question like the one described below.

After some time the audit trail is enabled in my Alfresco instance, the database dimension explodes. Is the audit trail connected in some way with the data explosion? How can I solve it?

Most of the times this question is connected to the A.A.A.R. analytics that is able to collect (and analyze) audit data together with repository data and workflow data. The bad news is that this issue is completely true. Of course if you request to track every action/event, you cannot avoid to store a lot amount of data. The good news is that there are some ways to solve this problem, directly with the bundled services in Alfresco.

In this post I would like to share a way to solve the problem, deleting the “old” actions audited in a very simple manner. Read More