Since upgrading to 12.2.x We have noticed our collector DB sizes increase quiet dramatically and appears to be down to the filestore storage_system_package table, which contains around 6gb.
I would assume that anything in the filestore system_package table can now be truncated once deployment have been completed?
Best answer by TonyAndres
Hello James,
Future upgrades will refer to this table to ensure the correct packages are upgraded, so it is not recommended that this table be truncated. Doing so will negatively affect future upgrades.
Antonio Andres
Senior Technical Support Engineer | ScienceLogic
Hello James,
Future upgrades will refer to this table to ensure the correct packages are upgraded, so it is not recommended that this table be truncated. Doing so will negatively affect future upgrades.
Antonio Andres
Senior Technical Support Engineer | ScienceLogic
Hi @TonyAndres will it then be so that each update package will be added into collector database, so each update will add some 6GB into database? Or will there only be the last update?
Hello Teppo,
This table can get large, however, assuming that the collector is sized properly per our Collector Sizing guide here System Requirements, this should not cause any issues with space availability.
Antonio Andres
Senior Technical Support Engineer | ScienceLogic
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
