How to purge TAC repositories to increase memory

Overview

In several projects, you can have performance issues due to memory problems. In fact, some TAC repositories take a lot of memory, and it is possible to purge them to increase memory.


Environment

This issue can arise in all Talend environments.


Resolution

It is possible to add extra parameters in the configuration.properties file to clean logs. The path to access to this file is apache-tomcat\webapps\org.talend.administrator\WEB-INF\classes.

The following parameters must be added to the configuration.properties file, and you have to reboot the tomcat server after updating the file.

configuration.file 

### Temporary data cleaning parameters ###

# Time in seconds between each cleaning action, set
with 0 to disable all cleanings
scheduler.conf.cleaning.frequencyCleaningAction=600

# Time in seconds before cleaning executions logs
from the current date, 3 months=3*30*24*60*60=7776000, set with 0 to disable
delete action with this method
scheduler.conf.cleaning.maxDurationBeforeCleaningOldExecutionsLogs=0

# Max executions logs to keep, set with 0 to disable
delete action with this method.
scheduler.conf.cleaning.maxOldExecutionsLogs=1000

# Time in seconds before cleaning archives jobs from
the current date, 3 months=*30*24*60*60=7776000, set with 0 to disable delete
action with this method
scheduler.conf.cleaning.maxDurationBeforeCleaningOldJobs=0

# Max archive jobs to keep, set with 0 to disable
delete action with this method.
scheduler.conf.cleaning.maxOldJobs=3
Version history
Revision #:
11 of 11
Last update:
‎11-26-2018 11:11 AM
Updated by:
 
Labels (2)
Comments
Employee

So, TAC, upon reboot, will delete these parameters from the confguration.properties file, and that is what is meant by 'Temporary' cleaning parameters, as in, they are only there temporarily, even if you want them there permanently?

 

And then they will be set as entries in the TAC 'configuration' table?

 

 

Employee

Yea, these parameters will be deleted from the configuration.property file after the restart of TAC, and the defined values will be inserted into the TAC 'configuration' table on the DB, see (row) details in the screen capture below:

 

Cleaning.PNG

Employee

the file configuration.property does not exist.

The correct name is configuration.properties

Community Manager

Thanks Denis, fixed now.