How to reduce OC_Activitiy table

#1

Running with MySQL. After a couple of months, the database table oc_activity gets quite big, 3.3GB. Is there any way to reduce the size of this? or it will keep growing?

0 Likes

#2

Add a line in /config/config.php:

'activity_expire_days' => 365,

365 is the default value. Set it to 90 or less.

https://docs.nextcloud.com/server/12/admin_manual/configuration_server/config_sample_php_parameters.html#app-config-options

0 Likes