From cfad22b42c2b3bbe04697a31644c925eff8e6a1a Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Fri, 15 Apr 2016 17:07:02 -0400 Subject: [PATCH] LP#1570909 User activity purge release notes Signed-off-by: Bill Erickson Signed-off-by: Chris Sharp Signed-off-by: Mike Rylander --- .../Administration/user-activity-purge.adoc | 29 +++++++++++++++++++ 1 file changed, 29 insertions(+) create mode 100644 docs/RELEASE_NOTES_NEXT/Administration/user-activity-purge.adoc diff --git a/docs/RELEASE_NOTES_NEXT/Administration/user-activity-purge.adoc b/docs/RELEASE_NOTES_NEXT/Administration/user-activity-purge.adoc new file mode 100644 index 0000000000..03522cbf0a --- /dev/null +++ b/docs/RELEASE_NOTES_NEXT/Administration/user-activity-purge.adoc @@ -0,0 +1,29 @@ +Purge User Activity +^^^^^^^^^^^^^^^^^^^ + +User activity types are now set to transient by default for new +Evergreen installs.. This means only the most recent activity entry per +user per activity type is retained in the database. + +This change does not affect existing activity types, which were set to +non-transient by default. To make an activity type transient, modify the +'Transient' field of the desired type in the staff client under Admin -> +Server Administration -> User Activity Types. + +Setting an activity type to transient means data for a given user will +be cleaned up automatically if and when the user performs the activity +in question. However, administrators can also force an activity +cleanup via SQL. This is useful for ensuring that all old activity +data is deleted and for controlling when the cleanup occurs, which +may be useulf on very large actor.usr_activity tables. + +To force clean all activity types: + +[source,sql] +------------------------------------------------------------ +SELECT actor.purge_usr_activity_by_type(etype.id) + FROM config.usr_activity_type etype; +------------------------------------------------------------ + +NOTE: This could take hours to run on a very large actor.usr_activity table. + -- 2.43.2