Deployment history retention and automation data source in "long time" running istances,

(Paolo) #1

Hi all,
I have a director installation feeding an icinga2 module trough the automation module. I’ve noticed that over time the deployment history and the imported data local copy is reaching non neglectable size in mysql database tables even if my numbers are not so big.

“icingacli director housekeeping tasks” tells there is nothing to clean and mysql optimize has not shrunk director_generated_file and imported_rowset_row tables meaningfully.

Anyone knows:
The right way to apply some kind of retention to deployment history ?
A convenient way to drop and re import all automation data sources tables without wracking icinga2 istance ?