• Table "OKM_ACTIVITY" in database

  • We tried to make OpenKM as intuitive as possible, but an advice is always welcome.
We tried to make OpenKM as intuitive as possible, but an advice is always welcome.
Forum rules: Please, before asking something see the documentation wiki or use the search feature of the forum. And remember we don't have a crystal ball or mental readers, so if you post about an issue tell us which OpenKM are you using and also the browser and operating system version. For more info read How to Report Bugs Effectively.
 #23424  by turtleizzy
 
We have been using OpenKM for 9 months, total number of files reached 3000 and total size of repository reached 30G. The whole system was reinstalled once with repository restored after 6 months of usage because of significant increase in latency of web interface. Despite of a few problems while restoring repository ( security data was completely lost after restoring the repository, but we managed to rebuild them), eventually everything worked.

We ascribed the decrease in efficiency to the limitation of built-in HSQL when the size of database is too large ( at the time of reinstallation, built-in HSQL database reached 500M ). So we switched to mySQL database when we rebuilt the system.

After the new system was set up for 3 months, I found table "OKM_ACTIVITY" enlarges rapidly with no sign of reducing. This table seems to be saving activity log since the system was built, and this table takes up 163M in mySQL database after 3 months of usage. Although there was no apparent sign of efficiency deterioration up till now, eventually this table will cause problem as long as its size monotonously increases.

My question is, is it safe to purge this table manually, or is it possible to add a option for administrators to manage the activity log in administration panel?

Thanks in advance!
 #23429  by jllort
 
Clean activity log table will never have administration panel option, this is not the idea because the companies have different policies. The solution is each one build their own crontab task to export, clean etc... under their own preservation policies.
 #23495  by pavila
 
This table is used mainly to trace users actions but also used by others. I recommend always to keep the last month entries because this information is used to generate the information in the Dashboard.
 #43304  by openkm_user
 
If we are not going to use Dashboard, is it safe to purge this table completely? Our initial import logs are not needed for now, and activity.log.actions property is unavailable in Community version (?) so we are not able to manage which to log and which not to. Now the table has got 2.5 million records and we are still importing documents, seems like a dead weight to have these unusable data (and waste of storage).
 #43306  by jllort
 
We suggest periodically clean OKM_ACTIVITY data ( export before if you need some audit on future ). Also you can clean OKM_DASHBOARD.
 #43307  by openkm_user
 
Thank you, is there anyway that we could have the activity.log.actions property to manage logs?

About Us

OpenKM is part of the management software. A management software is a program that facilitates the accomplishment of administrative tasks. OpenKM is a document management system that allows you to manage business content and workflow in a more efficient way. Document managers guarantee data protection by establishing information security for business content.