topic Re: archive & purge procedures in Alfresco Archive

archive & purge procedures

mdaviot — Mon, 17 Sep 2012 15:01:34 GMT

Hi,Are there any recommendations to keep the database healthy in a production environment ? For instance, a list of tables (or better, scripts) which should be archived and purged on a regular basis to keep performance optimal ?Thanks and regardsMichel

Re: archive & purge procedures

jbarrez — Mon, 17 Sep 2012 15:37:49 GMT

Activiti keeps its runtime tables minimal, to keep things fast.

All the stuff in the history tables could be archived. There are no foreign keys from history to runtime.
But it of course depends on your usage of the history: are you querying and displaying history info anywhere? If so, it might not be as easy to remove the history.

Of course, if you don't need the history, you could also turn it off completely.

Re: archive & purge procedures

mdaviot — Mon, 17 Sep 2012 16:27:01 GMT

OK, seems consistent with what we understood so far !

Re: archive & purge procedures

leggebroten — Mon, 20 Jul 2015 19:43:31 GMT

WARNING!!!
At least in 5.16.1 purging the history tables will eliminate ALL data in the activiti-explorer's "Administration" page.

While I expected that the "Completed process instances" would be empty I was stunned to see that "Running process instances" were also nuked.

Re: archive & purge procedures

jbarrez — Thu, 23 Jul 2015 09:23:30 GMT

Yes, that screen uses the history tables for all its queries. The purge query you use should not delete rows that dont have an end time yet.