search

aegif / CmisSync

Synchronize content between a CMIS repository and your desktop. Like Dropbox for Enterprise Content Management!
http://CmisSync.com
164 stars 123 forks source link

Huge audit entries in alfresco "alf_audit_entry" table while syncing #754

Open sumitt opened 7 years ago

sumitt commented 7 years ago

There are around more then 100,000 audit logs entered in alfresco "alf_audit_entry" table in last 12 hrs. Each sync creates hundred of logs while there is no updation in the repository. This makes data directory heavy and slow the audit trail extractions.

Any idea to control this please.

Thanks Sumit

nicolas-raoul commented 7 years ago

Hi Sumit,

Is Alfresco using ChangeLog?

https://github.com/aegif/CmisSync/wiki/Improving-performance

sumitt commented 7 years ago

Hi,

Yes, Alfresco is using ChangeLog. But audit records increase very fast in "alf_audit_entry" table without any updation in content repository. - PFA(No. of records goes to 138622-138850-139020 at 5 sec. sync interval)

Thanks audit

nicolas-raoul commented 7 years ago

If ChangeLog is used and no update happens, then audit data does not grow because of CmisSync. CmisSync just performs one ChangeLog checks every 5 seconds in such case, so no impact on audit data. You can confirm the requests with Wireshark.

nicolas-raoul commented 6 years ago

Please post here a few of the audit entries, so that we know exactly what CmisSync operations are causing them. Thanks!