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.
Views: 6