How to clean the OKM_ACTIVITY table in OpenKM

27.11.2020

Last modified: 27.11.2020
estimated reading time < 1 min
It is assumed that openkm uses MariaDB as Database-Backend.

to clean the “Activity Table” which can get really huge,  the easiest option is to use phpmyadmin.

choose the database okmdb
choose the table OKM_ACTIVITY and execute the following sql query:

Ensure that you replace the date with the date up to which you want the Activity Log be purged.
DELETE FROM OKM_ACTIVITY WHERE ACT_DATE < '2020-09-05 09:30:04';
ANALYZE TABLE OKM_ACTIVITY;

Wait patiently until the database query finishes – that can take up to 30 minutes, depending on your setup.

Tags:
Was this article helpful?
Dislike 0
Views: 6

Search